Skip to main content

Posts

Showing posts with the label How to insert a data table into SQL Server database table

How to insert a data table into SQL Server database table

Table of Contents 1. Create a User-Defined TableType in your db. 2. Create Stored Procedure and define the parameters. 3. using c# .net, send the DataTable data to sql server . Create a User-Defined TableType in your db. /****** Object:  UserDefinedTableType [dbo].[MapExcelTableType]    Script Date: 07/22/2014 14:57:05 ******/ CREATE TYPE [dbo] . [MapExcelTableType] AS TABLE (       [ID] [int] NULL,       [CostCenter] [varchar] ( 150 ) NULL,       [MobileNo] [varchar] ( 150 ) NULL,       [EmailID] [varchar] ( 150 ) NULL,       [FirstName] [varchar] ( 150 ) NULL,       [LastName] [varchar] ( 150 ) NULL,       [Services] [varchar] ( 150 ) NULL,       [UsageType] [varchar] ( 150 ) NULL,       [Networ...
Read more