I have some textboxs and some comboboxes, And i am inserting those values in database,
By Now i want to insert multiple values in it.
For example i have i have 10 records in another gridview and in each row i have a checkbox So i have checked 3 records and after cheking i want to save those three in new tables.
Please guide me what i have to do to insert multiple values. Using gridview listview with a checkbox in every row.
Resumepod
Member
56 Points
97 Posts
multiple values insert
Jan 29, 2013 08:14 AM|LINK
Hi All,
I have some textboxs and some comboboxes, And i am inserting those values in database,
By Now i want to insert multiple values in it.
For example i have i have 10 records in another gridview and in each row i have a checkbox So i have checked 3 records and after cheking i want to save those three in new tables.
Please guide me what i have to do to insert multiple values. Using gridview listview with a checkbox in every row.
Thank you!
kaushikmahet...
Contributor
3750 Points
886 Posts
Re: multiple values insert
Jan 29, 2013 08:17 AM|LINK
use foreach loop using gridviewrow and inserte record
Remember to click Mark as Answer on the post that helps to others.
urenjoy
Star
12027 Points
1807 Posts
Re: multiple values insert
Jan 29, 2013 08:18 AM|LINK
refer following:
http://www.codeproject.com/Questions/357919/how-to-insert-multiple-records-in-database-from-gr
http://stackoverflow.com/questions/4543666/best-way-to-insert-multiple-rows-ado-net
ramiramilu
All-Star
95275 Points
14072 Posts
Re: multiple values insert
Jan 29, 2013 08:19 AM|LINK
in your codebehind construct Xml and send it to stored procedure and in the SP you can diassemble it and make the CRUD operations of your interest....
in SP either use OPENXML or xml.Nodes() to get the values out of xml....
thanks,
JumpStart
rimagandhi
Participant
1552 Points
495 Posts
Re: multiple values insert
Jan 29, 2013 08:36 AM|LINK
<asp:GridView ID="grvRateDetails" runat="server" AutoGenerateColumns="False"
BorderColor="Black" BorderWidth="2" CellPadding="4" class="bodytxt_black"
ForeColor="#333333" GridLines="None" OnRowDeleting="grvRateDetails_RowDeleting"
ShowFooter="true" Width="900">
<Columns>
<asp:BoundField DataField="RowNumber" HeaderText="Slab" />
<asp:TemplateField HeaderText="Slab Type" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:DropDownList ID="ddSlabtype" runat="server" class="bodytxt_black"
ToolTip="Please Select One Type">
<asp:ListItem>Day</asp:ListItem>
<asp:ListItem>Night</asp:ListItem>
<asp:ListItem>Sunday </asp:ListItem>
<asp:ListItem>Holiday </asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Call From" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:TextBox ID="txtLoadFrom" runat="server" class="bodytxt_black" Width="80px"
ToolTip="Please enter call No From" MaxLength="3"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtLoadFrom" ErrorMessage="*" SetFocusOnError="True"
ValidationGroup="rate" ></asp:RequiredFieldValidator>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Call To" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:TextBox ID="txtLoadTo" runat="server" class="bodytxt_black" Width="80px"
ToolTip="Please enter call No To" MaxLength="3"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtLoadTo" ErrorMessage="*" SetFocusOnError="True"
ValidationGroup="rate" ></asp:RequiredFieldValidator>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Time From" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:TextBox ID="txtTimeFrom" runat="server" class="bodytxt_black" Width="80px"
ToolTip="Please enter Time From Hr:Min" MaxLength="5"></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
ErrorMessage="*" ControlToValidate="txtTimeFrom"
ValidationExpression="(([0]?[0-9]|[1][0-9]|[2][0-3]):[0-5][0-9](:[0-5][0-9])?)"
SetFocusOnError="True" ValidationGroup="rate"></asp:RegularExpressionValidator>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="txtTimeFrom" ErrorMessage="*" SetFocusOnError="True"
ValidationGroup="rate" ></asp:RequiredFieldValidator>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Time To" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:TextBox ID="txtTimeTo" runat="server" class="bodytxt_black" Width="80px"
ToolTip="Please enter Time To Hr:Min" MaxLength="5"></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
ErrorMessage="*" ControlToValidate="txtTimeTo"
ValidationExpression="(([0]?[0-9]|[1][0-9]|[2][0-3]):[0-5][0-9](:[0-5][0-9])?)"
SetFocusOnError="True" ValidationGroup="rate"></asp:RegularExpressionValidator>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
ControlToValidate="txtTimeTo" ErrorMessage="*" SetFocusOnError="True"
ValidationGroup="rate" ></asp:RequiredFieldValidator>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="FreeCall/Month" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:TextBox ID="txtfree" runat="server" class="bodytxt_black" Width="80px"
ToolTip="Please enter Free call" MaxLength="5"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server"
ControlToValidate="txtfree" ErrorMessage="*" SetFocusOnError="True"
ValidationGroup="rate" ></asp:RequiredFieldValidator>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Rate" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:TextBox ID="txtLoadRate" runat="server" class="bodytxt_black" Width="80px"
ToolTip="Please enter Rate" MaxLength="5"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
ControlToValidate="txtLoadRate" ErrorMessage="*" SetFocusOnError="True"
ValidationGroup="rate"></asp:RequiredFieldValidator>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
<FooterStyle HorizontalAlign="Right" />
<FooterTemplate>
<asp:Button ID="ButtonAdd" runat="server" OnClick="ButtonAdd_Click"
Text="Add New Row" ValidationGroup="rate" />
</FooterTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Action">
<ItemTemplate>
<asp:LinkButton ID="lnkDelete" runat="server" Text="Delete" CommandName="Delete"
OnClientClick="return confirm('Are you certain you want to delete this row?');"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="Black" CssClass="grid_heading_txt1" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" />
<AlternatingRowStyle BackColor="#CCCCCC" />
</asp:GridView>
Page Load event
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FirstGridViewRow();
}
}
Other function related to it
private void FirstGridViewRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
dt.Columns.Add(new DataColumn("Col1", typeof(string)));
dt.Columns.Add(new DataColumn("Col2", typeof(string)));
dt.Columns.Add(new DataColumn("Col3", typeof(string)));
dt.Columns.Add(new DataColumn("Col4", typeof(string)));
dt.Columns.Add(new DataColumn("Col5", typeof(string)));
dt.Columns.Add(new DataColumn("Col6", typeof(string)));
dt.Columns.Add(new DataColumn("Col7", typeof(string)));
dr = dt.NewRow();
dr["RowNumber"] = 1;
dr["Col1"] = string.Empty;
dr["Col2"] = string.Empty;
dr["Col3"] = string.Empty;
dr["Col4"] = string.Empty;
dr["Col5"] = string.Empty;
dr["Col6"] = string.Empty;
dr["Col7"] = string.Empty;
dt.Rows.Add(dr);
ViewState["CurrentTable"] = dt;
grvRateDetails.DataSource = dt;
grvRateDetails.DataBind();
}
private void AddNewRow()
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
DropDownList DrpddSlabtype = (DropDownList)grvRateDetails.Rows[rowIndex].Cells[1].FindControl("ddSlabtype");
TextBox TextBoxLoadFrom = (TextBox)grvRateDetails.Rows[rowIndex].Cells[2].FindControl("txtLoadFrom");
TextBox TextBoxLoadTo = (TextBox)grvRateDetails.Rows[rowIndex].Cells[3].FindControl("txtLoadTo");
TextBox TextBoxTimeFrom = (TextBox)grvRateDetails.Rows[rowIndex].Cells[4].FindControl("txtTimeFrom");
TextBox TextBoxTimeTo = (TextBox)grvRateDetails.Rows[rowIndex].Cells[5].FindControl("txtTimeTo");
TextBox TextBoxFree = (TextBox)grvRateDetails.Rows[rowIndex].Cells[6].FindControl("txtfree");
TextBox TextBoxLoadRate = (TextBox)grvRateDetails.Rows[rowIndex].Cells[7].FindControl("txtLoadRate");
//TextBox TextBoxLoadAmount = (TextBox)grvRateDetails.Rows[rowIndex].Cells[5].FindControl("txtTotal");
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["RowNumber"] = i + 1;
dtCurrentTable.Rows[i - 1]["Col1"] = DrpddSlabtype.SelectedValue;
dtCurrentTable.Rows[i - 1]["Col2"] = TextBoxLoadFrom.Text;
dtCurrentTable.Rows[i - 1]["Col3"] = TextBoxLoadTo.Text;
dtCurrentTable.Rows[i - 1]["Col4"] = TextBoxTimeFrom.Text;
dtCurrentTable.Rows[i - 1]["Col5"] = TextBoxTimeTo.Text;
dtCurrentTable.Rows[i - 1]["Col6"] = TextBoxFree.Text;
dtCurrentTable.Rows[i - 1]["Col7"] = TextBoxLoadRate.Text;
//dtCurrentTable.Rows[i - 1]["Col5"] = TextBoxLoadAmount.Text;
rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["CurrentTable"] = dtCurrentTable;
grvRateDetails.DataSource = dtCurrentTable;
grvRateDetails.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
SetPreviousData();
}
private void SetPreviousData()
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DropDownList DrpddSlabtype = (DropDownList)grvRateDetails.Rows[rowIndex].Cells[1].FindControl("ddSlabtype");
TextBox TextBoxLoadFrom = (TextBox)grvRateDetails.Rows[rowIndex].Cells[2].FindControl("txtLoadFrom");
TextBox TextBoxLoadTo = (TextBox)grvRateDetails.Rows[rowIndex].Cells[3].FindControl("txtLoadTo");
TextBox TextBoxTimeFrom = (TextBox)grvRateDetails.Rows[rowIndex].Cells[4].FindControl("txtTimeFrom");
TextBox TextBoxTimeTo = (TextBox)grvRateDetails.Rows[rowIndex].Cells[5].FindControl("txtTimeTo");
TextBox TextBoxFree = (TextBox)grvRateDetails.Rows[rowIndex].Cells[6].FindControl("txtfree");
TextBox TextBoxLoadRate = (TextBox)grvRateDetails.Rows[rowIndex].Cells[7].FindControl("txtLoadRate");
// TextBox TextBoxLoadAmount = (TextBox)grvRateDetails.Rows[rowIndex].Cells[5].FindControl("txtTotal");
DrpddSlabtype.SelectedValue = dt.Rows[i]["Col1"].ToString();
TextBoxLoadFrom.Text = dt.Rows[i]["Col2"].ToString();
TextBoxLoadTo.Text = dt.Rows[i]["Col3"].ToString();
TextBoxTimeFrom.Text = dt.Rows[i]["Col4"].ToString();
TextBoxTimeTo.Text = dt.Rows[i]["Col5"].ToString();
TextBoxFree.Text = dt.Rows[i]["Col6"].ToString();
TextBoxLoadRate.Text = dt.Rows[i]["Col7"].ToString();
//TextBoxLoadAmount.Text = dt.Rows[i]["Col5"].ToString();
rowIndex++;
}
}
}
}
Regards
Rima Gandhi.
Software Developer.