Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim oConn As MySqlConnection
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim myData As New DataTable
oConn = New MySqlConnection()
oConn.ConnectionString = "server=127.0.0.1;User Id=monuser;password=monpass;Persist Security Info=True;database=pmvsocial"
myCommand.Connection = oConn
'passe la requete au moteur mysql pour l'enregistrement
Try
oConn.Open()
myCommand.CommandText = "BailleurResp"
myCommand.CommandType = CommandType.StoredProcedure
myCommand.Parameters.AddWithValue("@nombail", TextBox1.Text)
myCommand.Parameters("@nombail").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@cptadr", TextBox9.Text)
myCommand.Parameters("@cptadr").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Numrue", TextBox2.Text)
myCommand.Parameters("@Numrue").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@nomrue", TextBox3.Text)
myCommand.Parameters("@nomrue").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Cp", TextBox5.Text)
myCommand.Parameters("@Cp").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Ville", TextBox4.Text)
myCommand.Parameters("@Ville").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Tel", TextBox6.Text)
myCommand.Parameters("@Tel").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@fax", TextBox7.Text)
myCommand.Parameters("@fax").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@email", TextBox8.Text)
myCommand.Parameters("@email").Direction = ParameterDirection.Input
'param resp
myCommand.Parameters.AddWithValue("@genre", TextBox18.Text)
myCommand.Parameters("@genre").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@nomres", TextBox10.Text)
myCommand.Parameters("@nomres").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@prenom", TextBox17.Text)
myCommand.Parameters("@prenom").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Fonction", TextBox16.Text)
myCommand.Parameters("@Fonction").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@telresp", TextBox15.Text)
myCommand.Parameters("@telresp").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Mobresp", TextBox13.Text)
myCommand.Parameters("@Mobresp").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Faxresp", TextBox14.Text)
myCommand.Parameters("@Faxresp").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@Emailresp", TextBox12.Text)
myCommand.Parameters("@Emailresp").Direction = ParameterDirection.Input
myCommand.Parameters.AddWithValue("@note", TextBox11.Text)
myCommand.Parameters("@note").Direction = ParameterDirection.Input
myCommand.ExecuteNonQuery()
Catch ex As MySql.Data.MySqlClient.MySqlException
Console.WriteLine(("Error " & ex.Number & " has occurred: ") + ex.Message)
MessageBox.Show("Connexion à la base impossible pour l'enregistrement du Bailleur: " & ex.Message)
Finally
oConn.Dispose()
End Try
Partager