how can we use datatable for insert multiple row

Question

Hello sir/mam i want to help from you.i am working in asp.net c# and sql server Suppose I have 3 columns in database and i want to insert multiple row in database on click If i have 5 textbox mean 5 row will be insert.Please help i will wait your answer

Munesh Sharma · Answer

http://www.aspsnippets.com/Articles/Pass-multiple-records-rows-to-a-Stored-Procedure-in-SQL-Server-using-C-and-VBNet.aspx http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

Monu Zira · Answer

Sir thanks for reply.Have any other way using data table

Pankaj Kumar Choudhary · Answer

Hello @Monu i m sending you a demo of stored procedure. You can use following stored procedure. CREATE PROC Insert_Value(@String [nvarchar](max)) AS BEGIN DECLARE @StartIndex INT, @EndIndex INT SET @StartIndex = 1 IF SUBSTRING(@String, LEN(@String) - 1, LEN(@String)) ',' BEGIN SET @String = @String + ',' END WHILE CHARINDEX(',', @String) > 0 BEGIN SET @EndIndex = CHARINDEX(',', @String) INSERT INTO TabExam(Col) SELECT SUBSTRING(@String, @StartIndex, @EndIndex - 1) SET @String = SUBSTRING(@String, @EndIndex + 1, LEN(@String)) END END in this Stored procedure send your value of textbox that are separated by comma like: 'A,B,C,D,E' When i execute this stored procedure it insert 5 rows. when you pass this string in stored procedure it will insert 5 rows in table. If you your string is 'A,B,c' then it will insert 3 rows. here i am using only one column but you can use 3 column similar as single column...........

Munesh Sharma · Answer

you can do it by using loop.. just take for(int i= 0 ; i { //do insert code }

Monu Zira · Answer

Sir thanks for reply.can u send me code?because i am to confuse

Pankaj Kumar Choudhary · Answer

Hello @Monu for this you can use Stored procedure . in this stored procedure you can send value of five textbox as a single string . Separate the value by Comma or space or using any other special character. after that in stored procedure split all these value and insert into table....... I think this is best approach for your requirement