private void skinButton1_Click(object sender, EventArgs e)
{
SqlConnection conn = new Opreate().conn();
conn.Open();
string strCmd;
if (textBox1.Text.Equals("*"))
{
strCmd = "select * from Teacher_teaching";
}
else
{
strCmd = "select * from Teacher_teaching where " + skinComboBox1.Text + " = '" + textBox1.Text + " '";
}
//dtGrdViewSearch.Rows.Clear();
SqlDataAdapter myDataAdapter;
DataSet myDataSet = new DataSet();
myDataAdapter = new SqlDataAdapter(strCmd, conn);
myDataAdapter.Fill(myDataSet, "Teacher_teaching");
skinDataGridView1.DataSource = myDataSet.Tables["Teacher_teaching"];
conn.Close();
}
private void skinButton7_Click(object sender, EventArgs e)
{
SqlConnection Conn = new Opreate().conn();//到sqlsever的连接
Conn.Open();
string Sql = "select top 1 * from teacher order by tno desc";
SqlCommand comm = new SqlCommand(Sql, Conn); //command对象
SqlDataReader dr = comm.ExecuteReader(); //定义数据读取对象
if (dr.Read())
{
skinTextBox1.Text = (string)dr.GetValue(0);
skinTextBox2.Text = (string)dr.GetValue(1);
skinComboBox1.Text = (string)dr.GetValue(2);
skinComboBox2.Text = dr.GetValue(3).ToString();
}
Conn.Close();
}