I have this code
Public Class Form1
Private connectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:/testn.mdb"
Dim conn As New System.Data.OleDb.OleDbConnection(connectionstring)
Dim cmd As New System.Data.OleDb.OleDbCommand
Private ssql As String
Dim dr As System.Data.OleDb.OleDbDataAdapter
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;data source=c:\nikhil\testn.mdb")
conn.Open()
Dim ssql As String = "insert into nikhil values( '1001','nikhil','99')"
cmd = New System.Data.OleDb.OleDbCommand(ssql, conn)
cmd.ExecuteNonQuery()
conn.Close()
End Sub
End Class
i wish to update data into table through a textbox. I tried using &textbox.text& but shows an error. I also want a combo box to do the same. also i wish to create a administrative username and password validation form. please help.
i used it like this
"insert into nikhil values(" & (TextBox1.Text) & ",'" & TextBox2.Text & "','" &_TextBox3.Text & "')"
sorry..its working
can anybody tell me however about user authentication