连接sql server 数据库问题

来源:百度知道 编辑:UC知道 时间:2024/06/20 17:42:21
哪位大侠能给我一段驱动程序代码呢?我是用c#通过ADO连接SQL SERVER数据库。需要改动的地方请给于说明!万分感激!

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);
}