binding textbox in gridview

Question

0.00/5 (No votes)

See more:

I am using C#,asp.net 2.0,server 2005 and visual studio 2005

Can anybody help with the following problem:

initially i load gridview (contains 1 textbox) with some values using...

in aspx
<asp:TextBox Text='<%#Eval("col1") %>'/>

in C#:
 
Con.Open();
             SqlDataAdapter dt = new SqlDataAdapter("select col1 from Table1", Con);
             DataSet ds = new DataSet();
             dt.Fill(ds);
             GridView1.DataSource = ds;
             GridView1.DataBind();

now i click one buttton and when i click button the gridview should be loaded with some new values and i use the following function to bind the gridview.:

XML

<pre>


in C#:

Con.Open();
             SqlDataAdapter dt = new SqlDataAdapter("select col2 from Table1", Con);
             DataSet ds = new DataSet();
             dt.Fill(ds);
             GridView1.DataSource = ds;
             GridView1.DataBind();


</pre>

what i should write a common in

Text='<% %>'

, so that the gridview is binded with function specified values

please help me.
Thanks in Advance.
Regards,
Karan

Posted 11-Jun-11 21:38pm

karan joshua

Updated 24-Apr-19 1:58am

v2

Add a Solution

6 solutions

Solution 1

Use ItemDataBound event of DataGrid, and there check the DataSource and bind the TextBox dynamically.

Posted 11-Jun-11 22:01pm

nit_singh

Comments

karan joshua 12-Jun-11 4:07am

how to do that?
any code help?
My problem is if i use <pre>Text='<%#Eval("col1") %>'</pre> second time it will be col2.

Solution 4

use databind in the edittemplate of your gridview.

first, click the smart tag, then edit template.
then click on your textbox smart tag, click databind.

Posted 11-Jun-11 23:29pm

chaosgray

Solution 6

<%#(String.IsNullOrEmpty(Eval("col1").ToString()) ? Eval("col2") : Eval("col1"))%>

Posted 12-Jan-16 18:00pm

Phanindra Baddula

Updated 12-Jan-16 18:02pm

v3

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)

RaviRanjanKr · Accepted Answer · 2011-06-11T22:32:00

Solution 2

Take a look there-CP Question-Answer[^] same question is replied with nice solutions.
You should write as

<asp:textbox id="YourControlID" runat="Server" xmlns:asp="#unknown">
          Text='<%# Bind("ColumnName") %>'  /></asp:textbox>

Posted 11-Jun-11 22:32pm

RaviRanjanKr

Comments

karan joshua 12-Jun-11 4:41am

thank u for your link...
If i use say <pre>Text='<%# Bind("col1") %>'</pre>

next time time it will be <pre>Text='<%# Bind("col2") %>'</pre> in aspx page. but i cant change it to that when the application runs.

Any solution?

thatraja 12-Jun-11 6:16am

Spot on, 5!

nit_singh · Accepted Answer · 2011-06-11T23:07:00

I have two tables

dt.Columns.Add("Col1");
dt.Rows.Add("Col11");
dt1.Columns.Add("Col2");
dt1.Rows.Add("Col12");

I am binding GridView1 first time with dt and second time with dt1 which are having different ColumnName.
And I am checking the DataSource property

public void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        TextBox txt = (TextBox)e.Row.FindControl("txtCol");
        if (GridView1.DataSource == dt)
        {
            txt.Text = DataBinder.Eval(e.Row.DataItem, "Col1").ToString();
        }
        else if (GridView1.DataSource == dt1)
        {
            txt.Text = DataBinder.Eval(e.Row.DataItem, "Col2").ToString();
        }
    }
}

Shahriar Iqbal Chowdhury/Galib · Accepted Answer · 2011-06-11T23:36:00

Hi,
You can use a common column alias name for sql queries and use that alias column name for data bind. Like try this code below,
in *.aspx

<asp:TextBox Text='<%#Eval("mycolumn") %>'/>

in *.aspx.cs

///For 1st DataBind
SqlDataAdapter dt = new SqlDataAdapter("select col1 as mycolumn from Table1", Con);
///For 2nd DataBind
SqlDataAdapter dt = new SqlDataAdapter("select col2 as mycolumn from Table1", Con);

as you can see both queries use same column alias, so switching data source for GridView wont effect the binding.

Hope this will help.