poojavb

what error are u getting??? things u can check 1. check the datatype ...it shud be number related datatype 2. check the values u r passing to the date column.... 3. the value for date shud be in the same format as it is there in database.... it worked for …

[QUOTE=Smalls;1757641]What I'm trying to do is have a login type windows form to take a user name and password then compare these with data in the db then open an admin type form. I've been trying to get this to work for a few days now with no luck, about …

If login is ur startup form u cannot close it else ur application will be closed... set the form as hide or visible false before showing the other form.... and then show ur main form

write the following code in ur product combobox selection changeevent as below Dim conn As New SqlConnection(ConnectionString) Dim category As String category = cboCategory.Text Dim strSQL As String = "SELECT pt.productidID,pt.ProductName FROM ProductTable pt, categoryTable ct where ct.CategoryName='" & category & "' and pt.categoryid=ct.categoryid" Dim da As New SqlDataAdapter(strSQL, conn) …

u can use a datetimepicker to show the from date and to date.... I will give my example to u... I have one form in which I have two datepickers one for from date and the other one to date...one button to close the form and the second one to …

Please specify more details....

According to me ur Datatype is not correct.... try using .Add("@callup", SqlDbType.VarChar) .Add("@statecode", SqlDbType.VarChar) use SqlDbType instead of OleDbType

Instead of using parameters try it with the text boxes it self.... Dim cmd As New SqlCommand("insert into dbo.RMA values ('"+TxtRMA.Text+"','"+TxtVendor.Text+"','"+TxtDevice.Text+"','"+TxtSN.Text+"','"+TxtModel.Text+"','"+TxtProblem.Text+"','"+TxtDate.Text+"')")

Folder name such as da12e5154f6b530007fd9e got automtically created in my system... Can anyone please tell me why such folders get created and how can I delete it...

[QUOTE=artemix22;1764351]i am so confuse dude.. why in my visual studio 2010 ultimate didn't show crystal report gallery? after i click "add new item" and add crystal report, it just show me SAP page that say "learn and download". i have install SAP crystal report runtime engine for .NET framework 4(32-bit). …

As it is a number datatype a null value wont be stored in the column....it will store 0 as null value.... change it to text and then u can save a null value....

I have one parrot- Mitthi, 5 fishes and one dog - Buzo

The values in datagrid view will be entered manually or thru database ??? please explain in detail...

Hello, I am stuck with this problem.... I have few folders that contains a filename as **registration.txt** --- note the folder names are different since as and when a new user will register a folder gets created with its name and then the text file with the details of the …

First u have to validate all the conditions and if all the conditions are passed then save to database.... Like if emailvalidation = false or other things like name and so on then do this else save to database

i think it should be this way Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Form1.Personal_InfoTableAdapter.Insert(Me.TextBox1.Text, Me.TextBox2.Text, _ Me.TextBox3.Text, Me.TextBox4.Text, _ Me.TextBox5.Text, Me.TextBox6.Text, _ Me.TextBox7.Text, Me.TextBox8.Text, _ Me.TextBox9.Text, Me.TextBox10.Text) MsgBox("Complete") Just check once

My PC has 3 drives C, D, E...when I insert the removable CD drive it should detect that the drive is the F:... it may vary for different systems...how can I find which will can be the CD drive... I had written the following code Try For Each drive In …

Below example is in MS SQL...same can be done in Access database just change the SQLCommant to OLEDBCommand First open the connection and then Dim myCommand As SqlCommand myCommand = New SqlCommand("CREATE TABLE Tablename (col1 datatype1,col2 datatype2)", myconn) 'where myconn is the connection object myCommand.ExecuteNonQuery() 'Keep adding the table names …

Try textbox_TextChangeEvent Label1.Text=Textbox1.text

Hello Friends, Can anyone tell me how to increment a String variable by 1 in database. Suppose the database table has value as SL1000 and we want the next value to be SL1001. What should be done for such type of requirement in java.

Create a module in your vb.net project.... create functions for open connection and close connection.... In open connection give the database complete connection and in close connection just close the connection object..... To call the connections in the form u can call the functions respectively.... find the code below its …

Label1 will display the number of days.... Dim count = 0 Dim totalDays = (DTLeavePayTo.Value - DTLeavePayFrom.Value).Days Dim startDate As Date For i = 0 To totalDays Dim weekday As DayOfWeek = startDate.AddDays(i).DayOfWeek If weekday <> DayOfWeek.Sunday Then count += 1 End If Next Label1.Text = count

User ID comes first.... "Provider=_______;Data Source=_________;User Id=__________;Password=__________;"

To take the back up in Text format on disk Public Sub WritingTo_Textfiles(ByVal TableName As String) Try 'Open connection here Dim line As String Dim mysqlCommand As SqlCommand mysqlCommand = New SqlCommand("SELECT * FROM " & TableName & " ", myconn) Dim myReader As SqlDataReader = mysqlCommand.ExecuteReader Dim fileName As …

Table name shud not contain space

Date variable is a keyword so try giving some other name in ur database

The save data code is given in the above thread.... > Private Sub btnsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsave.Click > Dim con As New SqlClient.SqlConnection > Dim com As New SqlCommand > Dim adap As New SqlDataAdapter > Dim ds As New DataSet > con = …

Need help while working with timer.... I am trying to do the database restoring part.... When the user clicks on the restore database button the progress bar shud be shown and as soon as the restoring is completed the progress bar shud stop and display success msg... Right now I …

Add a try catch block around ur sql statements and the insert sql is not correct cmd.CommandText = "INSERT INTO table([Name], [Comment], [emailaddress]) VALUES('" + txtname + "','" + txtcomment+ "','" + txtemail + "')"

ur pie variable sets a new form every time so the value in the old form1 does not get updated Comment the statement where u have declared the pie variable and just call the form name where u are declaring the variable to label Like below 'Dim pie As New …