Worker Andrew = new Worker(); Andrew.Name = "Andrew"; Andrew.HairColor = Color.Black; Worker Steve = new Worker(); Steve.Name = "Steve"; Steve.HairColor = Color.Brown; //Connection string for the database MySqlConnection conn = new MySqlConnection("Server=localhost;Database=mydatabase;UID=root;PASSWORD=123456789;pooling=false"); MySqlCommand cmd = conn.CreateCommand(); cmd.Connection = conn; cmd.CommandText = "insert into workerdetails (Name, HairColor) values (@name1, @color1)"; cmd.Parameters.AddWithValue("@name1", Andrew.Name); cmd.Parameters.AddWithValue("@color1", Andrew.HairColor); cmd.CommandText = "insert into workerdetails (Name, HairColor) values (@name2, @color2)"; cmd.Parameters.AddWithValue("@name2", Steve.Name); cmd.Parameters.AddWithValue("@color2", Steve.MouseColor); conn.Open(); //MySqlDataReader reader = cmd.ExecuteReader(); //cmd.ExecuteReader(); cmd.ExecuteNonQuery(); conn.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)