Insert elements from an array into table?

Question

Dear all,

I have a table with over 500 fields, name of the fields are F1, F2, ....F500.

How can i insert from an array, or loop through the fields to insert?

I've looked for solution in MSDN and find the statement:

 

INSERT INTO dbf_name FROM ARRAY ArrayName | FROM MEMVAR | FROM NAME ObjectName

 

 However, it's used for Visual FoxPro in VS2005.

I'm using VS C#, Entity FrameWork. 

Pls help me.

thanks.

Answer 1

SQL Server does not support Array parameters. Options would be using either XML or table-valued parameters. Below is an example that uses XML:

How to pass array of values into SQL Server stored procedure using XML and Visual Basic .NET

 

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

could you clarify if each field is a new row or is each field a column?

 

 

 

Answer 3

thank you for reply, each field is column.

i found the statement:  INSERT INTO dbf_name FROM ARRAY ArrayName.

but dont known how to use it in C#.

Answer 4

check this case. http://stackoverflow.com/questions/4720138/insert-into-with-array may be helpful for you.

Thanks,

Esters,

---

Just a newbie for everything.

Answer 5

Since each field is a column if your table is in the same order you can use the bulkcopy object

 

first convert your array into a dataset then create the bulkcopy pointing to the table that you need to insert into.

 

then simply run the writetoserver(dataset) function and it will fly into your sql database