Part2 Getting to display the table thanks to Wayne for the answer to part1

Question

0.00/5 (No votes)

See more:

Special thanks to
Now what I want to do is display the table in the database, this is what I have tried:

C++

int DisplayTable()
        {
            using (SqlConnection myConnection2 = new SqlConnection(DBConn))
           {
              SqlCommand MyCommand2 = new SqlCommand("SELECT * from TheTableName;", myConnection2);
              myConnection2.Open();
              SqlDataReader reader = MyCommand2.ExecuteReader();

           GridView1.DataSource  = reader;
           GridView1.DataBind();

           return MyCommand2.ExecuteNonQuery();
           }
      }

Then put in the button like I did before:

C#

protected void btnDisplay_Click(object sender, EventArgs e)
        {
            DisplayTable();

        }

MSIL

but this does not work and gives the error:

"Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition."

What should I do?

Special thanks to Wayne Gaylard for the answer to my first question, if you are still out there please help.

Thanks in advance...

Posted 2-Jul-11 10:37am

censurl

Add a Solution

2 solutions

Solution 2

This line on my .aspx page was put there automatically "DataSourceID="SqlDataSource1" Which is what I deleted.

Then I got an error about the reader that was still opened...

I got it work as follows:

C++

int DisplayTable()
        {
            using (SqlConnection myConnection2 = new SqlConnection(DBConn))
           {
              SqlCommand MyCommand2 = new SqlCommand("SELECT * from TheTableName;", myConnection2);
              myConnection2.Open();
              SqlDataReader reader = MyCommand2.ExecuteReader();
           GridView1.DataSource  = reader;
           GridView1.DataBind();
           reader.Close();
           return MyCommand2.ExecuteNonQuery();
           }
      }

As a student who has only just started programming, I would like to thank everyone who has given me such good answers that apply to my questions, if only there was a way I could let them know how gratefull I am.

Posted 3-Jul-11 0:02am

censurl

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-07-02T20:23:00

Solution 1

The answer is in the error:

"Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition."

Remove one definition. At a guess, check your Gridview definition, and take out the DataSourceID assignment, since you are setting the DataSource in the code.

Posted 2-Jul-11 20:23pm

OriginalGriff