Populate Datagridview with random Data

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;
      }

Thanks Sam :-)
 
Anthony

Hoping you are querying it form database.

random rows sql server

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

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

Thanks.....