Data grid view display problem in C# .Net with Access Data base

Question

0.00/5 (No votes)

See more:

Hi I m using C# .net with Access DB.I m trying to retrieve data from DB to Data grid view to display data but it is showing only 1st and 2nd column remaining are not showing data but in dataset it is there ,can any one help please?

Below I give code

private void grid()
       {
           dgv.Columns.Clear();
           DataGridViewTextBoxColumn dgvCol = new DataGridViewTextBoxColumn();
           string str;
           str = "SELECT * FROM excess";
           OdbcCommand cmd = new OdbcCommand(str,con);
           OdbcDataAdapter da = new OdbcDataAdapter();
           DataSet ds = new DataSet();
           da.SelectCommand = cmd;
           da.Fill(ds, "ExcessGView");

           if (ds.Tables["ExcessGView"].Rows.Count > 0)
           {
               foreach (DataRow dr in ds.Tables["ExcessGView"].Rows)
               {
                   for (int i = 0; i < ds.Tables["ExcessGView"].Columns.Count; i++)
                   {
                       dgvCol = new DataGridViewTextBoxColumn();
                       dgvCol.Width = 150;
                       dgvCol.ReadOnly = true;
                       dgvCol.SortMode = DataGridViewColumnSortMode.Programmatic;
                       dgvCol.HeaderText = ds.Tables["ExcessGView"].Columns[i].ColumnName.ToUpper();
                       dgv.Columns.Add(dgvCol);
                   }
                  break;
               }

               int r = 0;
               dgv.RowCount = ds.Tables["ExcessGView"].Rows.Count;

               foreach (DataRow dr in ds.Tables["ExcessGView"].Rows)
               {
                   for (int i = 0; i < ds.Tables["ExcessGView"].Rows.Count; i++)
                   {
                       try
                       {
                           dgv.Rows[r].Cells[i].Value = dr[i].ToString();
                       }
                       catch (Exception ex)
                       {
                           con.Close();
                           MessageBox.Show(ex.Message);
                       }
                   }
                   r = r + 1;
               }

           }

           else
           {
               con.Close();
           }

       }

Thanks & regards
Indrajit

[Edited]Code is blocked in "pre" tags[/Edited]

Posted 3-May-11 19:03pm

IndrajitDasgupat

Updated 3-May-11 19:06pm

RaviRanjanKr

v2

Add a Solution

2 solutions

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)

Ankit Rajput · Answer 1 · 2011-05-03T19:07:00

Solution 1

Hi,

Use this simple syntax to show the data

dgv.DataSource=ds.Tables["ExcessGView"];

instead of these loops.
Try it.

Regards
AR

Posted 3-May-11 19:07pm

Ankit Rajput

Updated 3-May-11 19:09pm

v2

Comments

IndrajitDasgupat 4-May-11 2:01am

Thanks it is working

IndrajitDasgupat 4-May-11 2:12am

how I can make the size of every column of data grid view according to user, please help

Ankit Rajput 4-May-11 2:22am

set this property of grid
AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;

IndrajitDasgupat 4-May-11 2:36am

Yes I had done like below
//the DataGridView
DataGridView dgv = new DataGridView();
dgv.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;

dgv.Columns("excess").Width = 270;
dgv.Columns("excess").DisplayIndex = 1;
dgv.Columns("excess").ReadOnly = True;
dgv.Columns("excess").HeaderText = "Excess";
but in column it is showing error that it is looks like method
what should i do?
please help!

Ankit Rajput 4-May-11 2:45am

You have used like
dgv.Columns("excess").Width = 270;

but use it like
dgv.Columns["excess"].Width = 270;

Means use '[]' in place of '()' when accessing columns.

Ankit Rajput 4-May-11 2:49am

by the way, If you are setting width like this. Then you don't need to use AutoSizeColumnsmode.

IndrajitDasgupat 4-May-11 3:02am

now it is showing error----
//the DataGridView
DataGridView dgv = new DataGridView();

dgv.Columns["excess"].Width = 270;
"Object reference not set to an instance of an object."

Ankit Rajput 4-May-11 3:16am

Does column excess exist in the dgv.

If possible please provide your code which you implemented now.

IndrajitDasgupat 4-May-11 3:20am

here I give the code Please check
private void grid()
{
//AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;
//the DataGridView
DataGridView dgv = new DataGridView();

dgv.Columns.Clear();
DataGridViewTextBoxColumn dgvCol = new DataGridViewTextBoxColumn();
string str;
str = "SELECT * FROM excess";
OdbcCommand cmd = new OdbcCommand(str,con);
OdbcDataAdapter da = new OdbcDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(ds, "ExcessGView");

dgv.Columns["excess"].Width = 270;

//set the DataGridView DataSource
dgv.DataSource = ds.Tables["ExcessGView"];

}

Ankit Rajput 4-May-11 3:28am

change the sequence of these two statements

dgv.DataSource = ds.Tables["ExcessGView"];

dgv.Columns["excess"].Width = 270;

Ankit Rajput 4-May-11 3:28am

First fill the grid.Then use its columns.

IndrajitDasgupat 4-May-11 3:35am

Thank U it is working now.
I m new in this field how can I learn all this can u please suggest me if u don't mind

Ankit Rajput 4-May-11 3:39am

The best way to read about microsoft technologies is MSDN.
Else you can search the things on google. You will get a plenty of links to read about it.
Bu the way, if you got your answer. Then accept this answer.

abdul manan 7 14-Feb-14 14:54pm

Although the answer is not accepted as answer but thank you Ankit Sir i learn many things from you and now many things clear to me...

Sandeep Mewara · Answer 2 · 2011-05-03T19:11:00

Solution 2

Just do two things:
1. Keep AutoGenerateColumns = true for the datagrid
2. Use Datagrids DataSource property and then bind it, like:

mydg.Datasource = ds.Tables["mytable"];
mydg.Databind();

Posted 3-May-11 19:11pm

Sandeep Mewara

Comments

Ankit Rajput 4-May-11 1:12am

I think, we need to call DataBind function in case of web application only. Am i right?

Sandeep Mewara 4-May-11 1:25am

Right you are!

My bad, I am more of ASP.NET guy and to me by default it looked like a webquestion. Since it is not mentioned if it is a web or winforms, I am at a little loss/advantage. :)

Ankit Rajput 4-May-11 2:17am

Actually its my confusion thats why i asked.

Sandeep Mewara 4-May-11 2:21am

No, you were right. For winforms, we don't need Databind() as we do in ASP.NET.

Ankit Rajput 4-May-11 2:23am

Thanks, For make it clear.