enter image description herecmd = New SqlCommand(select sno,Item,Qty,Description,Source from tblname, con)
cmd.CommandType = CommandType.Text
Dim sda As New SqlDataAdapter(cmd)
Dim dss As New DataSet()
sda.Fill(dss) gvInsuredData.DataSource = dss
Dim AytC As Keyoti.RapidSpell.Grid.AYTDataGridViewTextBoxColumn = New Keyoti.RapidSpell.Grid.AYTDataGridViewTextBoxColumn()
AytC.HeaderText = "DescriptionProperty"
AytC.Name = "Description"
AytC.DataPropertyName = "personalPropertyDescription"
DataGridView1.Columns(0).DataPropertyName = "personalPropertyDescription"
DataGridView1.DataSource = dss.Tables(0)
Dim AytCtb As Keyoti.RapidSpell.Grid.AYTDataGridViewTextBoxColumn = New Keyoti.RapidSpell.Grid.AYTDataGridViewTextBoxColumn()
AytCtb.HeaderText = "SourceProperty"
AytCtb.Name = "Source"
AytCtb.DataPropertyName = "personalPropertySource"
DataGridView1.Columns(1).DataPropertyName = "personalPropertySource"
DataGridView1.DataSource = dss.Tables(0)
Dim dtt As New DataTable()
DataGridView1.Columns("DescriptionProperty").DataPropertyName="personalPropertyDescription"
DataGridView1.Columns("SourceProperty").DataPropertyName = "personalPropertySource"
DataGridView1.DataSource = dss.Tables(0)