运用技术:ADO.NET access database object
1.mysqlconnection 数据库连接对象
2.mysqlcommand sql命令执行对象(增删改)
3.mysqldataadapater 数据适配器(数据查询对象)
1.1连接字符串 server=localhost prot=3306 database=test uid=root pwd=123
open()打开连接
close()关闭连接
1.2C#连接 框架版本要求.NET FRAMEWORK4.5.2以上
添加引用 mysql.data.dll
前面增加代码 using MySql.Data.MySqlClient;
String constr = "server=127.0.0.1;userid=root;password=;database=mysql;charset=utf8";
MySqlConnection conn = new MySqlConnection(constr);
conn.Open();
string sql = String.Format("select * from login where name = '{0}' and pwd = '{1}'",txtname.Text.Trim(),txtpwd.Text.Trim());
MySqlCommand comm = new MySqlCommand(sql ,conn);
//mysqldatareader 数据读取器
MySqlDataReader reader= comm.ExecuteReader();
//MessageBox.Show(reader.HasRows.ToString());
if (reader.HasRows)
{
MessageBox.Show("登录成功");
this.Hide();
Form2 form2 = new Form2();
form2.Show();
}
else
{
MessageBox.Show("登录失败");
}