界面上一个textbox,一个button然后选择(textbox比如指定查询的是姓名);如何实现,数据集我已经配置好,并能显示表里数据下面一段代码貌似有点错误,请指出,并解释下主要步骤。。谢了
string cmd = "select * from T_score where StrID='" + textBox1.Text + "'";
SqlCommand sql = new SqlCommand(cmd);
SqlConnection conn = new SqlConnection(@"Data Source=.\SqlExpress;AttachDBFilename=C:\Users\lw\Documents\Visual Studio 2010\Projects\WindowsFormsApplication1\WindowsFormsApplication1\Database1.mdf;Integrated Security=true ;User Instance=True;uid=sa;pwd=6288656");
try
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet DS = new DataSet(); adapter.SelectCommand = sql;
adapter.Fill(DS);
dataGridView1.DataSource = DS.Tables[0];
}
catch (SqlException o)
{
MessageBox.Show(o.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
sql.Connection.Close();
}
string cmd = "select * from T_score where StrID='" + textBox1.Text + "'";
SqlCommand sql = new SqlCommand(cmd);
SqlConnection conn = new SqlConnection(@"Data Source=.\SqlExpress;AttachDBFilename=C:\Users\lw\Documents\Visual Studio 2010\Projects\WindowsFormsApplication1\WindowsFormsApplication1\Database1.mdf;Integrated Security=true ;User Instance=True;uid=sa;pwd=6288656");
try
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet DS = new DataSet(); adapter.SelectCommand = sql;
adapter.Fill(DS);
dataGridView1.DataSource = DS.Tables[0];
}
catch (SqlException o)
{
MessageBox.Show(o.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
sql.Connection.Close();
}
确定StrID字段是你要查的姓名?