Posted on: 11/29/2014 12:03:26 AM | Views : 452

Hi every one
I read many documents about it but still i can not do this, i will thank ful if any body help.
I want to insert multiple record into a sqldatasource, can i use SqlDataSource4.InsertParameters ?
I have a sql data source as bellow
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:shabdizdbConnectionString %>" DeleteCommand="DELETE FROM [dbCL_Hours] WHERE [ClassHourSerial] = @ClassHourSerial" InsertCommand="INSERT INTO [dbCL_Hours] ([ClassDateSerial], [TimeFrom], [TimeTo], [Registered]) VALUES (@ClassDateSerial, @TimeFrom, @TimeTo, @Registered)" SelectCommand="SELECT [ClassHourSerial], [ClassDateSerial], [TimeFrom], [TimeTo], [Registered] FROM [dbCL_Hours] WHERE ([ClassHourSerial] = @ClassHourSerial)&quo ...

Go to the complete details ...