.sdf insert ,retrieve array of string elements

Question

hello,

iam using .sdf sql compact for my wpf app,  i know how to insert and retrieve data(one string) into this local database but i don't know how to insert fro an array one by one using 'foreach' method ? please help

---

please

Answer 1

Hi SANTANA,

I don't fully understand your sentence: but i don't know how to insert fro an array one by one using 'foreach' method?

Could you please elaborate a little bit more about it? Do you mean to use array as binding source object? Also, which element you want to bind with?

If you mean to insert array to database, you can try concatenating the foreach statement into the insert syntax.

Have a nice day,

---

Kee Poppy [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Sorry 

Actually I have a array of strings (string[] myarray ;) it contain strings

i need to send all strings (first to last) to a database

i think

foreach(string s in myarray)

{

myarray[i] // need to save each element in array

 //need to know query to do this operation 

}

please help me

---

please

Answer 3

Check this (SQL database for instance):

        cmd= new SqlCommand ("insert into table1 values('"+s+"')", con);
        cmd.ExecuteNonQuery();

Have a nice day,

---

Kee Poppy [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Thank You Verymuch Sir

Answer 5

how to increase speed of my horizontal scrollbar ?

---

please