I got a gridview in which i selected a row by clicking anywhere on the row and now i am trying to get a cell value of the selected row into a datatable.
I am getting an error saying " Input string was not in a correct format. " at the point given below (at ---->)
Private Sub CreateSelectionAsSessionTa
ble()
Dim dt As New DataTable
Dim drow As DataRow
dt.Columns.Add(New DataColumn("PremiseId", GetType(Integer)))
dt.Columns.Add(New DataColumn("CustomerId", GetType(Integer)))
dt.Columns.Add(New DataColumn("Addressline1",
GetType(String)))
dt.Columns.Add(New DataColumn("Name1", GetType(String)))
dt.Columns.Add(New DataColumn("HomePhoneNumbe
r", GetType(String)))
dt.Columns.Add(New DataColumn("WorkPhoneNumbe
r", GetType(String)))
drow = dt.NewRow()
Dim i As Integer = gvSelectAddress.SelectedIn
dex
If i = -1 Then i = 1
-----> drow("PremiseId") = CType(gvSelectAddress.Sele
ctedRow.Ce
lls(2).Tex
t, Integer)
drow("addressline1") = gvSelectAddress.Rows(i).Ce
lls(7).Tex
t
drow("name1") = gvSelectAddress.Rows(i).Ce
lls(8).Tex
t
drow("HomePhoneNumber") = gvSelectAddress.Rows(i).Ce
lls(9).Tex
t
drow("WorkPhoneNumber") = gvSelectAddress.Rows(i).Ce
lls(10).Te
xt
dt.Rows.Add(drow)
Sessions.SelectedDataTable
= dt
End Sub
Can anyone help me with this
Start Free Trial