存储过程参数传入问题??

Question

CREATE PROCEDURE dbo.Cup_Work_GetAllUnits
@UserId varchar(8)
AS
Select unit_id, unit_name,unit_leader,unit_memo 
from C_Member_Unit where user_id=UserId@ order by unit_id
RETURNGO我在页面用一个方法
 public void GetDocketInfo(string userId) 为传入的参数
    { 
       //里面的格式应怎么写啊??望指教
       }

Answer 1

CREATE PROCEDURE dbo.Cup_Work_GetAllUnits 
@UserId varchar(8) 
AS 
Select unit_id, unit_name,unit_leader,unit_memo 
from C_Member_Unit where user_id=@UserId order by unit_id 
RETURN GO 
1,Ado.net
public void GetDocketInfo(string userId) 为传入的参数 
    { 
 
     SqlConnection con = new SqlConnection (连接字符串);
     SqlCommand cmd= new SqlCommand (con);
     cmd.CommandText ="Cup_Work_GetAllUnits";
     cmd.CommandType= System.Data.CommandType.StoredProcedure;
      cmd.Parameters.Add(new SqlParameter("@UserId",你的输入值));
      DataReader read = cmd.ExcuteReader();
      .......
      }2,
  还可以用 数据源控件。

Answer 2

public DateTable GetDocketInfo(string userId) 为传入的参数 
    { 
 
 
        string ConnectionString = ConfigurationManager.ConnectionStrings["yourConnectionString"].ConnectionString;
        
        SqlConnection myConnection = new SqlConnection(ConnectionString);
        SqlDataAdapter da = new SqlDataAdapter(storeProcedure, myConnection);        da.SelectCommand.Parameters.Add(new SqlParameter(@userId, userId));        da.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataTable dt = new DataTable();
        da.Fill(dt);
        myConnection.Close();
        myConnection.Dispose();        return dt;
    }

Answer 3

2, 
  还可以用 数据源控件。  
<asp:SqlDataSource
                id="SqlDataSource1"
                runat="server"
                ConnectionString="<%$ ConnectionStrings:连接串%>"
                SelectCommandType="StoredProcedure"                
                SelectCommand="存储过程名称">
                <selectparameters>
                 <asp:Parameter Name="UserId" Type =Int32 Direction=Input />
               </selectparameters>
            </asp:SqlDataSource>public void GetDocketInfo(string userId) 
    { 
      
     UpdateParameters["UserId"].DefaultValue = 你的输入值;
      SqlDataSource1.Update();         } 

Answer 4

2, 
  还可以用 数据源控件。  
<asp:SqlDataSource 
                id="SqlDataSource1" 
                runat="server" 
                ConnectionString=" <%$ ConnectionStrings:连接串%>" 
                SelectCommandType="StoredProcedure"                
                SelectCommand="存储过程名称"> 
                <selectparameters> 
                <asp:Parameter Name="UserId" Type =Int32 Direction=Input /> 
              </selectparameters> 
            </asp:SqlDataSource> public void GetDocketInfo(string userId) 
    { 
      
     SqlDataSource1.selectparameters["UserId"].DefaultValue = 你的输入值; // 修改了      SqlDataSource1.Update();         } 

Answer 5

  public DataTable SelectDataTable(string argSqlString)
    {
        SqlCommand sqlSelectCommand = new SqlCommand(argSqlString, dbConnection);
        sqlSelectCommand.CommandTimeout = 300;
        if (dbTrans != null)
            sqlSelectCommand.Transaction = dbTrans;
        SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlSelectCommand);
        DataTable dataTable = new DataTable();
        this.Connect();
        sqlDataAdapter.Fill(dataTable);
        this.DisConnect();
        return dataTable;
    }
我的数据库是分开写的,那么现在在public void GetDocketInfo(string userId) 为传入的参数 
    { 
      //里面的格式应怎么写啊??望指教 
      }

Answer 6

 public DataSet ExecProcedure(string procedureName, ArrayList ParametersList)
        {
            SqlCommand sqlComm = new SqlCommand(procedureName, SqlConn());
            sqlComm.CommandType = CommandType.StoredProcedure;
            sqlComm.CommandTimeout = 180;            try
            {
                foreach (SqlParameter oParamPid in ParametersList)
                {
                    sqlComm.Parameters.Add(oParamPid);
                }                SqlDataAdapter sqlDapt = new SqlDataAdapter(sqlComm);
                DataSet ds = new DataSet();
                sqlDapt.Fill(ds);                return ds;
            }
            catch (Exception ee)
            {
                throw ee;
            }
            finally
            {
                sqlConn.Close();
                ParametersList.Clear();
                sqlComm.Dispose();
            }
        }
调用：
 public DataSet GetMonitorRecordInfo(string aa, string bb)
        {
            SqlParameter paramStatus = new SqlParameter("@aa", SqlDbType.VarChar);
            paramStatus.Value = aa;
            oParamPidArray.Add(paramStatus);            SqlParameter paramAllPathName = new SqlParameter("@bb", SqlDbType.VarChar);
            paramAllPathName.Value = bb;
            oParamPidArray.Add(paramAllPathName);            return dbOper.ExecProcedure("GetMonitorRecordInfo", oParamPidArray);
        }