坑点:
- 首先需要添加引用:MySQL.data
- 其次需要
using MySql.Data.MySqlClient;
- 连接MySQL数据库字符串:
string connectionString = "server=localhost;user id=*******;password=*******;database=*******";
- 注意不可以这么用:
string query = "insert into return(CarID, IDCard, ReturnTime, Type, MoneyPaid, Color) values('" + idcard + "','" + name + "','" + telephone + "','" + address + "','" + add + "','" + add1 + "');";
只能这么用:string query = "insert into `Return`(CarID, IDCard, ReturnTime, Type, MoneyPaid, Color) values('" + idcard + "','" + name + "','" + telephone + "','" + address + "','" + add + "','" + add1 + "');";
return可能是MySQL的关键字,不可以直接使用,会报错,只能加引号(键盘上数字1的前面),来告诉数据库这是一个表名。