i am adding item from dropdown and their qty from textbox .i want when i add item and qty into gridview then their qty display into label which is outside of gridview.if item will same means that item exit in gridview and new adding item ,then both qty get
sum and display in label(lbitpqty0).
Helping you always. Don't forget to click "Mark as Answer" on the post that helped you.
♠ ASP.NET Core Tutorials → Start from the Beginning and become an Expert in 30 days time ♠
Accroding to your description and codes,could you tell us where write the code you post.
Since you don't post more details,I create a demo.When I click the button,the textbox data will be added into gridview.At the same time,the value will display in the label.Then,you could sum the same Descriptionitem's qty.
If it's wrong,you could post your full codes and more details of your requirment to us.
if (DropDownList1.SelectedItem.Value != null)
{
int codeitem = Convert.ToInt32(DropDownList1.SelectedItem.Value.ToString());
string Descriptionitem = DropDownList1.SelectedItem.Text.ToString();
DataTable dtgridview = ViewState["dt"] as DataTable;
DataRow dr2 = dtgridview.NewRow();
bool ifExist = false;
foreach (DataRow dr in dtgridview.Rows)
{
if (dr["Prdno"].ToString() == TextBox1.Text.Trim())
{
ifExist = true;
break;
}
}
if (!ifExist)
{
dr2["Prdno"] = TextBox1.Text.Trim();
dr2["Codeitem"] = codeitem;
dr2["Descriptionitem"] = Descriptionitem;
dr2["Orderno"] = txtorderno.Text;
dr2["QTY"] = txtqty.Text;
dtgridview.Rows.Add(dr2);
// dtgridview.Rows.Add(dr2);
ViewState["dt"] = dtgridview;
GridView1.DataSource = dtgridview;
GridView1.DataBind();
lbOrderqty.Text= txtorderno.Text;
lbPackpqty.Text= txtqty.Text;
int qty =0;
foreach (GridViewRow gv in GridView1.Rows)
{
string x = ((Label)gv.FindControl("Descriptionitem")).Text;
if (DropDownList1.SelectedItem.Text == x)
{
int result= Convert.ToInt32(((Label)gv.FindControl("QTY")).Text);
qty += result;
}
lbitpqty0.Text = qty.ToString();
}
}
else
{
// this.lbgvck.Visible = true;
lbgv.Text = "Bale Already Added...";
}
}
Result:
Best regards,
Yijing Sun
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Member
116 Points
274 Posts
Display gridview item wise qty in label(lbitpqty0) at the time of adding in gridview.
Jun 24, 2020 07:12 PM|akhterr|LINK
i am adding item from dropdown and their qty from textbox .i want when i add item and qty into gridview then their qty display into label which is outside of gridview.if item will same means that item exit in gridview and new adding item ,then both qty get sum and display in label(lbitpqty0).
here is my html
<asp:TextBox ID="TextBox1" AutoPostBack="true" runat="server" Placeholder="Input Bale No" OnTextChanged="TextBox1_TextChanged" Height="16px" Width="100px" style="margin-left: 0px"></asp:TextBox> <asp:DropDownList ID="DropDownList1" runat="server" Enabled="false" Height="20px" Width="130px"> </asp:DropDownList> <asp:TextBox ID="txtorderno" Placeholder="Order No" readonly="true" runat="server" Height="16px" Width="38px"></asp:TextBox> <asp:TextBox ID="txtqty" Placeholder="QTY" readonly="true" runat="server" Height="16px" Width="21px"></asp:TextBox> <asp:TextBox ID="txtpid" Readonly="true" runat="server" Height="19px" Width="55px"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Add" Visible="false" OnClick="Button1_Click" Height="26px" Width="35px" /> <asp:Label ID="Label1" runat="server" Text="." ForeColor="#CC0000"></asp:Label> <asp:Label ID="lbgvck" runat="server" Text="." ForeColor="#CC0000"></asp:Label> <asp:Label ID="lbpk" runat="server" Text="."></asp:Label> <asp:Label ID="lbgv" runat="server" Text="."></asp:Label> Order QTY :<strong><asp:Label ID="lbitqty" runat="server" Text="Label"></asp:Label> </strong> Pack QTY : <strong> <asp:Label ID="lbitpqty" runat="server" Text="Label"></asp:Label> <asp:Label ID="lbitpqty0" runat="server" Text="Label"></asp:Label> </strong> </div> <table class="auto-style1"> <tr> <td> </td> <td> <asp:GridView ID="GridView1" runat="server" HeaderStyle-BackColor="#66ccff" HeaderStyle-ForeColor="White" CssClass="mygrdContent" PagerStyle-CssClass="pager" HeaderStyle-CssClass="header" RowStyle-CssClass="rows" AutoGenerateColumns="false" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" AllowSorting="True" OnRowDataBound="GridView1_RowDataBound" ShowFooter="True" > <Columns> <asp:TemplateField HeaderText="Bale_No"> <ItemTemplate> <asp:Label ID="Prdno" runat="server" Text='<%#Bind("Prdno")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Description"> <ItemTemplate> <asp:Label ID="Descriptionitem" runat="server" Text='<%#Bind("Descriptionitem")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Orderno" > <ItemTemplate> <asp:Label ID="Orderno" runat="server" Text='<%#Bind("Orderno")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="QTY" > <ItemTemplate> <asp:Label ID="QTY" runat="server" Text='<%#Bind("QTY")%>'></asp:Label> </ItemTemplate> <FooterTemplate><asp:Label ID="lblTotal" runat="server"></asp:Label></FooterTemplate> </asp:TemplateField> <asp:CommandField ShowDeleteButton="True" ButtonType="Button" /> </Columns> <HeaderStyle BackColor="#66CCFF" ForeColor="White"></HeaderStyle> <SelectedRowStyle BackColor="Yellow" /> </asp:GridView>C# code adding item and qty into gridview
if (DropDownList1.SelectedItem != null) { // get value and text which item you have selected int codeitem = Convert.ToInt32(DropDownList1.SelectedItem.Value.ToString()); string Descriptionitem = DropDownList1.SelectedItem.Text.ToString(); //add the selected item to gridview DataTable dtgridview = ViewState["dt"] as DataTable; DataRow dr2 = dtgridview.NewRow(); bool ifExist = false; foreach (DataRow dr in dtgridview.Rows) { if (dr["Prdno"].ToString() == TextBox1.Text.Trim()) { ifExist = true; break; } } if (!ifExist) { dr2["Prdno"] = TextBox1.Text.Trim(); dr2["Codeitem"] = codeitem; dr2["Descriptionitem"] = Descriptionitem; dr2["Orderno"] = txtorderno.Text; dr2["QTY"] = txtqty.Text; if (dtgridview.Rows.Count < Convert.ToInt16(DDLPktype.SelectedItem.Value)) { dtgridview.Rows.Add(dr2); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('You can not insert more than " + dtgridview.Rows.Count + " rows')", true); } // dtgridview.Rows.Add(dr2); ViewState["dt"] = dtgridview; GridView1.DataSource = dtgridview; GridView1.DataBind(); } else { // this.lbgvck.Visible = true; lbgv.Text = "Bale Already Added..."; } clear();Participant
1253 Points
936 Posts
Re: Display gridview item wise qty in label(lbitpqty0) at the time of adding in gridview.
Jun 25, 2020 05:02 AM|yogyogi|LINK
You will have to do it with jQuery. See How to show sum of columns in the footer of the GridView with jQuery. To get some idea about the approach you need to follow.
♠ ASP.NET Core Tutorials → Start from the Beginning and become an Expert in 30 days time ♠
Contributor
3730 Points
1427 Posts
Re: Display gridview item wise qty in label(lbitpqty0) at the time of adding in gridview.
Jun 25, 2020 06:36 AM|yij sun|LINK
Hi akhterr,
Accroding to your description and codes,could you tell us where write the code you post.
Since you don't post more details,I create a demo.When I click the button,the textbox data will be added into gridview.At the same time,the value will display in the label.Then,you could sum the same Descriptionitem's qty.
If it's wrong,you could post your full codes and more details of your requirment to us.
More detaisl,you could refer to below codes:
<div> <asp:TextBox ID="TextBox1" AutoPostBack="true" runat="server" Placeholder="Input Bale No" OnTextChanged="TextBox1_TextChanged" Height="16px" Width="100px" style="margin-left: 0px"></asp:TextBox> <asp:DropDownList ID="DropDownList1" runat="server" Height="20px" Width="130px"> <asp:ListItem Text="A" Value="1"></asp:ListItem> <asp:ListItem Text="B" Value="2"></asp:ListItem> </asp:DropDownList> <asp:TextBox ID="txtorderno" Placeholder="Order No" runat="server" Height="16px" Width="38px"></asp:TextBox> <asp:TextBox ID="txtqty" Placeholder="QTY" runat="server" Height="16px" Width="21px"></asp:TextBox> <asp:TextBox ID="txtpid" Readonly="true" runat="server" Height="19px" Width="55px"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Add" OnClick="Button1_Click" Height="26px" Width="35px" /> <asp:Label ID="Label1" runat="server" Text="." ForeColor="#CC0000"></asp:Label> <asp:Label ID="lbgvck" runat="server" Text="." ForeColor="#CC0000"></asp:Label> <asp:Label ID="lbpk" runat="server" Text="."></asp:Label> <asp:Label ID="lbgv" runat="server" Text="."></asp:Label> Order QTY :<asp:Label ID="lbOrderqty" runat="server" Text=""></asp:Label> Pack QTY : <asp:Label ID="lbPackpqty" runat="server" Text=""></asp:Label> QTY: <asp:Label ID="lbitpqty0" runat="server" Text=""></asp:Label> </div> <table class="auto-style1"> <tr> <td> </td> <td> <asp:GridView ID="GridView1" runat="server" HeaderStyle-BackColor="#66ccff" HeaderStyle-ForeColor="White" CssClass="mygrdContent" PagerStyle-CssClass="pager" HeaderStyle-CssClass="header" RowStyle-CssClass="rows" AutoGenerateColumns="false" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" AllowSorting="True" OnRowDataBound="GridView1_RowDataBound" ShowFooter="True" > <Columns> <asp:TemplateField HeaderText="Bale_No"> <ItemTemplate> <asp:Label ID="Prdno" runat="server" Text='<%#Bind("Prdno")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Description"> <ItemTemplate> <asp:Label ID="Descriptionitem" runat="server" Text='<%#Bind("Descriptionitem")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Orderno" > <ItemTemplate> <asp:Label ID="Orderno" runat="server" Text='<%#Bind("Orderno")%>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="QTY" > <ItemTemplate> <asp:Label ID="QTY" runat="server" Text='<%#Bind("QTY")%>'></asp:Label> </ItemTemplate> <FooterTemplate><asp:Label ID="lblTotal" runat="server"></asp:Label></FooterTemplate> </asp:TemplateField> <asp:CommandField ShowDeleteButton="True" ButtonType="Button" /> </Columns> <HeaderStyle BackColor="#66CCFF" ForeColor="White"></HeaderStyle> <SelectedRowStyle BackColor="Yellow" /> </asp:GridView> </td> </tr> </table>if (DropDownList1.SelectedItem.Value != null) { int codeitem = Convert.ToInt32(DropDownList1.SelectedItem.Value.ToString()); string Descriptionitem = DropDownList1.SelectedItem.Text.ToString(); DataTable dtgridview = ViewState["dt"] as DataTable; DataRow dr2 = dtgridview.NewRow(); bool ifExist = false; foreach (DataRow dr in dtgridview.Rows) { if (dr["Prdno"].ToString() == TextBox1.Text.Trim()) { ifExist = true; break; } } if (!ifExist) { dr2["Prdno"] = TextBox1.Text.Trim(); dr2["Codeitem"] = codeitem; dr2["Descriptionitem"] = Descriptionitem; dr2["Orderno"] = txtorderno.Text; dr2["QTY"] = txtqty.Text; dtgridview.Rows.Add(dr2); // dtgridview.Rows.Add(dr2); ViewState["dt"] = dtgridview; GridView1.DataSource = dtgridview; GridView1.DataBind(); lbOrderqty.Text= txtorderno.Text; lbPackpqty.Text= txtqty.Text; int qty =0; foreach (GridViewRow gv in GridView1.Rows) { string x = ((Label)gv.FindControl("Descriptionitem")).Text; if (DropDownList1.SelectedItem.Text == x) { int result= Convert.ToInt32(((Label)gv.FindControl("QTY")).Text); qty += result; } lbitpqty0.Text = qty.ToString(); } } else { // this.lbgvck.Visible = true; lbgv.Text = "Bale Already Added..."; } }Result:
Best regards,
Yijing Sun