Remove From My Forums

Clear Text from gridview textbox making grid showing no data

Question

User-172769993 posted

Grid gridrequisitionitems getting its data based on data selected from DropDownList dllcat.

btnaddshow will open the second view wheres gridrequisitionitems is located.

when i tried to empty TextBox txtCalcQty

using below code

protected void btnaddshow_Click(object sender, EventArgs e)
{
  foreach (GridViewRow row in gridrequisitionitems.Rows)
  {
  TextBox txtCalcQty = row.Cells[3].FindControl("txtCalcQty") as TextBox;
  txtCalcQty.Text = "";
  }
  MultiView1.ActiveViewIndex = 1;
}

Grid view will not display any data

<asp:GridView ID="gridrequisitionitems" ShowFooter="True" OnRowDataBound="gridrequisitionitems_RowDataBound" CssClass="table text-nowrap" GridLines="None" DataSourceID="SqlDsrequisition" DataKeyNames="ItemID" runat="server" AutoGenerateColumns="False">
<Columns>
    <asp:TemplateField HeaderText="Select">
        <ItemTemplate>
            <asp:CheckBox ID="chkSel" Checked="true" runat="server" />
        </ItemTemplate>
    </asp:TemplateField>
    <asp:BoundField DataField="ItemCode" HeaderText="Item Code" NullDisplayText="n/a" SortExpression="ItemCode" />
    <asp:BoundField DataField="ItemName" HeaderText="Item Name" SortExpression="Item Name" />
    <asp:TemplateField HeaderText="Quantity" SortExpression="Quantity">
        <ItemTemplate>
            <asp:TextBox ID="txtCalcQty" Width="120" TextMode="Number" min="0" step="any" CssClass="Quantity form-control" runat="server"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Unit Price" SortExpression="UnitPrice">
        <ItemTemplate>
            <asp:TextBox ID="txtCalcUnitprice" ReadOnly="true" Text='<%# Bind("UnitPrice") %>' Width="120" CssClass="form-control  UnitPrice" runat="server"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>

    <asp:TemplateField HeaderText="Total Amount">
        <ItemTemplate>
            <asp:Label ID="lbltotalamount" CssClass="multTotal" runat="server"></asp:Label>
        </ItemTemplate>
        <FooterTemplate>
            <asp:Label ID="lblGrandAmount" Text="" runat="server" CssClass="lblGrandAmount" />
        </FooterTemplate>
    </asp:TemplateField>
</Columns>

<asp:SqlDataSource ID="SqlDsrequisition" runat="server" ConnectionString="<%$ ConnectionStrings:ConnString %>" SelectCommand="">
    <SelectParameters>                                           
    <asp:ControlParameter ControlID="dllcat" Name="CategoryID" PropertyName="SelectedValue" />
    </SelectParameters>
</asp:SqlDataSource>

Sunday, September 25, 2016 10:02 PM

Answers

User-707554951 posted

Hi asp.net4,
From your description, I tried to restore you problem, the following is my code:

 <asp:SqlDataSource ID="SqlDsrequisition" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT top 5 [ProductID], [SupplierID], [UnitPrice], [ProductName] FROM [Products]"></asp:SqlDataSource>
    </div>
        
         <asp:MultiView ID="MultiView1" runat="server">
            <asp:View ID="viewProductSearch" runat="server">
               
              <asp:Button ID="Button1" runat="server" Text="Clear Text" OnClick ="btnaddshow_Click"/>
            </asp:View>
            <asp:View ID="viewCategorySearch" runat="server">
               <asp:GridView ID="gridrequisitionitems" ShowFooter="True"  CssClass="table text-nowrap" GridLines="None" DataSourceID="SqlDsrequisition" DataKeyNames="ProductID" runat="server" AutoGenerateColumns="False">
<Columns>
    <asp:TemplateField HeaderText="Select">
        <ItemTemplate>
            <asp:CheckBox ID="chkSel" Checked="true" runat="server" />
        </ItemTemplate>
    </asp:TemplateField>
    <asp:BoundField DataField="ProductID" HeaderText="Product ID" NullDisplayText="n/a" SortExpression="ProductID" />
    <asp:BoundField DataField="ProductName" HeaderText="Produc tName" SortExpression="ProductName" />
    <asp:TemplateField HeaderText="Quantity" SortExpression="Quantity">
        <ItemTemplate>
            <asp:TextBox ID="txtCalcQty" Width="120" TextMode="Number" min="0" step="any" CssClass="Quantity form-control" runat="server" Text="124"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Unit Price" SortExpression="UnitPrice">
        <ItemTemplate>
            <asp:TextBox ID="txtCalcUnitprice" ReadOnly="true" Text='<%# Bind("UnitPrice") %>' Width="120" CssClass="form-control  UnitPrice" runat="server"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Total Amount">
        <ItemTemplate>
            <asp:Label ID="lbltotalamount" CssClass="multTotal" runat="server" Text="3"></asp:Label>
        </ItemTemplate>
        <FooterTemplate >
            <asp:Label ID="lblGrandAmount" Text="footer" runat="server" CssClass="lblGrandAmount" />
        </FooterTemplate>
    </asp:TemplateField>
</Columns></asp:GridView>
            </asp:View>
        </asp:MultiView>&nbsp;<br />

CodeBehind:

protected void Page_Load(object sender, EventArgs e)
        {
            MultiView1.ActiveViewIndex = 0;
        }
       

        protected void btnaddshow_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow row in gridrequisitionitems.Rows)
            {
                TextBox txtCalcQty = row.Cells[3].FindControl("txtCalcQty") as TextBox;
                txtCalcQty.Text = "";
                MultiView1.ActiveViewIndex = 1;
            }
        }

It works well like the screenshot below:

So, is it what you want? If not, would you please provide more information about this, you could provide us with a screenshot for your problem, so that we could ensure you problem find a solution timely.
Hope this can help you. If you have any question and confusion about the problem. Please don't hesitate to let me know.
Best regards
Cathy

Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM

Monday, September 26, 2016 3:04 AM

Answered by:

Clear Text from gridview textbox making grid showing no data

Question

Answers