SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testconn"].ConnectionString);
SqlDataAdapter adp = new SqlDataAdapter("Pr_getRightView", con);
...全文
1817打赏收藏
怎么用 SqlDataAdapter 调用存储过程?
public DataSet getRightView() { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testconn"].ConnectionString); SqlDataAdapter adp = new SqlDataAdapter("Pr_getRightView", con);
//带参数
public DataSet ExecutProc(int age)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testconn"].ConnectionString);
SqlCommand cmd = new SqlCommand("存储过程名",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@age", age);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
上面错了
不带参数的应该这样写:
public DataSet getRightView()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testconn"].ConnectionString);
SqlCommand cmd = new SqlCommand("Pr_getRightView",con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
public DataSet getRightView(string tablename, string adnumber)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testconn"].ConnectionString);
SqlCommand cmd = new SqlCommand("Pr_getRightView",con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}