How to bind the Textbox value in GridView

Question

0.00/5 (No votes)

See more:

I have a Place holder. In that Text boxes are Dynamically generated. I have to put the Value of the Text Boxes in a GridView Column and update that in database.How will i bind the textboxes dynamically generated to a grid view

Posted 13-Feb-14 21:09pm

Member 10578683

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Feb-14 3:38am

What have you tried and where is the problem?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OPees · Answer 1 · 2014-02-13T21:39:00

Solution 1

try this:

C#

<asp:textbox id="txtName" enabled="false" runat="server" >Text='<%# Eval("YourFieldName") %>'></asp:textbox>

Posted 13-Feb-14 21:39pm

OPees

v2

Comments

Member 10578683 14-Feb-14 3:58am

int quantity = Convert.ToInt32(txtQuantity.Text.Trim());
// string serials = txtSerials.Text;
string status = "Under Repair";
//string qryCheck = "Select GatePassNo from Product_Details ";
//string[] serialArray = serials.Split(';');
if (txtQuantity.Text != "")
{
try
{
for (int i = 0; i < quantity; i++)
{

string tb1Val = string.Empty;
TextBox txtBox1 = (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();
con.Open();

string qryInsertProduct = "insert into Product_Details(GatePassNo,ClientID,Product_name,SerialNo,Status,CheckIN_Date ,Customer_Name, Customer_location) values('" + GatePassNo + "','" + clientID + "','" + productName + "','" + tb1Val + "','" + status + "','" + entryDate + "','" + ddlCName.SelectedItem.Value + "','" + ddlCLocation.SelectedItem.Value + "')";
SqlCommand comInsertProduct = new SqlCommand(qryInsertProduct, con);
comInsertProduct.ExecuteNonQuery();
con.Close();
gdvProducts.Visible = true;
PopulateGridView();

}
}

catch (Exception ex)
{

}

finally
{
if (con.State == ConnectionState.Open)
{
con.Close();

}

<asp:GridView ID="gdvProducts" runat="server" AutoGenerateColumns="false" OnRowCancelingEdit="gdvProducts_RowCancelingEdit"
OnRowEditing="gdvProducts_RowEditing" OnRowUpdating="gdvProducts_RowUpdating"
OnRowDataBound="gdvProducts_RowDataBound"
önrowdeleting="gdvProducts_RowDeleting">
<columns>
<asp:TemplateField HeaderText="ID" ItemStyle-Width="10%" HeaderStyle-Font-Size="11px">
<itemtemplate>
<asp:Label ID="lblID" runat="server" Text='<%# Bind("ID") %>'>

<asp:TemplateField HeaderText="Product Name" ItemStyle-Width="20%" HeaderStyle-Font-Size="11px">
<itemtemplate>
<asp:Label ID="lblProduct" runat="server" Text='<%# Bind("Product_Name")%>'>

<edititemtemplate>
<asp:TextBox ID="txt_Edit_Product" runat="server" Text='<%# Bind("Product_Name") %>'>

<asp:TemplateField HeaderText="Serial Number" ItemStyle-Width="20%" HeaderStyle-Font-Size="11px">
<itemtemplate>
<asp:Label ID="lblSerial" runat="server" Text='<%# Bind("SerialNo")%>'>

<edititemtemplate>
<%--<asp:PlaceHolder ID="PlaceHolder1" runat="server">--%>
<asp:TextBox ID="tb1" enabled="false" runat="server" xmlns:asp="#unknown" Text='<%# Eval("SerialNo") %>'>
<%----%>

<asp:TemplateField HeaderText="Action" ControlStyle-ForeColor="Black" ItemStyle-Width="20%"
HeaderStyle-Font-Size="11px">
<itemtemplate>

<asp:ImageButton CssClass="txtBt

Member 10578683 14-Feb-14 4:00am

This my code please check it and tell where is the problem

OPees 14-Feb-14 4:14am

means which field you are not able to bind?

Member 10578683 14-Feb-14 5:05am

SerialNo field. actually i have to bind the values that we enter in the randomly generated textboxes

OPees 14-Feb-14 5:25am

sorry I m not getting you? is your SerialNo field is coming from DB?
if Yes have you tried '<%# Eval("SerialNo") %>'>?

Member 10578683 14-Feb-14 6:15am

My problem is the text boxes are in place holder and when we change quantity the textboxes are generating accordingly and inside that textboes i m writing the serial numbers. there is a button save. when i m clicking save the serial number that i ve entered in textboxes should save in the database. So how will i update my database.it is not updating

OPees 14-Feb-14 5:31am

refer here

http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

Member 10578683 14-Feb-14 6:05am

yes actually at first i have to store my randomly generated text box value in database that value need to bind in grid view. but database is not updating

OPees 14-Feb-14 6:41am

means What is going inside db? blank or some value? what about other columns ?
and How you r generating Serial no.?

Member 10578683 14-Feb-14 6:55am

inside data base all column are inserted except the SerialNo column.

OPees 14-Feb-14 6:50am

for generating serial no automatic in grid use this

Text='<%# (GridView1.PageSize * GridView1.PageIndex) + Container.DisplayIndex + 1 %>'>