普通查询

private void btnselect_Click(object sender, System.EventArgs e)
  {
     //------文本框定义条件------
           string coursename = this.name.Text.Trim();
     string sql = "select * from course where cname like '"+coursename+"%'";
           //------连接字符串-------
     string connString = @"server = .; integrated security = sspi; database = 学生管理";
   SqlConnection conn = new SqlConnection(connString);
           //------定义数据集--------
   SqlDataAdapter da = new SqlDataAdapter();
   da.SelectCommand = new SqlCommand(sql,conn);

   DataSet ds = new DataSet();
   da.Fill(ds,"coursename");
           //-------由文本框查询的结果填充-------
   dataGrid1.SetDataBinding(ds,"coursename");
  }