C# Binding Data to Text Box

Question

I am trying to bind a database row to a text box in C# so it is the default value (but the text box can still be edited).

The current issue i am having is that the text box will not let me attach a data source with the error (System.Web.UI.WebControls.TextBox does not contain a definition for 'DataSource'....)

I am able to succesfully bind the datasource to a drop down list, but using the same code for a text box does not work.

        txtBox1.DataSource = "DataSource";
        txtBox1.DataBind();

Wouldn't it be easier to just assign the value from the data source to the text box? A textbox would only be able to represent 1 row / column of data anyway. You could then apply the the value of the textbox back to the data source on save. Without more context of what your trying to do / how you're doing it, it's hard to say for sure how to best accomplish this. — jdoyle1983
– jdoyle1983, Commented Feb 7, 2013 at 12:42
please add tag WebControls (or something) so people like me dont get their hopes up - that its about Winforms :) — Jens Kloster
– Jens Kloster, Commented Feb 7, 2013 at 12:55

Daniel Hilgarth · Accepted Answer · 2013-02-07 12:42:23Z

2

The reason for that is that a DataSource contains multiple rows. A drop down can support that, as it will show one entry per row, but a TextBox doesn't support it. There is only one text field, which row from the data source should it use?

To set the text of a TextBox use the Text property.

answered Feb 7, 2013 at 12:42

Daniel Hilgarth

175k41 gold badges346 silver badges450 bronze badges

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

Comments

Luis Tellez · Accepted Answer · 2013-02-07 12:44:24Z

1

If you want to set a Value to the text box what you need to do is :

textBox1.Text= "MyText";

then the user can change that value and on the postback you use that value for whatever you need and the user

answered Feb 7, 2013 at 12:44

Luis Tellez

3,0331 gold badge23 silver badges30 bronze badges

Comments

Echilon · Accepted Answer · 2013-02-07 12:43:36Z

0

You can't bind a DataSource to a TextBox in WebForms. You can set the text to a field in a DataRow using the indexer.

`txtBox1.Text = datarow["SomeField"]`

answered Feb 7, 2013 at 12:43

Echilon

10.3k33 gold badges138 silver badges226 bronze badges

Comments

Igoy · Accepted Answer · 2013-02-07 12:47:41Z

0

DataView dv = DataSource.DefaultView;

dv.RowFilter = "id=1"; // or whatever as per your need to make sure only 1 row is there
textBox1.DataBindings.Add("Text",dv,"id");

answered Feb 7, 2013 at 12:47

Igoy

2,96225 silver badges23 bronze badges

Comments

Vintage Coder · Accepted Answer · 2024-09-26 05:50:03Z

Note: TextBox Control alone doesn't have the Datasource property.

If TextBox control is used inside the item template of Databound controls like GridView,DataGrid,ListView,DetailsView,FormView, you can used the eval,bind,xpath based on that chosen datasource like sql,xml,object etc..

Eg,

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("TITLE")%>'> </asp:TextBox>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TITLE")%>'> </asp:TextBox>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# XPath("TITLE")%>'> </asp:TextBox>

If TextBox control is used alone or outside of databound controls, you can use in the below format.

<asp:TextBox ID="TextBox1" runat="server" Text='<%#TITLE%>'> </asp:TextBox>

in code behind file, simply use in any of the page lifecycle events.

this.Page.Databind();

Collectives™ on Stack Overflow

C# Binding Data to Text Box

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related