how to insert the values entered in the windows form into the mysql db and to display the selected/all values in the windows form

Question

Hi I have a winform which contains two text boxes(namepassword) one dropdown list to select city and one button.Now i want to know how to write the fields in the db table and whats the code i need to write inside the button_click method inorder to insert the values i have enterd in the winform to db and retrive the row/rows based on a simple condition.I know how to connect into the database.

Lisa · Answer

open a connection to the database retrieve the values of the fields you want to save into some local variables and create an insert command like insert into table1 (col1col2) values (var1 var2) and run a simple command.executequery function and it should all be in the database now unless and exception occurs. Thanks Lisa

Lisa · Answer

Thanks.

joakim wireen · Answer

private void Insert_Click( object sender EventArgs e) { MySqlConnection conn = new MySqlConnection (); MySqlCommand cmd = new MySqlCommand (); cmd.CommandText( INSERT INTO phone_book (name number) VALUES ('John Doe' '555-1212' ); cmd = conn.CreateCommand(); using (conn) { if (cmd.ExecuteNonQuery > 0) { //more than 1 row was affected by the query } } } private void Select_Click( object sender EventArgs e) { MySqlConnection conn = new MySqlConnection (); MySqlCommand cmd = new MySqlCommand (); MySqlDataReader reader; cmd.CommandText( select * from users ); cmd = conn.CreateCommand(); using (conn) { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { //now you can access the data via the reader. There is a method for each datatype ;) For instance : reader.GetString( username ); } } }

Rajendra Deopura · Answer

Dear If you know how to connect to mysql database then where is the problem ? Thanks