Datatable to Database

so, I think DataAdpter.Update method can help you....

https://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx

http://csharp.net-informations.com/dataadapter/updatecommand-oledb.htm

hope this will help you.

http://www.codeproject.com/Articles/17169/Copy-Data-from-a-DataTable-to-a-SQLServer-Database

Create a User-Defined TableType in your database:

CREATE TYPE [dbo].[MyTableType] AS TABLE(

    [Id] int NOT NULL,

    [Name] [nvarchar](128) NULL

)

and define a parameter in your Stored Ptocedure:

CREATE PROCEDURE [dbo].[InsertTable]

    @myTableType MyTableType readonly

AS

BEGIN

    insert into [dbo].Records select * from @myTableType

END

and send your DataTable directly to sql server:

using (var command = new SqlCommand("InsertTable") {CommandType = CommandType.StoredProcedure})

{

    var dt = new DataTable(); //create your own data table

    command.Parameters.Add(new SqlParameter("@myTableType", dt));

    SqlHelper.Exec(command);

}

 

Hi,
Need more information.
what language are you using for transfer the data?

have you done any code?