How to save value into database through textbox which is in gridview and fetch it...

Question

0.00/5 (No votes)

See more:

I have taken textbox in gridview and want to save textbox value in database and then fetch it in textbox of gridview itself

//source code

XML

<asp:GridView ID="GrdATCart" AutoGenerateColumns="false" runat="server"
            onrowcommand="GrdATCart_RowCommand"
            onselectedindexchanged="GrdATCart_SelectedIndexChanged">
    <Columns>
        <asp:TemplateField HeaderText="Quantity">
            <ItemTemplate>
                <asp:TextBox ID="TxtATquantity" runat="server" Width="60px"></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>

Posted 13-Dec-12 23:58pm

Member 9579525

Updated 14-Dec-12 2:04am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Dec-12 8:08am

Tell me in which event in code behind you want to store the data?
Please post the code behind functions related to GridView, where you want to store the textbox data?

rahkan 15-Dec-12 8:46am

Is there a reason the textbox is not bound to any data? Normally you'll have something like Text='<%# Bind("Quantity") %>' inside of the textbox

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AshishChaudha · Answer 1 · 2012-12-18T23:16:00

Solution 3

Please follow the link below:

Implementing Cumulative total and Select All functionality with Events in ASP.NET GridView[^]

Posted 18-Dec-12 23:16pm

AshishChaudha

Member 10510822 · Answer 2 · 2012-12-14T02:37:00

Solution 2

Please, follow this article:

CodeProject Frequently Asked Questions Series 1: The ASP.NET GridView[^]

Posted 14-Dec-12 2:37am

Member 10510822

ashokmmrk · Answer 3 · 2012-12-14T02:35:00

Hi,

Try this on button click and fetch value from textbox

C#

foreach (GridViewRow row in gridview1.Rows) 
        {
            if (row.RowType == DataControlRowType.DataRow) 
            {
                Textbox txt = (Textbox) row.FindControl("txt1");
                if (txt != null )
                {
                    string value=txt.Text;
//Here you can write your query to insert into database
                }
            }
        }

How to save value into database through textbox which is in gridview and fetch it...

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

How to save value into database through textbox which is in gridview and fetch it...

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us