C#調用自己定義表類型參數

標籤：column   技術   rac   write   alt   object_id   sso   arp   code   

-SQL SERVER產生測試環境:

--建立測試DBCREATE database Sales;goUSE SalesGO--建立表類型IF TYPE_ID(‘LocalDT‘) IS NOT NULLDROP TYPE LocalDTGO CREATE TYPE LocalDT AS TABLE(ID INT NOT NULL,Name NVARCHAR(50))GO--建立預存程序IF OBJECT_ID(‘P_DataTable‘,‘P‘) IS NOT NULLDROP PROC P_DataTable;GOCREATE PROCEDURE P_DataTable(@LocalDT LocalDT READONLY)ASSELECT * FROM @LocalDTGO

--開啟Visual Studio—建立項目—選擇【控制台應用程式】

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;namespace ProcDataTable{    class Program    {        static void Main(string[] args)        {            DataTable dt = new DataTable("LocalDT");            dt.Columns.Add("ID",typeof(int));            dt.Columns.Add("Name", typeof(string));            DataRow dr = dt.NewRow();            dr[0] = 1;            dr[1] = "Roy";            dt.Rows.Add(dr);            SqlConnection thisConnection = new SqlConnection(@"Server=執行個體名;Database=Sales;User ID=sa;Password=1");            thisConnection.Open();            SqlCommand sqlcmd = thisConnection.CreateCommand();            sqlcmd.CommandType = CommandType.StoredProcedure;            sqlcmd.CommandText = "P_DataTable";            SqlParameter param = sqlcmd.Parameters.AddWithValue("@LocalDT", dt);            SqlDataReader sdr = sqlcmd.ExecuteReader();            while (sdr.Read())            {                Console.WriteLine("ID:{0}\tName:{1}",sdr[0],sdr[1]);            }            thisConnection.Close();              Console.ReadKey();          }    }}

--測試結果:

watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" />

C#調用自己定義表類型參數