if (!IsPostBack)
{
//多种构造 连接服务器字符串 的方法
SqlConnection cn = new SqlConnection("Server=(local);Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806"); //个人喜欢这种,Server表达比较明确
//SqlConnection cn = new SqlConnection("Server=localhost;Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806");
//SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806");
//SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806");
//一 存储过程的参数是整数
//int ln=4;
//SqlCommand cmd = new SqlCommand("prGetNameByLessID " + ln.ToString() , cn);
//二 存储过程的参数是两个字符串
//string f = "a";
//string l = "c";
//SqlCommand cmd = new SqlCommand("prGetNameBetween " + f + "," + l, cn);
string n = "Home";
SqlCommand cmd = new SqlCommand("prGetNameByName " + n , cn);
rs=cmd.ExecuteReader();
while (rs.Read())
{
ChkLstTest.Items.Add( rs["Name"].ToString() );
}
rs.Close();
cn.Close();
}
{
//多种构造 连接服务器字符串 的方法
SqlConnection cn = new SqlConnection("Server=(local);Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806"); //个人喜欢这种,Server表达比较明确
//SqlConnection cn = new SqlConnection("Server=localhost;Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806");
//SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806");
//SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=AdventureWorks2008R2;UID=sa;Pwd=04768350806");
//一 存储过程的参数是整数
//int ln=4;
//SqlCommand cmd = new SqlCommand("prGetNameByLessID " + ln.ToString() , cn);
//二 存储过程的参数是两个字符串
//string f = "a";
//string l = "c";
//SqlCommand cmd = new SqlCommand("prGetNameBetween " + f + "," + l, cn);
//二 存储过程的参数是两个字符串 等效语法
//SqlCommand cmd = new SqlCommand("prGetNameBetween ", cn);
//cmd.Parameters.AddWithValue("@F", "a");
//cmd.Parameters.AddWithValue("@L", "c");
//cmd.CommandType = CommandType.StoredProcedure;
//二 另一种等效语法,不使用拼接的方法,感觉这种等效方法也很不错
//SqlCommand cmd = new SqlCommand("select Name from Person.AddressType where Name between @f and @l " , cn);
//cmd.Parameters.AddWithValue("@f", "a");
//cmd.Parameters.AddWithValue("@l", "c");
//三 存储过程的参数是一个字符串
string n = "Home";
SqlCommand cmd = new SqlCommand("prGetNameByName " + n , cn);
SqlDataReader rs;
rs=cmd.ExecuteReader();
while (rs.Read())
{
ChkLstTest.Items.Add( rs["Name"].ToString() );
}
rs.Close();
cn.Close();
}