--æ¾ç¤ºï¼
using (SqlConnection conn = new SqlConnection("server=(SQLæå¡å¨å称);user id=sa;password=ï¼SQLå¯ç ï¼;database=è¿æ¥çæ°æ®åº"))
{
string sql = "select * from mess where stu_name=@a,@b,@c,@d,@e";
SqlCommand com = new SqlCommand(sql,conn);
com.Parameters.AddWithValue("@name", textBox1.Text);
com.Parameters.AddWithValue("@name", textBox2.Text);
com.Parameters.AddWithValue("@name", textBox3.Text);
com.Parameters.AddWithValue("@name", textBox4.Text);
com.Parameters.AddWithValue("@name", textBox5.Text);
conn.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
textBox1.Text = dr["第ä¸åçåå"].ToString();
textBox2.Text = dr["第äºåçåå"].ToString();
textBox3.Text = dr["第ä¸åçåå"].ToString();
textBox4.Text = dr["第æåçåå"].ToString();
textBox5.Text = dr["第äºåçåå"].ToString();
}
ä¿®æ¹
}
}
string sql = "update mess set 第ä¸åçåå=@a,第äºåçåå=@b,第ä¸åçåå=@c,第ååçåå=@d,第äºåçåå=@e";
SqlConnection conn = new SqlConnection(sqlconn);
conn.Open();
SqlCommand com = new SqlCommand(sql, conn);
com.Parameters.AddWithValue("@a", textBox1.Text);
com.Parameters.AddWithValue("@b", textBox2.Text);
com.Parameters.AddWithValue("@c", textBox3.Text);
com.Parameters.AddWithValue("@d", textBox4.Text);
com.Parameters.AddWithValue("@e", textBox5.Text);
com.ExecuteNonQuery();
MessageBox.Show("ä¿®æ¹æå");
}
}
}
温馨提示:答案为网友推荐,仅供参考