inserting values

Question

0.00/5 (No votes)

See more:

How to develop a generic code for inserting dataset values that consist of multiples tables into multiple tables in sql server database in C#? Please help me.

Posted 19-Dec-10 20:19pm

yaprig

Updated 19-Dec-10 20:20pm

JF2015

v2

Add a Solution

Comments

Sandeep Mewara 20-Dec-10 3:18am

How to? Write it! Try?

Dave Kreskowiak 20-Dec-10 10:08am

You're going to have to modify your question to be a bit more specific. What you've asked doesn't make much sense. Give an example of what you're trying to achieve and under what circumstances.

Sunasara Imdadhusen 21-Dec-10 7:20am

Note clear!!

2 solutions

Solution 2

It will be more likely done in this way.

SqlBulkCopy sbc = new SqlBulkCopy(conn1 );
                  sbc.DestinationTableName = @Table_Name;
                  conn1.Open();
                  sbc.WriteToServer(ds.Tables[i]);
                  conn1.Close();

Posted 23-Dec-10 20:18pm

yaprig

Updated 23-Dec-10 20:22pm

v2

Comments

Abhinav S 24-Dec-10 2:23am

Code tags added.

Add a Solution

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

Corporal Agarn · Accepted Answer · 2010-12-22T08:34:00

Solution 1

If I understand the question it looks like you will need to split the data up for each table. Google for C# to SQL Server table. Then populate each table.

Posted 22-Dec-10 8:34am

Corporal Agarn

Comments

yaprig 24-Dec-10 2:16am

thanks it waz helpful..:)

inserting values

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

inserting values

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us