insert an array values into table at same time?

Question

Hi every one

             I wann write code to do this

I have list of food , I want to insert this to sql database 2008 from web site C#.net 2010 at same time

for example if the user add three kind of food so I have to add this to table food has 2 column id and food'name

so , Please could you give idea

I tried to add this list to array after that take it one by one .

but it is not good idea. close and open connection many times.

 

thank you

 

---

Thanks

Answer 1

I found the solution for this

ArrayList AList = new ArrayList();
    if (Chapple.checked == true)
      AList.Add("Apple");
    if (ChOrang.checked== true)
      AList.Add("Oranges");

int id = 10;



 string sql = "insert into Foodtbll (ID,food_name)values ";

    int d = AList.Count;
    int i=0;
    foreach (string obj in AList)
    {
      i = i + 1;
      sql = sql + "(" + ID + ",'" + obj + "' )";
      if (i < d)
        sql = sql + ",";
    }

---

Thanks

Answer 2

Hi Rawad,

 

Thanks for sharing your experience here.

Thank you very much.

If you have any difficulty in future programming, we welcome you to post here again. There are many enthusiastic community members here to provide their help and suggestions.

  

 

---

Best Regards,
Rocky Yue[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.