Hi

i am new to dot net 2005(Vb.net)Windows Application

how to add DataGridViewCheckBoxColumn in this sample code

i am fetching Status column from database and in this field i will be having YES/NO value
if YES i want to Check the checkbox column
if NO i don't want to check the checkbox column

can some one help me in this?

Thanks in advance

Dim oOracleConn As New OracleConnection("Data Source=serverName;User Id=userid;Password=password")
Dim sExecuteQuery As String
sExecuteQuery = "select CustomerName,CustomerID,Customer_address,Status from customermaster"
Dim odaAdapter As New OracleDataAdapter(sExecuteQuery, oOracleConn)

Dim tbl1 As New DataTable

Dim Col11 As New DataColumn()
Dim Col12 As New DataColumn()
Dim Col13 As New DataColumn()

Col11.DataType = System.Type.GetType("System.String")
Col11.ColumnName = "CustomerName"
Col11.Caption = "CustomerName"
Col11.ReadOnly = False
tbl1.Columns.Add(Col11)

Col12.DataType = System.Type.GetType("System.String")
Col12.ColumnName = "CustomerID"
Col12.Caption = "CustomerID"
Col12.ReadOnly = False
tbl1.Columns.Add(Col12)

Col13.DataType = System.Type.GetType("System.String")
Col13.ColumnName = "Customer_address"
Col13.Caption = "Customer_address"
Col13.ReadOnly = False
tbl1.Columns.Add(Col13)

---
Check box column here.

????

--

odaAdapter.Fill(tbl1)
DataGridView1.DataSource = tbl1

---

Naren

Take a look the datagridviewcheckboxcolumn's truevalue and falsevalue.