帮帮忙，感谢大家！

Question

http://expert.csdn.net/Expert/topic/2485/2485859.xml?temp=5.443972E-02

Answer 1

public string GetPriceLst(string StorageID,string MaterialID,string FactoryID,string inprice,string verif)
{
OleDbConnection Conn=null;
try
{
Conn =new OleDbConnection(ClsDbConnect.ConnectionString );
firstCommand = new OleDbCommand("M_GetPrice");
firstCommand.CommandType = CommandType.StoredProcedure;
firstCommand.Parameters.Clear();
OleDbParameter param = firstCommand.Parameters.Add("@StorageID", OleDbType.VarChar);
param.Value = StorageID;
param = firstCommand.Parameters.Add("@MaterialID",  OleDbType.VarChar);
param.Value = MaterialID;
param = firstCommand.Parameters.Add("@FactoryID", OleDbType.VarChar);
param.Value = FactoryID;
param = firstCommand.Parameters.Add("@inprice", OleDbType.VarChar);
param.Value = inprice;
param = firstCommand.Parameters.Add("@Verif", OleDbType.VarChar);
param.Value = verif;
param = firstCommand.Parameters.Add("@Strprice", OleDbType.VarChar,100);
param.Value = "";
param.Direction = ParameterDirection.Output;

Conn.Open();
firstCommand.Connection = Conn;
firstCommand.ExecuteNonQuery();
return firstCommand.Parameters["@Strprice"].Value.ToString();
}
catch (System.Exception eFillDataSet) 
{
return eFillDataSet.Message;
}
finally 
{
Conn.Close();
}
}

Answer 2

OleDbCommand cmd=new OleDbCommand(procedurename,sqlcnt);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@param1",OleDbType.Int,4);
cmd.Parameters.Add("@param2",OleDbType.Int,4);
cmd.Parameters["@param1"].Value =param1;
cmd.Parameters["@param2"].Value=param2;