Small Problem In Reading Excel Sheet
-
Hai Friends, I have one problem withe Excel Sheet, Actually Iam uploading excel sheet , and I am storing the contents of Excel sheet in DATASET and i am reading the data from DATASET While Reading Data from DATASET,Iam unable to read the INTEGER data Even i am reading the data of Text, getting problems with INTEGER data and it is giving error is INVALID CAST ERROR and it is showing the valuse DBNull i have tried to solve it by changing the properties of Excel Sheet CEll,but could not Succeed Iam giving Code what i wrote in aspx.vb Dim TNo As String Dim ASFD As integer For i = 4 To DS.Tables(0).Columns.Count - 1 TNo = Trim(DS.Tables(0).Rows(0).Item(i)) ASFD = DS.Tables(0).Rows(6).Item(i) when i am reading the ASFD,iam getting the INVALID CAST Error