- 首先了解MySql的相关知识;
C#连接数据库:
1.建立控制台项目;
2.添加MySql.Data.dll
3.搜索MySql,选择MySql.Data 并添加
4.测试 建立连接
1 using System; 2 using MySql.Data.MySqlClient; 3 namespace CSharp连接数据库 4 { 5 class Program 6 { 7 static void Main(string[] args) 8 { 9 string ConnectStr = "server=127.0.0.1;database=lk;user=root;password=root;"; 10 MySqlConnection conn=new MySqlConnection(ConnectStr); 11 try 12 { 13 conn.Open(); 14 Console.WriteLine("已经建立连接"); 15 } 16 catch (Exception e) 17 { 18 Console.WriteLine(e); 19 throw; 20 } 21 finally 22 { 23 conn.Close(); 24 } 25 Console.Read(); 26 } 27 } 28 }
5.MySql操作
创建MySqlCommand对象
查询操作
string sql = "select * from users;";
MySqlCommand cmd = new MySqlCommand(sql,conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString());
}
插入
string sql = "insert into users(username,password) values('ddsda','44');";
MySqlCommand cmd = new MySqlCommand(sql, conn);
int result = cmd.ExecuteNonQuery();
更新
string sql = "update users set username='sdadadsa',password='444444' where id=4;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
int result = cmd.ExecuteNonQuery();
删除
string sql = "delete from users where id=4;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
int result = cmd.ExecuteNonQuery();