MySqlConnectionsqlCon= new MySqlConnection("Database=数据库名字;Data Source=本地IP(127.0.0.1);User Id=用户名;Password=用户密码");
或者:
MySqlConnectionsqlCon= new MySqlConnection("server=服务器的ip地址;user id=用户名;password=用户密码;database=数据库名字");
或者:
string M_str_sqlcon = "server=服务器ip地址;User Id=用户名;password=用户密码;Database=数据库名字";//根据自己的设置
MySqlConnection sqlCon = new MySqlConnection(M_str_sqlcon);
注释:server=服务器ip地址;User Id=用户名;password=用户密码;Database=数据库名字,这几个的顺序可以调换,只要对准每个字符串和标识符就好了。
(2)执行sql命令:
//设置查询命令
MySqlCommand mycmd= new MySqlCommand("select * fromt_dept whereTITLElike '%p%'", sqlCon);
string conn = "Data Source=127.0.0.1;User ID=root;Password=;DataBase=bookmanagement";
MySqlConnection con = new MySqlConnection(conn);
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from admin", con);
MySqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
con.Close();//还运行不出来?????