Question

含有参数变量的sql语句，如何用C#语句表示。

string mysql = "SELECT Cname,Grade FROM student,score,course WHERE student.Sno = score.Sno" +
"and score.Cno = course.Cno and student.Sno =" + Convert.ToString(textBox1.Text) +
"and score.Text =" + Convert.ToInt32(comboBox1.Text);
程序在运行时没有结果出来，能帮我改改吗？

Answer 1

string mysql = string.Format("SELECT Cname,Grade FROM student,score,course WHERE student.Sno = score.Sno and score.Cno = course.Cno and student.Sno = '{0}' and score.Text = {1}",textbox1.Text,ComboBox1.Text);

追问

谢谢，出现结果了。

Answer 2

string mysql = "SELECT Cname,Grade FROM student,score,course WHERE student.Sno = score.Sno and score.Cno = course.Cno and student.Sno =‘" +Convert.ToString(textBox1.Text) +"’ and score.Text =‘" + Convert.ToInt32(comboBox1.Text)“’;”;