cannot display sql data inside gridview

Question

I am trying the following in order to display the sql table data inside a gridview

try
    {
        SqlConnection xconn = new SqlConnection();
        xconn.ConnectionString = @"Data Source=servername;Integrated Security=True;Initial Catalog=master";
        xconn.Open();

        string s = "select * from tablename";
        SqlCommand ycmd = new SqlCommand(s,xconn);
        SqlDataReader dr = ycmd.ExecuteReader();

        gridview.DataSource = dr;
        gridview.DataBind();
    }
    catch (Exception)
    {
        lblresult.Text = "Cannot connect to SQL";
    }

I keep getting an exception. What am i doing wrong?

What line is throwing the exception, and what is the exception? — ToddBFisher
– ToddBFisher, Commented Nov 3, 2011 at 4:02
@Brettski - you can bind to a DataReader(). There's an example (similar to this code) on this page: support.microsoft.com/kb/307860 Search for ExecuteReader() - it's about halfway down. — David
– David, Commented Nov 3, 2011 at 4:05
I see [Initial Catalog=master] in your connection string. Is your table in the system [master] database? Just confirming. When you trace, does the exception get thrown at the line .Open() or further below? — John Gathogo
– John Gathogo, Commented Nov 3, 2011 at 5:58

Josh · Accepted Answer · 2011-11-03 21:18:05Z

1

change the Catch section with

catch (Exception ex)
{
    lblresult.Text = ex.Message &"\n" & ex.StackTrace;
}

Now you will get a valid exception description. use that to fix it yourself... :)

If not, post the detailed exception information from the lblresult.Text in your post.

edited Nov 3, 2011 at 21:18

Josh

11.1k11 gold badges67 silver badges112 bronze badges

answered Nov 3, 2011 at 11:39

Riju

5767 silver badges20 bronze badges

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

Comments

Kimbo · Accepted Answer · 2011-11-03 10:55:59Z

0

You must fill the request result in a varible which you can use as itemsource.

GridView.ItemsSource = ContainerClass.AllItems;

The ContainerClass is a help class and contains a IEnumerable AllItems variable. The gridview can show the values on this way!!

answered Nov 3, 2011 at 10:55

Kimbo

1,3983 gold badges9 silver badges12 bronze badges

Collectives™ on Stack Overflow

cannot display sql data inside gridview

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related