1、新建自定義表結構

注意字段的順序要一致?類型要一樣?不然會出錯?

CREATE TYPE [dbo].[HBForHBGHDR] AS TABLE( [序號] [int] NULL, [客戶編號] [varchar](15) NULL ) GO

　　

2、建立存儲過程

alter PROCEDURE UP_DRGHHB@HBList HBForHBGHDR readonly,@returnCode varchar(10) output,@returnMsg varchar(50) output AS BEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;declare @rowcount intset @returnCode=1select @rowcount=count(1) from @HBList--set @returnMsg=(select top 1 [客戶編號] from @HBList)update jc_hb set yl5=1 where khbh in(select [客戶編號] from @HBList)set @returnMsg='總共提交條數：'+convert(varchar(10),@rowcount)+',修改成功:'+ convert(varchar(10),@@rowcount)+'條' END GO

　3、調用存儲過程

string returnCode = string.Empty;string returnMsg = string.Empty;SqlParameter[] paras = new SqlParameter[]{new SqlParameter("@returnCode",returnCode),new SqlParameter("@returnMsg",returnMsg),new SqlParameter("@HBList",dt)};paras[0].Direction = ParameterDirection.Output;paras[1].Direction = ParameterDirection.Output;paras[1].Size = 50;paras[2].TypeName = "HBForHBGHDR";DataSet ds = DbHelperSQL.RunProcedure("[UP_DRGHHB]", paras, "tb1");returnMsg = paras[1].Value.ToString();returnCode = paras[0].Value.ToString();if (returnCode != "1"){this.lblError.Text = "批量插入數據失敗：" + returnMsg;}elsethis.lblError.Text = "批量插入數據成功：" + returnMsg;

　　

　

轉載于:https://www.cnblogs.com/chenqingbin/p/11009877.html

總結

以上是生活随笔為你收集整理的c#调用带有自定义表结构的存储过程的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。