private void button1_Click(object sender, EventArgs e)
{
string str = "select * from Students";
DBcon con = new DBcon();
DataSet ds = con.GetDataSet(str, "Students");
this.dataGridView1.DataSource = ds.Tables["Students"].DefaultView;
}
private void button1_Click(object sender, EventArgs e)
{
DBcon Db = new DBcon();
string str = "select * from Table_users";
DataSet ds = Db.GetDataSet(str, "Table_users");
this.dataGridView1.DataSource = ds.Tables["Table_users"].DefaultView;
}
private void button6_Click(object sender, EventArgs e)
{
string str1 = comboBox1.Text.ToString();
string str2 = textBox8.Text.ToString().Trim();
if (str1 == "" || str2 == "")
{
MessageBox.Show("输入不能为空！");
return;
}
string str = "select * from Students where " + str1 + "='" + str2 + "'";
DBcon con = new DBcon();
DataSet ds = con.GetDataSet(str, "Students");
this.dataGridView1.DataSource = ds.Tables["Students"].DefaultView;
}
