Hello,

I am wondering how to display information from a database in a textbox on a web form using VB.NET. I know that the following code doesn't work because the collection is read-only:

objSomething = Request.form("txtFName")

Can someone please tell me or direct me in the right direction on how to get this to work. My reasoning for doing this is to display User details so they may be updated via a form.

Thanks in Advance,
Mark.

Hey,

Get the data into a DataSet or DataTable, then do:

'If using dataset, get the specific Data table
Dim objTable As DataTable = objDataSet.Tables(0)
If (objTable.Rows.Count > 0) Then
    Dim objRow As DataRow = objTable.Rows(0)
    TextBox1.Text = objRow("FieldName").ToString()
End If

Brian

Thanks for the reply Bmains,

But txtSomething.text is a server control in ASP.NET however I must use HTML textboxes...(i.e. <input text..so on)

Any advice?

Thanks,
Mark

Hey,

You have to make the control server-based anyways, by adding a runat="server", which in both server-based and html-based forms, would look like:

<asp:TextBox id="TextBox1" runat="server"/>
<input type="text" id="TextBox1" runat="server"/>

The textbox absolutely has to have the runat="server" attribute.

Brian

Hey,

I put in the runat tag, but still get an error. I know that the error is caused by the Request.Form collection is read-only, therefore I can't set values from the DB to the textboxes on the form.

How can I can the get the values from the DB to display in the textboxes on the form so a user may be able to editing those values.

Thanks,
Mark

Hey,

Use TextBox1.Text, as stated previously. Don't use Request.Form. The Textbox, with runat="server", can access the textboxes directly, or any other server control for that matter.

Brian

Thanks Brian,

But I now encounter the following error:
------
The base class includes the field 'txtname', but its type (System.Web.UI.WebControls.TextBox) is not compatible with the type of control (System.Web.UI.HtmlControls.HtmlInputText).
-----

line in my code:
---
<input type="text" id="txtname" runat="server">
-----

Thanks,
Mark

Hey,

Well, that would be true, but I don't know what you are doing with it... Could you post any code? Actually, the simplest fix would be to change:

<input type="text" id="txtname" runat="server">

to:

<asp:TextBox id="txtname" runat="server"/>

You have the same benefits, plus it probably is better to do it this way anyway.

Brian

Thanks Brian,

I have it working now...