错误:将多个值传递到存储过程 [英] ERROR : Passing multiple values into a stored procedure

问题描述

代码......................................

1如何...将值形式DDL传递到SQLHELPER FILE ..?
我的代码是


ds = SqlHelper.ExecuteDataset(con，CommandType.StoredProcedure，"GetemployeeId"，new SqlParameter("@ employeeId"，Employeeid，"@firstname"，Fname));

解决方案

创建一个SqlParameter数组并将其传递给SqlHelper.ExecuteDataset().

 SqlParameter [] paramArray = 新 SqlParameter [] {
                                               新 SqlParameter(" ，员工ID)，
                                               新 SqlParameter(" ， Fname)

                                               };


ds = SqlHelper.ExecuteDataset(con，CommandType.StoredProcedure，" ，paramArray)； 

P.S.仅当实现了ExecuteDataset以处理作为数组传递的SqlParameter值时，此方法才起作用. br/>

Code......................................

1 How ... Pass Value Form DDL TO SQLHELPER FILE ..?
My code is


ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "GetemployeeId", new SqlParameter("@employeeId", Employeeid ," @firstname",Fname));

解决方案

Create an array of SqlParameter and pass it to SqlHelper.ExecuteDataset() .

SqlParameter[] paramArray = new SqlParameter[] {
                                               new SqlParameter("@employeeId",Employeeid),
                                               new SqlParameter("@firstname",Fname)

                                               };


ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "GetemployeeId", paramArray); 

P.S. This will only work if you have implemented ExecuteDataset to handle SqlParameter values being passed as an Array.

Can you set a break point and step into it?

这篇关于错误:将多个值传递到存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！