110,538
社区成员
发帖
与我相关
我的任务
分享
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
this.DataBlist();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void DataBlist()
{
this.DataBlist("");
}
private void DataBlist(string ID)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("Select * from StudentID");
if (ID!=null && ID.Trim() !="")
{
sbSql.Append(" where ID=" + string.Format("{0}", ID));
//sbSql.Append(" where ID=" + string.Format("'{0}'", ID)); //字段为字符型
}
SqlConnection Sqlcon = new SqlConnection("server=.;database=Accp;uid=sa;pwd=123456");
SqlCommand sqlcom = new SqlCommand(sbSql.ToString(), Sqlcon);
SqlDataAdapter Adapter = new SqlDataAdapter(sqlcom);
DataTable dt = new DataTable();
Adapter.Fill(dt);
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
DataBlist(textBox1.Text.Trim());
}
}
}