c#链接数据库的基本语句

//数据库链接地址的语句
String conn_String = "Data Source =.;Initial Catalog=mydata;User Id = sa;Password=huoying000615";

SqlConnection sqlConnection = new SqlConnection(conn_String);  //Sql链接类的实例化  

sqlConnection.Open();

String  sql_String = "select * from test ";
String sql_insert =  "insert into test values('5','kk','122')";
SqlCommand sqlCommand = new SqlCommand(sql_insert,sqlConnection);

sqlCommand.ExecuteNonQuery(); //执行SQL命令
label3.Text="执行成功";


// SqlDataReader reader = sqlCommand.ExecuteReader(); 
// while (reader.Read()) { 
// label3.Text = reader["id"].ToString() + reader["name"].ToString();
for(int i =0; i<reader.FieldCount;i++){
label3.Text = reader["id"].ToString();
}
// //label3.Text = reader.GetName[0].ToString;
// }
//
//
//
//
//









// SqlDataAdapter sqldataAdapter = new SqlDataAdapter (sqlCommand);//创建DataAdapter数据适配器实例  
// DataSet ds = new DataSet();//创建DataSet实例  
//
//
//
// sqldataAdapter.Fill(ds,"test");
//
//
// //label3.Text= ds.Tables["test"].Rows[0][2].ToString();
//
// //DataTable dt = ds.Tables[0];
// for(int i = 0 ; i < ds.Tables["test"].Rows.Count ; i++){     
//    label3.Text = ds.Tables["test"].Rows[i][0].ToString();     
// }  
sqlConnection.Close();






























String conn_String = "Data Source =.;Initial Catalog=mydata;User Id = sa;Password=huoying000615";














































//数据库链接地址的语句
String conn_String = "Data Source =.;Initial Catalog=mydata;User Id = sa;Password=huoying000615";

SqlConnection conn = new SqlConnection(conn_String);  //Sql链接类的实例化  

conn.Open();

String  sql_select = "select * from test1  ";

String s1=textBox1.Text;
String s2=textBox2.Text;
String sql_insert =  "insert into test1 (name,password) values('"+s1+"','"+s2+"')";
SqlCommand cmd = new SqlCommand(sql_insert,conn);
//cmd.CommandText= "insert into test(name,password) values('s1','s2')";
if(cmd.ExecuteNonQuery()>0){
label3.Text ="执行成功";
}else{
label3.Text ="执行失败";


}





conn.Close();