Hi everyone,

Hope you can help...

Heres my situation. I fairly new to ASP.NET with Databases, and I am working through the Wrox book at the moment while creating a fairly simple web application for work.

So far I have a datagrid populated from SQL containing a LOT of user information. Infact, far too much. There are too many fields, but the users require them all.

What I want to do is generate checkboxes from each field in the table and bind them to the datagrid so that users can turn off/on the columns they dont want to see.

So, I just want to know how I can bind a CheckboxList to the Datagrid HeaderText...

If someone can answer this, I will be wrapped! Becuase this is the only thing holding me back so far. :)

Regards,
Euan

Well, I have got something fairly dodgy together now if anyone else is interested.

Its the best I could come up with, and please ... I am a total beginner so dont tell me my code is crap :)

So far it has worked ok. But if anyone has suggestions for optimising the code, or something simpler I would GREATLY appreciate it!

Regards,
Euan

********SNIP**************

Sub Page_Load(Source As Object, E As EventArgs)

    Dim StrConnection As String = ConfigurationSettings.AppSettings("CurrentClients" )
    Dim ClientsConn As SqlConnection = New SqlConnection(StrConnection)
    Dim schemaDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='CURRENT_CLIENTS'", ClientsConn)
    Dim ClientsDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM CURRENT_CLIENTS", ClientsConn)
    Dim schemaTable As DataTable = New DataTable
    Dim ClientsTable As DataTable = New DataTable
    ClientsDA.Fill(ClientsTable)
    schemaDA.Fill(schemaTable)
    dgClients.datasource = ClientsTable
    dgSchema.datasource = SchemaTable
    dgSchema.databind()
    dgClients.databind()

    ckbEmployees.datasource = schemaTable
    ckbEmployees.DataTextField = "COLUMN_NAME"
    ckbEmployees.DataValueField = "COLUMN_NAME"
    ckbEmployees.Databind()


    ClientsConn.close()


End Sub

************SNIP****************

You might be able to optimize this by binding directly to the DataTable's Columns collection. Then you wouldn't need to make a secondary query to the schema of the database.

(Might I add that for a "beginner", as you claim to be, that's not bad code at all. Figuring out the schema stuff is pretty good!)