string str = System.Configuration.ConfigurationManager.AppSettings["joinDB"];
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("存储过程名称", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("存储过程参数", SqlDbType.NVarChar, 20));
cmd.Parameters["存储过程参数"].Value = 参数值;
con.Open();
方法1:
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
//绑定到数据控件
dlType.DataSource = ds;
dlType.DataBind();
方法2:
SqlDataReader reader = cmd.ExecuteReader();
dlType.DataSource = reader;
dlType.DataBind();
con.Close();