Populate Datagridview with random Data

Question

Hi I want to populate a datagrid view with quite a bit of random data but dont want to have to keep using datagridview.columns.add(etc) datagridview.rows.add(etc) a few hundread times and was wondering whether there is a quick method for this. Thank you for your time Regards Anthony

Sam Hobbs · Answer

So you want to generate random numbers or random values? It is my understanding that you don't have existing data thay you need to randomize ; you need to generate random data. If that is correct then just search MSDN as in: http://social.msdn.microsoft.com/Search/en-US?query=random&ac=8 There you will find the Random Class. Does that help?

Crish · Answer

Hi You can refer following code. private void pictureBox1_Click(object sender EventArgs e) { string query=null; query = select * from Studies; SqlCeDataAdapter adp = new SqlCeDataAdapter(query Data Source=Dicom.sdf;Persist Security Info=False;); DataTable dt = new DataTable(); dt.Locale = System.Globalization.CultureInfo.InvariantCulture; adp.Fill(dt); StudiesbindingSource.DataSource = dt; dataGridViewStudies.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);// Resize the DataGridView columns to fit the newly loaded content. dataGridViewStudies.ReadOnly = true; // finally bind the data to the grid dataGridViewStudies.DataSource = StudiesbindingSource; dataGridViewStudies.Visible = true; }

Anthony Clarke · Answer

Thanks Sam :-) Anthony

Suthish Nair · Answer

Hoping you are querying it form database. random rows sql server

Anthony Clarke · Answer

Hi again Subhendu Thanks for your response. I know how to bind the datasource to the datagridview but how to i randomize the datasource. I just want to populate a grid e.g. Columns A B C D E with 100 rows which are all random numbers. Im just not sure how to tackle this. Thanks Subhendu Regards Anthony

Subhendu De · Answer

Dont add columns or rows... Update datasource randomly and bind the datagridview with the datasource. Thanks.....