Dynamically Populate a DataGridView 1

[LonnieJohnson]

I am using VS 2005 and on a Windows Form I want to put a data grid. I will not know the columns of the grid until runtime. I have successfully created a means to get the fields and even create my columns on the fly. They are appearing on my grid just fine.

How do I poplate the grid itself with rows if I do not know what columns will be until the user picks them?

Thanks in advace to the Guru that can bail me out.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[zarkon4]

Where is the data that the user picks coming from?

If it is coming from a database then you could bind the grid to your dataset and you will get both Headings and data.

 

[LonnieJohnson]

Hmmmm. Sounds like what I want.

I have a list box with possible fields. They pick the fields they want to see. I take those fields and build an SQL string. I use that SQL in a data reader that gets the info from a SQL Server database.

Can I bind the data reader directly to the grid? That would be the cat's meow!!!

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[zarkon4]

Don't use the data reader, use a dataset and bind the grid to it.

Such as follows:


Dim MyDataSet As New Data.DataSet
DataGrid1.DataSource = Nothing
DataGrid1.Refresh()
dim strSql as string="SELECT * FROM Customers")

Using MyConnection As New SqlConnection(Connstring)
myConnection.open
Using myDataAdapter As New SqlDataAdapter(strsql, MyConnection) '

myDataAdapter.Fill(MyDataSet, "Customers")
DataGrid1.DataSource = MyDataSet.Tables("Customers")

End Using
myConnection.close
End Using

 

[LonnieJohnson]

They have got to change this so we can give more than one star. I knew there was a way but didn't know how.

Muchos gracias!!!

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!