C# and Table Value Parameters

gaurav_verma_mca

Rate me:

4.78/5 (30 votes)

20 Aug 2009CPOL3 min read

326.3K

4.3K

How to send bulk data using table value parameters from C#

tablevalueparameters.zip
- TableValueParameters
  - TableValueDatabase
    - Properties
      - Database.sqlcmdvars
      - Database.sqldeployment
      - Database.sqlpermissions
      - Database.sqlsettings
    - Schema Objects
      - SampleTestQueryScript.sql
      - Stored Procedures
        
        SampleProcedure.proc.sql
      - Tables
        
        SampleTable.table.sql
      - Types
        
        SampleDataType.uddt.sql
    - sql
      - debug
        
        Database.sqlcmdvars
        
        Database.sqldeployment
        
        Database.sqlsettings
        
        Microsoft.SqlTypes.dbschema
        
        TableValueDatabase.dbschema
        
        TableValueDatabase.deploymanifest
        
        TableValueDatabase.sql
      - release
    - TableValueDatabase.dbmdl
    - TableValueDatabase.dbproj
    - TableValueDatabase.dbproj.schemaview
    - TableValueDatabase.dbproj.user
  - TableValueParameters.sln
  - TableValueParameters.suo
  - TableValueParameters
    - App.config
    - bin
      - Debug
        
        Database
        
        SampleDB.mdf
        
        SampleDB_log.ldf
        
        TableValueParameters.exe
        
        TableValueParameters.exe.config
        
        TableValueParameters.pdb
        
        TableValueParameters.vshost.exe
        
        TableValueParameters.vshost.exe.config
        
        TableValueParameters.vshost.exe.manifest
      - Release
    - Database
      - SampleDB.mdf
      - SampleDB_log.LDF
    - Program.cs
    - Properties
    - TableValueParameters.csproj
    - TableValueParameters.csproj.user

-- This is the sample script to test the SP

-- An instance of the Table parameter type is created
Declare	@SampelData	As	[dbo].[SampleDataType]
-- and then filled with the set of values
Insert	Into	@SampelData(SampleString, SampleInt) Values('1',1);
Insert	Into	@SampelData(SampleString, SampleInt) Values('2',null);
Insert	Into	@SampelData(SampleString, SampleInt) Values('3',3);

Select * From @SampelData
-- we then call the SP to store the values
Exec SampleProcedure @SampelData

Select *  From SampleTable

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

gaurav_verma_mca

Architect Imfinity

India

Hi I have been working on enterprise applications for last six years.

C# and Table Value Parameters

License

Comments and Discussions