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

5

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, 2012 at 14:53

answered Feb 27, 2012 at 14:42

Vinicius Ottoni

4,6979 gold badges45 silver badges64 bronze badges

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

3 Comments

user1150440 Over a year ago

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

Vinicius Ottoni Over a year ago

You try putting the select arguments?

Ross Brasseaux Over a year ago

Doesn't using "select" make a second call to SQL?

user2640130 · Accepted Answer · 2014-04-27 13:57:48Z

2

If you want that in C#, here's the code

First Don't forget

using System.Data;

Then In Event Code :

    DataView dview = (DataView) sdsBookInfo.Select(DataSourceSelectArguments.Empty);
    string value = (String)dview.Table.Rows[0]["YourColumnName"];

answered Apr 27, 2014 at 13:57

user2640130

Comments

Eduardo Cuomo · Accepted Answer · 2013-12-30 19:38:01Z

0

I used the following:

DataView dv = (DataView)GetDataSource().Select(DataSourceSelectArguments.Empty);

foreach (DataRow row in dv.Table.Rows)
{
    long id = Convert.ToInt64(row[0]);
    string name = row[1].toString();
    // ...
}

answered Dec 30, 2013 at 19:38

Eduardo Cuomo

19.2k7 gold badges121 silver badges98 bronze badges

Collectives™ on Stack Overflow

Using values from SqlDataSource in code behind

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related