请问:SqlDataAdapter 是否可以调用--->存储过程
如果可以的话麻烦帮我修改一下,呵 public void BindGridView()
{
//连接到数据库;
SqlConnection myconn = DBO.CreatConn();
myconn.Open(); //定义用语填充缓存的,更新连接到的DB的sql命令;
string sqlstr = " select * from users";
SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr, myconn); //开设一个缓存空间mydadaset,把获取的命令填充缓存;
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset); //绑定GridView;
gvUser.DataSource = mydataset;
gvUser.DataBind();
myconn.Close();
}
如果可以的话麻烦帮我修改一下,呵 public void BindGridView()
{
//连接到数据库;
SqlConnection myconn = DBO.CreatConn();
myconn.Open(); //定义用语填充缓存的,更新连接到的DB的sql命令;
string sqlstr = " select * from users";
SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr, myconn); //开设一个缓存空间mydadaset,把获取的命令填充缓存;
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset); //绑定GridView;
gvUser.DataSource = mydataset;
gvUser.DataBind();
myconn.Close();
}
SqlDataAdapter mydataadapter = new SqlDataAdapter("StoredUser", myconn);
mydataadapter.....AcceptChangesDuringFill....AcceptChangesDuringUpdate....Container....ContinueUpdateOnError....选用哪一个就弄不清了呵呵,第一次使用 存储过程,请多包涵
SqlDataAdapter mydataadapter = new SqlDataAdapter("StoredUser ", myconn);
mydataadapter.SelectCommand.CommandType = CommandType.StoredProcedure;
这就是你要的吧?