I HAVE A WEB IN ASP.NET AND CODE IN VB MY DATABASE IS ACCESS WHICH WAS CREATED INITIALLY AND OLD DATA IS ACCESSED FROM THIS ACCESS DATABASE.
THE PROBLEM IS WHEN THE FIELD IS BLANK THE FOLLOWING ERROR COMES
Conversion from type 'DBNull' to type 'String' is not valid.
MY CODE IS AS UNDER
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim PNO As String = inputtxt.Text
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\awing\AWing.mdb"
Dim con As OleDbConnection = New OleDbConnection(connectString)
con.Open()
Dim qstr As String
qstr = "select * from PersData where PNO='" + inputtxt.Text + "'"
Dim msadp As New OleDbDataAdapter(qstr, con)
Dim dt As New DataSet
dt.Clear()
msadp.Fill(dt, "PersData")
pnotxt.Text = dt.Tables("PersData").Rows(0).Item("PNO")
nametxt.Text = dt.Tables("PersData").Rows(0).Item("Name")
dobtxt.Text = dt.Tables("PersData").Rows(0).Item("DOB")
coursetxt.Text = dt.Tables("PersData").Rows(0).Item("CourseStr")
torstxt.Text = dt.Tables("PersData").Rows(0).Item("FROM")
loctxt.Text = dt.Tables("PersData").Rows(0).Item("PLACE")
End Sub
Public Function FixNull(ByVal dbvalue) As String
If dbvalue Is DBNull.Value Then
Return ""
Else
Return dbvalue.ToString
End If
End Function
End Class