c#数据库连接代码

1.datagrid绑定

private void dataBind(string scomm)
  {
   string strCon="server=127.0.0.1;database=yangtao;user=sa;password=sa;";
   SqlConnection myConn = new SqlConnection ( strCon ) ;
   myConn.Open ( ) ;
   DataSet myDataSet = new DataSet ( ) ;
   SqlDataAdapter myCommand = new SqlDataAdapter ( scomm , myConn ) ;
   myCommand.Fill ( myDataSet) ;
   this.dgrdTest.DataSource = myDataSet;
   this.dgrdTest.DataBind();

   myCoon.Close();
 }

2.dropdownlist绑定

private void dorpSchNameBind(string strcomm)
  {
   string strCon="server=127.0.0.1;database=yangtao;user=sa;password=sa;";
   SqlConnection myConn = new SqlConnection ( strCon ) ;
   myConn.Open ( ) ; 
   SqlDataAdapter myCommand = new SqlDataAdapter ( strcomm , myConn ) ;
   myCommand.SelectCommand.CommandType = CommandType.Text;
   DataSet myDataSet = new DataSet ( ) ;
   myCommand.Fill ( myDataSet , "SCH" ) ;
   dropSchoolName.DataSource = myDataSet.Tables["SCH"].DefaultView;  
   this.dropSchoolName.DataTextField  ="SCHOOLNAME";
   this.dropSchoolName.DataValueField ="SCHOOLID";                  
   this.dropSchoolName.DataBind();
   myConn.Close ( ) ;

 }