Pass data from database to ASP.NET page

Question

I am working on a website which is developed in ASP.NET and backbend is C#. I am dynamically trying to pass the value from the Database to the header. I can do this for the user name by simply doing <%: Context.User.Identity.GetUserName() %> and that will return the correct user name. How would I do this for a course name?

Below is my code which reads the values from the DB

public DataTable GetCourseData()
{
    string UsrName = User.Identity.Name;
    DataSet dt = new DataSet();

    using (SqlConnection connection = new SqlConnection(Common.ConnectionString))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT CourseName FROM Course WHERE UserName=@UserName"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                SqlParameter para2 = new SqlParameter("UserName", UsrName);
                cmd.Parameters.Add(para2);
                cmd.Connection = connection;
                sda.SelectCommand = cmd;
                sda.Fill(dt);
            }
        }
    }
    return dt.Tables[0];
}

If I do <%: GetCourseData() %> it doesn't return the course.

Any help would be much appreciated!

What is the Question? GetCourseData returns a DataTable. That ToString likely returns some nice text - namely "DataTable" unless I am mistaken (type is the default ToString). Antipatterns again - try making this an object and then grab the right field. — TomTom
– TomTom, Commented Nov 11, 2014 at 11:30
So the question is: Is there anyone that can code this piece for me? — emerson.marini
– emerson.marini, Commented Nov 11, 2014 at 11:34

Moti Azu · Accepted Answer · 2014-11-11 11:38:50Z

1

The problem you have is you return a DataTable which describes a whole table with your query results. You probably want to get the data you need from it, like so:

return dt.Tables[0].Rows[0]["CourseName"];

answered Nov 11, 2014 at 11:38

Moti Azu

5,4521 gold badge25 silver badges33 bronze badges

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

1 Comment

Izzy Over a year ago

Thanks for your answer! I have completely changed my method to return a string and got it to work. However your solution is also helpful so I will accept it.

Collectives™ on Stack Overflow

Pass data from database to ASP.NET page

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related