Getting blank rows after setting DataGridView.DataSource. How to solve this problem?

Question

Hello,

Could somebody tell me why I'm getting blank rows after runnign this code??

...
dataGridView.AutoGenerateColumns = false; //must be false, else getting additional coulumns from sql.
dataGridView.DataSource = dataSet.Tables[0].DefaultView;

Also tried

dataGridView.Update();

but not working.

Row count is ok, but why blank rows? How could I solve this?

P.S.: I'm using win forms.

Best Regards.

Answer 1

Also, if you are using AutoGenerateColumns= false, make sure you have added some bound columns, or you will get a blank row for each record

Answer 2

Try something along these lines:

grid.AutoGenerateColumns = false;

DataGridViewColumn col = new DataGridViewTextBoxColumn();
col.DataPropertyName = "Prop1";
col.HeaderText = "Property 1";
grid.Columns.Add(col);

col = new DataGridViewTextBoxColumn();
col.DataPropertyName = "Prop2";
col.HeaderText = "Property 2";
grid.Columns.Add(col);

grid.DataSource = dataSet.Tables[0].DefaultView;

Prop1 & Prop2 should match your table's column names. Property 1 & Property 2 is the header text to be displayed.

EDIT:

From the example you gave it looks like you're combining bound columns with unbound columns.

Do this:

1.Remove any columns added using the designer 2.Add this code:

grid.AutoGenerateColumns = false;

DataGridViewColumn colID = new DataGridViewTextBoxColumn();
colID.DataPropertyName = "customerID";
colID.HeaderText = "Ident.";
grid.Columns.Add(colID);

DataGridViewColumn colName = new DataGridViewTextBoxColumn();
colName.DataPropertyName = "customerFirstName";
colName.HeaderText = "First name";
grid.Columns.Add(colName);    
grid.DataSource = dataSet.Tables[0].DefaultView;

HTH.

Answer 3

Ok a more extended sample:

I made in the designer some columns:

column names: customerID and customerFirstName

column headerText: Ident. and First name

then I get some data from sql table...

sql = "select customerID, customerFirstName From customer;";

dataGridView.AutoGenerateColumns = false;
dataGridView.DataSource = dataSet.Tables[0].DefaultView;

and the sql table columns are the same like column names in dataGridView.

The result I get when dataGridView.AutoGenerateColumns = false; is a two column dataGridView with headerText Ident. | First name.

When I set dataGridView.AutoGenerateColumns = true; then I get dataGridView columns like this: Ident. | First name | customerID | customerFirstName.

all rows below Ident and First name are empty and all other below customerID and customerFirstName are ok.

Now I want that the rows below customerID and customerFirstName would be under Ident and First name and columns customerID and customerFirstName should be hidden.

I wrote this code and it works:

 DataTable dTable = dataGridView.GetTable().Tables[0];

 foreach (DataRow dataRow in dataGridView.GetTable().Tables[0].Rows)
 {
    int n = dataGridView.Rows.Add();
    foreach (DataColumn dataColumn in dTable.Columns)
    {
       dataGridView.Rows[n].Cells[dataColumn.ColumnName].Value = dataRow[dataColumn.ColumnName].ToString();
    }
 }

But why DataGridView dosen't do this for me with this code:

dataGridView.DataSource = dataSet.Tables[0].DefaultView;

Answer 4

What is contained in your DataSet?

Maybe the DataTable contained in your DataSet does not have any rows. I would leave AutoGenerateColumns to true and just manually hide what columns you don't want to see. I have never used AutoGenerateColumns = false. However, without more code, it is going to be hard to diagnose. Try swapping those two statements (.DataSource first).

AutoGenerateColumns may have no effect on the corresponding binding source (DataTable from DataSet).

DataSet needs to be filled by DataAdapter:

// Example
DataAdapter = new SqlDataAdapter();
DataAdapter = CreateInventoryAdapter();
DataAdapter.TableMappings.Add("Table", "GARAGE");

DataAdapter.Fill(myDataSet);
myDataView = myDataSet.Tables[0].DefaultView;
dataGridView1.DataSource = myDataView

Answer 5

Finally I found the problem!

I designed columns in the VS datagridview designer. Not the column name, but the column DataPropertyName must match with fields in database!!

Then also duplicated columns will hide.

Thanks to all.

regards.