SqlDataAdapter如何调用存储过程？

Question

SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlx, MyCon()); sqlx为存储过程
SqlDataAdapter如何调用存储过程？ SqlCommand的调用我就知道。
 SqlCommand myCommand = new SqlCommand("sqlx", myConnection);
        
  myCommand.CommandType = CommandType.StoredProcedure;

Answer 1

SqlCommand ObjCommand = new SqlCommand(StrProcName, ObjConnection);
ObjCommand.CommandType = CommandType.StoredProcedure;SqlDataAdapter ObjDataAdapter = new SqlDataAdapter(ObjCommand);
DataSet ObjDataSet = new DataSet();
ObjDataAdapter.Fill(ObjDataSet);
return ObjDataSet;

Answer 2

一样的public DataTable GetDataTable(string asProcedureName, HYDBParameter[] aParam)
        {
            ClearLastError();
            DataTable table = new DataTable();
            using (SqlConnection conn = new SqlConnection(ConnectString))
            {
                try
                {
                    conn.Open();
                    SqlCommand comm = conn.CreateCommand();
                    comm.CommandText = asProcedureName;
                    comm.CommandType = CommandType.StoredProcedure;
                    comm.CommandTimeout = TimeOut;
                    foreach (HYDBParameter param in aParam)
                        comm.Parameters.Add(ConvertFromHYDBParameter(param));
                    SqlDataAdapter data = new SqlDataAdapter(comm);                    data.Fill(table);
                }
                catch (Exception ex)
                {
                    HasException(ex, null);
                }
            }
            return table;
        }

Answer 3

SqlDataAdapter ObjDataAdapter = new SqlDataAdapter(Command); 

Answer 4

忘记了说。存储过程里面有两个select语句的

Answer 5

comm.CommandText = asProcedureName;
comm.CommandType = CommandType.StoredProcedure;
SqlDataAdapter data = new SqlDataAdapter(comm);

Answer 6

请楼主参考这里，
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx