连接sql server 数据库问题
来源:百度知道 编辑:UC知道 时间:2024/06/20 17:42:21
private string ConnectString = ConfigurationManager.ConnectionStrings["ConnectPEDB"].ConnectionString;
public DataSet DataSet() {
DataSet ds = new DataSet();
SqlConnection conn=new SqlConnection(ConnectString);
SqlCommand dbc=new SqlCommand("spzm_PEKey_Select", conn);
dbc.CommandType = CommandType.StoredProcedure;
dbc.Parameters.Add(new SqlParameter("@ArticleId",ArticleId ));
dbc.Parameters.Add(new SqlParameter("@PageSize",PageSize ));
dbc.Parameters.Add(new SqlParameter("@AbsolutePage",AbsolutePage ));
dbc.Parameters.Add(new SqlParameter("@OrderField",OrderField ));
try
{
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(dbc);
sda.Fill(ds);
}