Return "Insert into maTable" & _ "(login, password, question, reponse) " & _ "values ('" & username & "','" & _ mdp & "','" & _ quest & "','" & _ rep & "')"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPublic Sub createBase() Dim tblu As New ADOX.Table() Dim keyu As New ADOX.Key() 'déclaration BASE Dim db As New ADOX.Catalog 'création BASE db.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & createChemin()) tblu.Name = "USERS" tblu.Columns.Append("login", ADOX.DataTypeEnum.adWChar, 15) tblu.Columns.Append("password", ADOX.DataTypeEnum.adWChar, 8) tblu.Columns.Append("question", ADOX.DataTypeEnum.adWChar, 30) tblu.Columns.Append("reponse", ADOX.DataTypeEnum.adWChar, 10) db.Tables.Append(tblu) keyu.Name = "cleprimaireu" keyu.Type = ADOX.KeyTypeEnum.adKeyPrimary keyu.RelatedTable = "USERS" keyu.Columns.Append("login") tblu.Keys.Append(keyu) End Sub
Public Sub InsertRow(ByVal insertSQL As String) MessageBox.Show(insertSQL) Dim con As ADODB.Connection Dim rs As ADODB.Recordset con = New ADODB.Connection con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & createChemin() con.Open() rs = con.Execute(insertSQL) rs.Fields.Refresh() rs = Nothing con.Close() con = Nothing End Sub
Dim con As New OleDb.OleDbConnection Public Sub insertUser() con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & createChemin() Dim cmd As OleDb.OleDbCommand Dim sqlinsert As String sqlinsert = "INSERT INTO USERS (login, password, question, reponse) VALUES (@vlogin, @vpassword, @vquestion, @vreponse)" cmd = New OleDb.OleDbCommand(sqlinsert, con) cmd.Parameters.AddWithValue("vlogin", inscription.TBlogin.Text) cmd.Parameters.AddWithValue("vpassword", inscription.TBmdp.Text) cmd.Parameters.AddWithValue("vquestion", inscription.CBquest.Text) cmd.Parameters.AddWithValue("vreponse", inscription.TBrep.Text) cmd.Connection.Open() cmd.ExecuteReader() cmd.Connection.Close() End Sub
dim Con As New Connection dim Rec As New Recordset dim SQL As New String con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & App.path & "\Nom_dela_Bdd.Accdb" Rec.CursorLOcation=adUseClient Rec.Open SQL,Con,adOPenDynamic,adLockOptimistic,adCmdText '********Pour Inserer ******************** Insert Into Table(Champs1,Champs2) Value ('" & text1.text & "','" & text2.text & "')" Con.Close
Public Function insert_user(ByVal login As String, ByVal mdp As String, ByVal question As String, ByVal rep As String) As Boolean connection() Try 'Indiquer le type de commande Cmd.CommandType = CommandType.Text Cmd.CommandText = "INSERT INTO USERS (LOGIN, MDP, QUESTION, REPONSE) VALUES ('" & login & "','" & mdp & "','" & question & "','" & rep & "')" 'on exécute la commande Cmd.ExecuteNonQuery() 'Fermer la connexion Cnx.Close() Return True Catch ex As Exception MsgBox("Erreur dans l'insertion de d'un USERS" & vbCrLf & ex.Message, , "Erreur") Return False End Try End Function