SQL ExecuteReader() Error - VB.Net

Asked Apr 15 '14 at 15:54

Active Apr 15 '14 at 16:23

Viewed 374 times

So I'm trying to read and display all entrys from the MDB file with the status as 2 and I keep getting this error:

An exception of type 'System.Data.OleDb.OleDbException' occurred in Microsoft.VisualBasic.dll but was not handled in user code

When I take out the Where status = 2 it works fine but I need the where in there.

<script runat="server">
sub Page_Load
        Dim dataconnector, strSQL, datacommand, dataread
        dataconnector = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("cgiclass.mdb"))
        strSQL = "SELECT * FROM suppliers WHERE status = 2"
        dataconnector.Open()
        datacommand = New OleDbCommand(strSQL, dataconnector)
        dataread = datacommand.ExecuteReader()
        suppliers.DataSource = dataread
        suppliers.DataBind()
        dataread.Close()
        dataconnector.Close()
    End Sub
</script>

edited Apr 15 '14 at 16:23

marc_s

732,580
175
1,330
1,459

asked Apr 15 '14 at 15:54

the1osu

1

What is the data type of `suppliers.status`? – Dour High Arch Apr 15 '14 at 15:57
Maybe status is a string and not a number. If this is the case, use `... WHERE status = '2'` – Arman Apr 15 '14 at 15:57
Add a `Try/Catch` and see what the exception is: http://msdn.microsoft.com/en-us/library/fk6t46tz.aspx – mafafu Apr 15 '14 at 15:58
@Arman I feel stupid now haha. Thanks a lot man that got it to work. – the1osu Apr 15 '14 at 16:03

SQL ExecuteReader() Error - VB.Net

0 Answers0