string con = "server=127.0.0.1;user id=root;password=;database=db";MySqlConnection sqlconn = new MySqlConnection(con);sqlconn.Open();string sql = "select * from users where NAME=?NAME;";MySqlCommand cmd=new MySqlCommand (sql,sqlconn);cmd.Parameters.Add("?NAME", MySqlDbType.VarChar).Value ="張山"; MySqlDataAdapter myda = new MySqlDataAdapter(cmd);DataTable dt = new DataTable();myda.Fill(dt);myda.Dispose();sqlconn.Dispose();sqlconn.Close();dataGridView1.DataSource = dt;users表ID bigintname varchar(500);
2 回答
米脂
TA貢獻1836條經驗 獲得超3個贊
string con = "server=127.0.0.1;user id=root;password=;database=db";
password= 后面啥都沒有
string sql = "select * from users where NAME=?NAME;";
改成string sql = "select *,@NAME from users";不是什么條件，我暈
cmd.Parameters.Add("@NAME", MySqlDbType.VarChar).Value ="張山";就好了，不是Oracle
慕少森
TA貢獻2019條經驗 獲得超9個贊
string sql = "select * from users where NAME=?NAME;";改為string sql = "select * from users where NAME=@NAME";cmd.Parameters.Add("?NAME", MySqlDbType.VarChar).Value ="張山";改為：cmd.Parameters.Add("@NAME", MySqlDbType.VarChar).Value ="張山";
添加回答
舉報
0/150
提交
取消