Using values from SqlDataSource in code behind

Question

After the SQLDataSource gets the values from the database, I want to be able to use these values in the code behind. Kindly spare 5 minutes and give me some suggestions.

ASPX Markup:

<h2 id="pageHeader" runat="server"></h2>
            <div id="pageContent" runat="server">

            </div> 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:mkkConnectionString %>" 
        SelectCommand="SELECT [PageHeader], [PageContent] FROM [PageKeeper] WHERE ([PageName] = @PageName)">
        <SelectParameters>
            <asp:QueryStringParameter DefaultValue="AboutUs" Name="PageName" 
                QueryStringField="Page" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

Code behind:

Public Sub loadContent(ByVal _PageName As String)
pageHeader.InnerText= "How do i get the value from SQLDatasource ??"
pageContent.InnerHtml="How do i get the value from SQLDatasource ??"
End Sub

Vinicius Ottoni · Accepted Answer · 2012-02-27 14:53:20Z

up vote 2 down vote accepted

Try this in your code behind:

DataView dview = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)

And after, use the DataView to access the columns, if you wanna a a list:

For Each drow As DataRow In dview.Table.Rows 
    pageHeader.InnerText= CType(drow("PageHeader"), String)
Next drow

Or single:

pageHeader.InnerText= CType(dview.Table.Rows(0)("PageHeader"), String)

edited Feb 27 '12 at 14:53

answered Feb 27 '12 at 14:42

Vinicius Ottoni
1,129729

Dim dv As DataView
            dv = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)

            pageHeader.InnerText = CType(dv.Table.Rows(0)(3), String)
            pageContent.InnerHtml = CType(dv.Table.Rows(0)(4), String)

This is what m trying now with your suggestion...but i get there is no row at position 0 – user1150440 Feb 27 '12 at 14:47

You try putting the select arguments? – Vinicius Ottoni Feb 27 '12 at 14:51

1

Your second option worked :) Thanks a ton mate. – user1150440 Feb 27 '12 at 14:54

1

You're welcome! So, anytime! =) – Vinicius Ottoni Feb 27 '12 at 14:55

add comment (requires an account with 50 reputation)

Brian Mains · Answer 2 · 2012-02-27 14:39:02Z

up vote 3 down vote

You have to manually invoke the Select method: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select.aspx

answered Feb 27 '12 at 14:39

Brian Mains
26.7k1247113

	`Dim dv As DataView dv = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView) pageHeader.InnerText = CType(dv.Table.Rows(0)(3), String) pageContent.InnerHtml = CType(dv.Table.Rows(0)(4), String)` This is what m trying now with your suggestion...but i get there is no row at position 0 – user1150440 Feb 27 '12 at 14:46
	Is the page name being properly applied? Seems like it may be missing a value, which is causing no results to be returned. – Brian Mains Feb 27 '12 at 14:56
	I used Vinicius Ottoni's snippet :) Thanks for you time. – user1150440 Feb 27 '12 at 15:00

add comment (requires an account with 50 reputation)

Carl · Answer 3 · 2012-09-06 10:16:34Z

up vote -1 down vote

You can handle the Selected event:

<asp:SqlDataSource OnSelected="usersData_Selected" />

Then in code behind:

protected void usersData_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
    string pageHeader = e.ReturnValue[0].PageHeader;
}

edited Sep 6 '12 at 10:16

answered Feb 27 '12 at 14:47

Carl
82527

add comment (requires an account with 50 reputation)

asked	1 year ago
viewed	8038 times
active	10 months ago

Using values from SqlDataSource in code behind

3 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged asp.net vb.net or ask your own question.

Using values from SqlDataSource in code behind

3 Answers

Your Answer

Sign up or log in

Post as a guest

Not the answer you're looking for? Browse other questions tagged asp.net vb.net or ask your own question.

Related