How to insert multiple rows from c# table to sql database table:- Frontend: <asp:Button ID="Button2" runat="server" Text="Create Table" onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server"> </asp:GridView> Backend C#: protected void Button2_Click(object sender, EventArgs e) { // // Here we create a DataTable with four columns. // DataTable temptable = new DataTable(); temptable.Columns.Add("ProductID", typeof(string)); temptable.Columns.Add("RelatedProductID", typeof(string)); temptable.Columns.Add("IsActive", typeof(string)); foreach (ListItem item in ListBox1.Items) { if (item.Selected) { // // Here we add five DataRows. // temptable.Rows.Add(1, 1, 1); }
Comments
Post a Comment