add columns with textboxes in gridview using C#

Question

I'm working on a shopping cart in a website and I have my items(which have been added to the cart) in an arraylist. And using these values I've read the rest of the values from the db and and have populated on the gridview successfully.

        if (d1.Read())
        {
            d1.Close();
            sda.SelectCommand = searchResult;
            sda.Fill(dt);
            GridView2.DataSource = dt;
            GridView2.DataBind();
        }

How can I add an additional column named "Quantity" in this gridview along with a text box so that user can enter a value for the qunatity for each item displayed in the gridview?

Any help/suggestions/links would be greatly appreciated.

thanks,

//edit 2

<asp:GridView ID="GridView2" runat="server" BackColor="#388AD0"
    BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black"
    GridLines="Vertical" Height="160px" Style="left: 72px;
    position: relative; top: 8px" Width="504px" AllowPaging="True" PageSize="5">
    <FooterStyle BackColor="#E0E0E0" />
    <PagerStyle BackColor="Silver" ForeColor="Black" HorizontalAlign="Center" />
    <SelectedRowStyle BackColor="#388AD0" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
    <AlternatingRowStyle BackColor="#388AD0" />
    <PagerSettings Mode="NextPrevious" />
</asp:GridView>

//edit 3

public void additem(string additem) 
{
    DataTable dt = new DataTable();
    string ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ewap_k.mdf;Integrated Security=True;User Instance=True";
    using (SqlConnection searchCon = new SqlConnection(ConnectionString))
    {
        using (SqlCommand searchResult = new SqlCommand("SELECT ItemID, Name, RelDate, Price, Status FROM item_k WHERE ItemID IN ( " + itemIDs + ")", searchCon))
        {
            searchCon.Open();
            SqlDataReader d1 = searchResult.ExecuteReader();
            SqlDataAdapter sda = new SqlDataAdapter();

            if (d1.Read())
            {
                d1.Close();
                sda.SelectCommand = searchResult;
                sda.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
            else { }
            searchCon.Close();
        }
    }
}

//edit 4

<asp:GridView ID="GridView1" runat="server" Style="left: 8px; position: relative;
    top: 0px">
    <Columns>
        <asp:BoundField DataField="ItemID"  Visible="false"/>
        <asp:BoundField DataField="Name" />
        <asp:BoundField DataField="RelDate" />
        <asp:TemplateField>
        <ItemTemplate>
            <asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
        <asp:BoundField DataField="Price" />
        <asp:BoundField DataField="Status" />
    </Columns>
</asp:GridView>

Yup, prior to your FooterStyle, you need to add specific BoundFields for the fields you want to show, along with the TemplateField. See my answer for an updated edit. — nkirkes
– nkirkes, Commented May 23, 2009 at 19:55

nkirkes · Accepted Answer · 2009-05-23 19:57:24Z

4

You can add a template field and drop the textbox in the ItemTemplate as such:

<asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>

[Edit] Here's a more complete grid:

<asp:GridView ID="GridView1" runat="server">
    <Columns>
        <asp:BoundField />
        <asp:BoundField />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Notice that the TemplateField shows up wherever I decide to put it in the list of columns. If that still isn't working for you, can you post your GridView markup so I can see what you've got?

[Edit 2] Here's an updated version of your grid. You'll just need to set up the BoundFields to bind to whichever value in your dataset that you need.

<asp:GridView ID="GridView2" runat="server" BackColor="#388AD0" BorderColor="Black"
    BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical"
    Height="160px" Style="left: 72px; position: relative; top: 8px" Width="504px"
    AllowPaging="True" PageSize="5">
    <Columns>
        <asp:BoundField />
        <asp:BoundField />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    <FooterStyle BackColor="#E0E0E0" />
    <PagerStyle BackColor="Silver" ForeColor="Black" HorizontalAlign="Center" />
    <SelectedRowStyle BackColor="#388AD0" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
    <AlternatingRowStyle BackColor="#388AD0" />
    <PagerSettings Mode="NextPrevious" />
</asp:GridView>

edited May 23, 2009 at 19:57

answered May 23, 2009 at 19:14

nkirkes

2,6752 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

pier Over a year ago

thanks, I tried that and it worked. This new column appears as the 1st column. How can I put it between the columns I want?

Henrik P. Hessel Over a year ago

Define the order by adding BoundFields and put your TemplateField where you like it.

pier Over a year ago

@mannish: I tried your code, and that would just create 2 columns infront of the column with textbox. Remember the values I want the gridview to display are taken from the db

pier Over a year ago

@rAyt: I guess your mentioning the samething which mannish had mentioned previously?

nkirkes Over a year ago

You'll still get the values from the database, but you have to specifically bind the values from your dataset rather than allow it to autobind the columns. If you're auto binding your dataset in your code behind, you might be able to dynamically add the template column after the grid has been populated, but I think that's the more difficult/buggy route. It would be better to specify the columns and values you want ahead of time which gives you greater control over what goes where.

|

Collectives™ on Stack Overflow

add columns with textboxes in gridview using C#

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related