How to Iterate the specific DataGrid column and save in Database,.

[jebin k]

Hi, I have a datagrid with 13 columns(like event, venue etc),The column names are defined in list box. The values selected in the list box should only be saved in database table. Can any one help me how to iterate the specific columns only. Thanks in Advance.:)

[Basheer mohideen]

For Each dbGridItem As DataGridItem In Me.dgGrid.Items dim sTemp as strin sTemp = dbGridItem.Cells(1).Text.Trim.ToString 'Column index where u stored events,venus.. select case Ucase(sTemp) case "EVENTS" 'do the process case "VENUS" 'do the process end select Exit For Next the above is the code you can use to iterate thru data grid

Bash-Tsh

[John ph]

you can write something like this to iterate through the items of DataGrid

Dim Griditem As DataGridItem
For Each GridItem In Datagrid.Items
  value = GridItem.cells(ColumnIndex).Text
Next

Regards
 - J O N -

---