Public constring As String = AlgoMdConnectionString
Try
Using con As New SqlConnection(constring)
Using cmd As New SqlCommand("SELECT
TAP_BillDate AS [Bill Date],
'False' AS [isClosed],
TAP_Payable AS [Balance],
'' AS [Payment]
from Tbl_AccPending
", con)
cmd.CommandType = CommandType.Text
Using sda As New SqlDataAdapter(cmd)
Using ds As New DataSet()
sda.Fill(ds)
SfDataGrid1.DataSource = ds.Tables(0)
'SfDataGrid1.Columns.Add(New GridCheckBoxColumn() With {.MappingName = "isClosed", .HeaderText = "isClosed", .CheckBoxSize = New Size(15, 15), .TrueValue = "True", .FalseValue = "False"})
End Using
End Using
End Using
End Using
Catch ex As Exception
IO.File.AppendAllText(appDataPath & "\Log.txt", String.Format("{0}{1}", Environment.NewLine, ex.ToString()))
End Try
on the above SQL Commands i have to modify 'isClosed' column as CheckBoxColumn .. i try SfDataGrid1.Columns.Add(New GridCheckBoxColumn() , but it creating new checkbox column at the end of all columns.. But i needs to modify the existing column loads from dataset at its same position.. if u have any other way to solve this, please let me know..
--regards
Sulthan