Sending value to database in one hit

Posted by Shoyeb under ASP.NET on 11/27/2011 | Points: 10 | Views : 1294 | Status : [Member] | Replies : 1
Hi All,

I am facing a problem using gridview, my problem is that... there is a gridview in which i have textbox , user can input the value into textbox and these values are store in database.. for storing value i am using stored procedure.
Now my problem is that i am sending the value of textbox using loop ( for loop)
if threre is 1000 of row then 1000 times it hits the stored procedure ...is there anothe way to store value of all rows only one hit ?


Thanks




Responses

Posted by: Arefin on: 11/27/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Shoyeb,

You can visit the following link:
http://www.vikramlakhotia.com/Inserting_multiple_records_using_one_stored_procedure.aspx

It might be helpful for you.

Thanks,
Arefin

Shoyeb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response