Need to get rid of datagridview grey space

Shawn

I am developing a winform application in C# that connects to a mySQL database. It queries the DB returning to a datatable. Once the data is retrieved, it is put into a datagridview. My issue is the width of the datagridview is such that the columns do not fill it completely leaving grey space to the right of the the columns. Also, I would like to remove the grey space below the rows and fill with empty rows. I have googled and searched here but can't seem to find the answer to my issues. Any help would be appreciated. I can think of some crude ways to solve the problems, but I think there must be something more simple.

Thanks

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ehtesham14y ago
Accepted answer
There is no option as such for vertical, You can do a trick remove the border style of cells set the backcolor of datagridview to form backcolor/container backcolor
0
karthik tirupathi12y ago
Hi Shawn,

For me, your question seems like,you want to auto fill your datagridview with the rows and columns that you have.

Well, you can fill your datagridview according to number of columns by using below procedure...
1) Select your datagridview and go to properties window.
2) Change the AutoSizeColumnsMode to Fill.

For removing grey color below row of datagridview, we do not have inbuilt property...but we can fill the datagridview with empty rows by writing the following code in the Form_Load event for the form containing the datagridview.

private void Form1_Load(object sender, EventArgs e)
{
for (int j = 0; j < 6; j++)
{
int a = dataGridView1.ColumnCount;
string[] row = new string[15];
for (int i = 0; i < a; i++)
{
row[i] = "";
}
dataGridView1.Rows.Add(row);
}
}
you can increase the condition imposed on j to the number you want, till your datagridview is filled with empty rows and grey color below rows is not observed.
0
Ehtesham14y ago
welcome Shawn
0
Shawn14y ago
Ehtesham, thanks again. I somewhat used your advice on the "vertical row" problem. I am using alternating cell colors so it was a little bit different. However, I did remove the borders like you suggested and then set the background color to the color of my darkest shade. It looks great now. I think I like it better than filling with empty rows. I want to thank you again for your help. Always nice to have support when I get frustrated with things that should be so simple. I tip my hat.

I still need to finalize my column widths so that it fills the dataGridView width. But, I'm on the right track and can make it happen. Thanks again and have a good day.
0
Shawn14y ago
I finally determined the problem with filling the datagrid. I had put this line of code during the process of loading the datagridview:

this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;

it was overriding the property set and the line of code I was putting in the constructor / load method (simply because it occurred last.) So now I have the problem so that if I remove the above line of code, the data is cutoff. Alternatively, the datagridview is not completely filled. So now I suspect I will need to stretch the column widths until the datagridview is filled. I was hoping to get around such a crude approach, but I don't see an option.

I suppose if it were easy we wouldn't have a job though right?

Anyway, I am still searching for a way to fill the datagridview vertically with empty rows without changing the row height.

Thanks again Ehtesham for your help.
0
Shawn14y ago
As for the ...AutoSizeColumnsMode.Fill, that is a property which I have set to fill. It is not filling as I would expect. I may have changed another property causing the lack of response. I did try putting the line of code directly after the loading of the the dataGridView, but still didn't work.

As for the rows, it looks like that code would cause dynamic height of the rows depending on the number of rows. I would really like to keep the same row height, but fill in with blank rows for a more aesthetically pleasing look.

I really appreciate your response.
0
Ehtesham14y ago
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

For rows Fill is not available however you can use the below code

//use this code before binding
dataGridView1.RowTemplate.Height = this.dataGridView1.Height / TotalRows;

Where TotalRows is total number of rows which will be binded or added to datagridview
0