C#调用存储过程

Question

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[work_calculate]  
@work varchar(100)as
SELECT *,(QTY-(ISNULL(MRTQTY,0)-ISNULL(PRTQTY,0))) L_LOCQTY,((ISNULL(ANTQTY,0)-ISNULL(VRTQTY,0))+ISNULL(PCTQTY,0)-QTY) L_JOBQTY,(STOCK-(QTY-(ISNULL(MRTQTY,0)-ISNULL(PRTQTY,0)))) L_STKQTY FROM HC_RESVT WHERE WO=@work OR JOBNO=@work ORDER BY CODE,LOC
C#里面怎么提取text的值到@work 最好是代码全的，如果我text里面是098546 怎么放到@work里面进行查询，谢谢。。以前都是用SQL没有用过存储过程。

Answer 1

SqlCommand sqlCmd = new SqlCommand("work_calculate", "你的连接串");
                sqlCmd.CommandType = CommandType.StoredProcedure;                sqlCmd.Parameters.AddWithValue("work", "098546");
                SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCmd);
                DataSet dataSet = new DataSet();
                dataSet.EnforceConstraints = false;
                dataSet.Tables.Add(new DataTable());
                dataSet.Tables[0].TableName = "ReturnTable";
                dataAdapter.TableMappings.Add("Table", "ReturnTable");
                sqlCmd.Connection.Open();
                dataAdapter.Fill(dataSet);                retrunTable = dataSet.Tables["ReturnTable"];

Answer 2

   SqlCommand sqlCmd = new SqlCommand("work_calculate", "Data Source=KJI-SERVER\\MAC_INSTANCE;Initial Catalog=kji;Persist Security Info=True;User ID=kji;Pwd=kji@jiaj;Connect Timeout=180");
错误 1 与“System.Data.SqlClient.SqlCommand.SqlCommand(string, System.Data.SqlClient.SqlConnection)”最匹配的重载方法具有一些无效参数 C:\Documents and Settings\Administrator\桌面\工单查询\Manno\Manno\Form1.cs 77 37 Manno

Answer 3

using(SqlConnection sqlconn = new SqlConnection(""))
{
       SqlCommand cmd = new SqlCommand("",sqlconn );
       cmd.CommandType = CommandType.StoredProcedure;
        IDataParameter[] parameters = {
                new SqlParameter("@work ", SqlDbType.NVarChar,100) 
            };      
         parameters[0].Value = "";             
         cmd.Parameters.Add(parameters[0]);
        SqlDataAdapter dp = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dp.Fill(ds);
}