Capturing SQL Recordset to Control

[Guest]

I have a SQL DataSource that returns: first name, last name, title, UserID.
I now want to capture each of these records and place them into their
corresponding textboxes on my webforms, how do I accomplish this.
thank you.

 

[Alexey Smirnov]

I have a SQL DataSource that returns: first name, last name, title, UserID.
I now want to capture each of these records and place them into their
corresponding textboxes on my webforms, how do I accomplish this.
thank you.

something like the following code

ASPX

ProductName = <asp:label id="lblProductName" runat="server" />
<aspbjectdatasource id="odsProducts" runat="server"
selectmethod="GetProductByProductID"
typename="NorthwindTableAdapters.ProductsTableAdapter">
<selectparameters>
<asparameter defaultvalue="1" name="ProductID" type="Int32" />
</selectparameters>
</aspbjectdatasource>

CODE-BEHIND

protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataView dv = (DataView)odsProducts.Select();

lblProductName.Text = dv[0]["ProductName"].ToString();
}
}

 

[Guest]

Alexey,
Will this work for Visual Web Developer Express? Im doing research on table
adapters and notice much of the objects in the instructions are not in the
menubars & tools. My apologies Im new to ASP.Net world. thanks.

I have a SQL DataSource that returns: first name, last name, title, UserID.
I now want to capture each of these records and place them into their
corresponding textboxes on my webforms, how do I accomplish this.
thank you.

something like the following code

ASPX

ProductName = <asp:label id="lblProductName" runat="server" />
<aspbjectdatasource id="odsProducts" runat="server"
selectmethod="GetProductByProductID"
typename="NorthwindTableAdapters.ProductsTableAdapter">
<selectparameters>
<asparameter defaultvalue="1" name="ProductID" type="Int32" />
</selectparameters>
</aspbjectdatasource>

CODE-BEHIND

protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataView dv = (DataView)odsProducts.Select();

lblProductName.Text = dv[0]["ProductName"].ToString();
}
}