How to show data in datGridView?

Question

0.00/5 (No votes)

See more:

Dear all,
here is my code.

C#

private void btnShow_Click(object sender, EventArgs e)
        {
            SqlDataAdapter da = new SqlDataAdapter("Select * from tbl_stuInfo", cn);
            da.Fill(dt);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dataGridView1.Rows.Add(i + 1, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3]);
            }
            dt.Clear();
        }

I want to show the data to dataGridView1, but there is an error in line

dataGridView1.Rows.Add(i + 1, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3]);

I don't know why?

Please help me. Thanks

Posted 8-Mar-12 16:54pm

phanny 2011

Add a Solution

Comments

Sergey Alexandrovich Kryukov 8-Mar-12 23:29pm

What is datGridView? :-) And give us the full name. There are many similarly named controls in different libraries on .NET. Tag your application type and UI library.
--SA

1 solution

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)

Soumya Joseph · Accepted Answer · 2012-03-08T17:47:00

Solution 2

Hi Phanny,
You cannot explicitly add rows directly to the DataGridView.

You must instead add rows directy to your data source.Then refresh the DataGridView

Sample Code

C#

SqlDataAdapter da = new SqlDataAdapter("Select * from tbl_stuInfo", cn);
da.Fill(dt)
dataGridView1.DataSource = dt;

Thanks and Regards
Soumya

Posted 8-Mar-12 17:47pm

Soumya Joseph

Comments

phanny 2011 9-Mar-12 2:43am

thanks, it works. But It doesn't clear the old one. So when we click on button show, it always show the duplication data...How to do?

Thanks

Soumya Joseph 9-Mar-12 2:56am

call the clear Function

dt.Clear();

phanny 2011 9-Mar-12 3:00am

thanks so much......It works now.

Soumya Joseph 9-Mar-12 3:01am

:)