309 Posted Topics
 | what is the datatype??...if the datatype is varchar / text it wont increment beyond 10....same had happened with me.... I had to take int as the datatype and then increment it.... |
 | u need a read method...the reader is not able to read the data.... u r not using the read method and u are trying to get the values....that is why u are getting this error |
| | |
| | or in place of server can also add localhost.... to check ur server name u can use a query select @@SERVERNAME 'connection string Connection.ConnectionString = "Data Source = LocalHost\;Initial Catalog = DatabaseName;Integrated Security = True"  |
| | Can you just show ur code.... |
| | Re: blank value Since the datatype is number in ur access database the value returned to ur textbox will be 0...if u remove the default value for ur datatype number in the database it wont return any value... Make it blank to get the text box value as blank  |
| | U r not clear enough.....Please mention in detail....  |
| | Re: static in main() Static methods can not directly access any instance variables or methods but they can access them by using their object reference. Static methods may even access private instance variables via a object reference. All private instance variables are private to its class, they can be accessed by static methods or …  |
| | |
| | u can also do a select query with ur username and email in where condition and then if the reader is true then set the msg as already exists or allow the user for registration.... Below code is just to present u an idea.... Try Dim MySQL_Connection As SqlConnection = … |
 | Please do read the Member rules before posting....[Click Here](http://www.daniweb.com/community/rules) |
| | To do the print preview part u need to add the print priview control or Dialog on ur form.... |
| | Instead of `ClearTextBox(Me)` write the form name in which u want to clear the text boxes like ClearTextBox(Form1) |
| | Please be more clear and precise.... |
| | Could u tell the format how u should get 130102 ??? Still confused with ur requirement.... |
 | May be the below calculation will help u to convert the date to age String Dob=txtDOB.getText().trim(); DateFormat df = DateFormat.getDateInstance(DateFormat.MEDIUM, new Locale("en", "AU")); java.util.Date CurrentDate=new java.util.Date(); DateFormat FormattedDate=new SimpleDateFormat("dd/mm/yyyy"); String Currentformat=FormattedDate.format(CurrentDate); Dob=Dob.substring(Dob.lastIndexOf("/")+1); Currentformat=Currentformat.substring(Currentformat.lastIndexOf("/")+1); String Age=String.valueOf((Integer.parseInt(Currentformat))-(Integer.parseInt(Dob))); txtAge.setText(Age); |
| | Just a guess... ur select query does not have single inverted comma... sql = "Select * from SRuser where Uname = '" & name & "'" |
| | Check ur database connections....while retrieving the values from database..... |
| | its not like its line..... as soon as he reached the end of the line then it wraps..... > However wrapping occurs (ie) when I finish the like till the end |
| | The birthday calculation part u need it for some particular day or 15 days onwards..... Find the below query that will show the birthdays from current day to coming 15 days select ID, FName, MobNo, Email, BirthDate FROM Tablename where Day(BirthDate) between day(GETDATE()) and day(GETDATE()+15) and month(BirthDate) between month(GETDATE()) and … |
| | Re: Spaces detector Just an idea to start.....this will deal with ur first condition of spaces Dim s As String = "This is my Dog" Dim words As String() = s.Split(" "c) Array.Reverse(words) s = String.Join(" "c, words) |
| | Yes u can move ur code in some other module and then directly call the function or so.... like database connections could be in different modules.... the user inputs like u need a text or a number can be in different modules.... creating modules is very good step as if … |
 | Ok let me tell u what I have done.... I have a Datagridview in which I have added 6 columns manually through property window,,, On button click I have the following code....but before that declare two variables Dim rowvalue As String Dim cellvalue(20) As String then in button click write … |
| | Dim SmtpServer As New SmtpClient() Dim mail As New MailMessage() SmtpServer.Credentials = New Net.NetworkCredential("abc.def@gmail.com", "abc123def") SmtpServer.Port = 25 SmtpServer.Host = "mail.google.com" mail = New MailMessage() mail.From = New MailAddress("abc.def@gmail.com") mail.To.Add("abc.ljk@gmail.com") mail.Subject = "Testing" mail.Body = subject SmtpServer.Send(mail) MsgBox("mail sent sucessfully") Ur connections are correct...try putting ur credentials at first...the above … |
| | Assuming it to be a crystal report.....for paramaters.... u have an option as Parameter Fields in ur Field Explorer WIndow.... Right click on the parameter Field -> New -> a window will be opened -> Enter the parameter name and the type....and nothing.....->Click OK ->A parameter will get created.... In … |
| | Hello, My avatar pic is not getting updated....I changed my profile pic from a kitten to a design and even log off from Daniweb still its the same old avatar.... |
| | U need this code / idea in which programming laguage??? |
 | if u want to set the form size to maximum then change the windows state property of the form to Maximized |
| | Hello Friends, I have a doubt.... Can we set the windows form resolution according to pc screen resolution and even the control should be adjusted....is it possible??? eg. My screen resolution is 1366 X 768 and my form size is 1254, 709....but I want it so set according to the … |
| | just giving the synopsis of what u can do.... After creating the form and the search text box.... - in ur form tag u can add the methods action and specify the google search... - else mention the name of ur site....so that the search is performed within ur code … |
| | give same name for the radio button and just change the value....if the names are different it falls in different group <body> <input type="radio" name="test" value="a">a<br> <input type="radio" name="test" value="b">b<br> <input type="radio" name="test" value="c">c<br> <input type="radio" name="test" value="d">d</body> </body> |
| | Re: java code error When I tried ur code...it shows error that few of ur variables are not initialized....Please check the initialization of variables,,, Since I dont have ur BankAccount class I get the following errors varaibles cannot be resolved to a variable for the below variables interestRate pay cashNeeded |
| | Hello Friends, One help needed.... I have a product database....in which I have productid,prodname,inventoryvalue,reordervalue I have to design a email system that as soon as the product reaches the reorder level it shud generate an email.... but the condition is there will be many products in the database....and on one … |
| | Re: Datagridview Just displaying code is not enough for us to understand ur problem....do explain ur problem in detail... |
| | call this code on ur button click to display ur records in datagridview 'open connection Try Dim myCommand As New OleDbCommand With myCommand .CommandText = "SELECT * FROM tablename" .CommandType = CommandType.Text .Connection = Connection End With Dim dt As New DataTable dt.Load(myCommand.ExecuteReader) With DatagridView1 .AutoGenerateColumns = True .DataSource = … |
| | In short words..... import static java.lang.System; - It means u are just trying to import the namespace System import static java.lang.System.*; - It means u are trying to import all the namespaces that comes under System....no need to import the namespaces that comes under System again.... |
| | Is this what u r looking for??? Imports System.Data.SqlClient Public Class Form8 Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click Dim Openconnection As String Openconnection = Open_DB_Connection("form7 - Button1 click") Dim da As New SqlDataAdapter("SELECT Distinct Doctorid FROM DoctorRegister", Connection) Dim dt As New DataTable da.Fill(dt) With ComboBox1 … |
| | Do post your code after u solve it successfully so that it is helpful to others.... |
| | Hello Friends, One help is required.... I have a select query which is based on two criterias.... if the order is in process or if the order is received.... The datagridview will show all the records from the database,,,, I want to disable the rows in datagridview which will be … |
| | You will need a dot net professional version and after installing that u also need to change the framework from client to framework 4 |
| | Check which is ur startup form....if ur startup form is the same as the one u r closing then it will close the complete application.... dont use the `me.close` or `me.dispose`....use `Me.Hide` and try.... to check ur startup form click on Project -> Projectname properties -> Application tab -> Startup … |
| | Does your combo box selection result return only a single value??? Check what I have done...hope it helps u....set textbox AutoCompleteMode property to SuggestAppend Imports System.Data.SqlClient Public Class Form6 Private Sub Form6_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'Open connection Dim strSQL As String = "SELECT Distinct ID,FirstName FROM …  |
| | check ur syntax for delete "delete from STAFF where Staff ID like '" & txtKeyword.Text & "%" + "'" for ur update query try doing this... "update tablename set Student_Name='"+txtName.Text+"' where Student_HP_No='"+mtxPhoneNo.Text+"' and Student_Email='"+txtEmail.Text+"'" I am not so very sure but check if we can add spaces between column names....please … |
 | This is not a vb.net question....u shud try in web development section |
| | Ohh....I have posted in ur other duplicate post.... pasting it again........ To just populate ur datagrid with the values from database u can use the below code 'Open connection Dim myCommand1 As New SqlCommand With myCommand1 .CommandText = "SELECT * from Table" .CommandType = CommandType.Text .Connection = Connection End With … |
| | Hello Friends....One more doubt... I have a connection module in which I have written the open and close database connection.... if database connection is an error it will return false else if success it will return true the function of the modules will be called from the form code.... what … |
| | Please could you explain in detail....what problem are u actually facing.... |
 | checkbox1 - name checkbox2 - date give conditions in such a way that if checkbox1.checked = true then 'ur sql query which will show the result in datagridview elseif checkbox2.checked = true then 'ur sql query elseif checkbox1.checked = true and checkbox2.checked = true then 'ur sql query else 'means … |
 | May be u shud post this code under jsp section.... in this section we can help u with queries |
| | display the receipt using crystal report....it wll hold all the data....but those values shud be present in database... to calculate sum, the function is also available in reports...u can use it |
The End.