VB.NET

VB.NET RSS

Checkbox in DataGridView

Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Dec 2007

Posts: 252

Reputation: ProfessorPC is an unknown quantity at this point

Solved Threads: 27

ProfessorPC ProfessorPC is offline

Offline

Posting Whiz in Training

Checkbox in DataGridView

Dec 29th, 2007

Hello,
I am having an issue trying to add a checkbox field to my DataGrid. I have the following Code but it does not display my checkbox. Any help is greatly appreciated.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
        Dim myconnection1 As New SqlConnection(myconn)
        Dim dtcCheck As New DataColumn("Select")
        dtcCheck.DataType = System.Type.GetType("System.Boolean")
        dtcCheck.DefaultValue = False
        Dim sa As New SqlDataAdapter("SELECT * FROM therapy", myconnection1)
        sa.Fill(ds, "Therapy")
        DataGridView1.DataSource = ds.Tables("Therapy")
        ds.Tables.Add.Columns.Add(dtcCheck)
        Dim myconnection1 As New SqlConnection(myconn)
        Dim dtcCheck As New DataColumn("Select")
        dtcCheck.DataType = System.Type.GetType("System.Boolean")
        dtcCheck.DefaultValue = False
        Dim sa As New SqlDataAdapter("SELECT * FROM therapy", myconnection1)
        sa.Fill(ds, "Therapy")
        DataGridView1.DataSource = ds.Tables("Therapy")
        ds.Tables.Add.Columns.Add(dtcCheck)

Thank You

Last edited by ProfessorPC; Dec 29th, 2007 at 12:04 am.

•

Join Date: Oct 2006

Posts: 169

Reputation: ptaylor965 is an unknown quantity at this point

Solved Threads: 19

ptaylor965 ptaylor965 is offline

Offline

Junior Poster

Re: Checkbox in DataGridView

Dec 29th, 2007

I used this code to create a table with each month as a checkbox

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
        Dim chkBox As System.Type = System.Type.GetType("System.Boolean")
        With dtYear.Columns
            .Add("Jan", chkBox)
            .Add("Feb", chkBox)
            .Add("Mar", chkBox)
            .Add("Apr", chkBox)
            .Add("May", chkBox)
            .Add("Jun", chkBox)
            .Add("Jul", chkBox)
            .Add("Aug", chkBox)
            .Add("Sep", chkBox)
            .Add("Oct", chkBox)
            .Add("Nov", chkBox)
            .Add("Dec", chkBox)
        End With
        Dim chkBox As System.Type = System.Type.GetType("System.Boolean")
        With dtYear.Columns
            .Add("Jan", chkBox)
            .Add("Feb", chkBox)
            .Add("Mar", chkBox)
            .Add("Apr", chkBox)
            .Add("May", chkBox)
            .Add("Jun", chkBox)
            .Add("Jul", chkBox)
            .Add("Aug", chkBox)
            .Add("Sep", chkBox)
            .Add("Oct", chkBox)
            .Add("Nov", chkBox)
            .Add("Dec", chkBox)
        End With