Need to get rid of datagridview grey space

Question

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

Ehtesham · 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

Ehtesham · Answer

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

Ehtesham · Answer

welcome Shawn

Shawn · Answer

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.

Shawn · Answer

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.

Shawn · Answer

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.

karthik tirupathi · Answer

Hi Shawn For me your question seems likeyou 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 { int a = dataGridView1.ColumnCount; string[] row = new string[15]; for (int i = 0; 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.