aminevb

I can't add infromation to my Projet.mdb ! please help me ! this is my code Try Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = C:\projet.mdb" Dim Save As New OleDbCommand Dim Conn As New OleDbConnection(ConStr) Save.CommandText = "INSERT INTO Client(Nom,Prenom,Adresse,Téléphone,date) VALUES(@p1,@p2,@p3,@p4,@p5)" Save.Parameters.AddWithValue("@p1", TextBox1.Text) Save.Parameters.AddWithValue("@p2", TextBox2.Text) Save.Parameters.AddWithValue("@p3", TextBox3.Text) Save.Parameters.AddWithValue("@p4", …

hello i have a database ! and i want to affect it to a datagridview and make a Groupbox where i add a buttons ( add , update , delete ) to controle the datagridview and database ^^ Can someone show me how to do it thank you

i have an error in a Button click : Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = C:\Users\amine\Documents\projet.mdb" Dim Conn As New OleDbConnection(ConStr) Dim Save As New OleDbCommand("INSERT INTO Client(Nom,Prenom,Adresse,Téléphone,[date]) VALUES(@p1,@p2,@p3,@p4,@p5)", Conn) Try Save.Parameters.AddWithValue("@p1", TextBox1.Text) Save.Parameters.AddWithValue("@p2", TextBox2.Text) Save.Parameters.AddWithValue("@p3", TextBox3.Text) Save.Parameters.AddWithValue("@p4", TextBox4.Text) Save.Parameters.AddWithValue("@p5", DateTimePicker1.Text) Conn.Open() If (Save.ExecuteNonQuery()) Then MsgBox("Ajout réussi …