Good day I want to an example in C# not VB of how to Programme in Windows Forms a Data entry update and Delete to SQL. MSN only has in VB that.
The programe must have a CustomerID in in it that is a primary key.
Thanks for any help
0
1 answers
using MySql.Data.MySqlClient;
string conn = "server=localhost;database=database_name;uid=root;password=xxxxxxxxx";
int Customer_ID;
string Customer_Name;
MySqlConnection myConn = new MySqlConnection(conn);
myConn.Open();
MySqlCommand MySqlCmd = new MySqlCommand();
MySqlCmd = new MySqlCommand("SELECT Customer_ID, Customer_Name from Customer_Table", myConn);
MySqlDataReader reader = MySqlCmd.ExecuteReader();
while (reader.Read())
{
Customer_ID = Convert.ToInt32(reader["Customer_ID"]);
Customer_Name = Convert.ToString(reader["Customer_Name"]);
}
reader.Close();
myConn.Close();
answered one year ago by:
494