Problem with queries. Call for help.

[johnmay1248]

I am having a problem with queries running in this code When I use the
query "SELECT * FROM sample" the code runs and the data grid binds and shows
the contents of the sample table. If I change the query to filter the
results such as "SELECT * FROM sample WHERE (sales 2000)" the code fails
on - objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection) with an unknown
error.
If I load the database up into access2000 and run the sql queries they run
as expected so I know they are valid queries of the data

I am a noob at asp.net data. Can anybody give me a hand?

The Code I am using is below followed by the error info with the stack
trace.

-----------------------------------------------------------------------------

Imports System.Data.Ole Db
Imports System.Data

Sub btnRunQuery_OnC lick(ByVal Sender As Object, ByVal E As EventArgs)
Dim objConnection As OleDbConnection
Dim objCommand As OleDbCommand
Dim objDataReader As OleDbDataReader
Dim strSQLQuery As String

objConnection = New
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0; Data Source=" &
Server.MapPath( "NewDatabase.md b") & ";")

strSQLQuery = "SELECT * FROM sample"

'strSQLQuery = "SELECT * FROM sample WHERE (sales 2000)"

'strSQLQuery = "SELECT * FROM sample WHERE key_id=5"

'strSQLQuery = "SELECT * FROM sample WHERE last_name='John son'"

objCommand = New OleDbCommand(st rSQLQuery, objConnection)

objConnection.O pen()

objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

lblSQLCommandLa bel.Text = strSQLQuery

EmployeeDataGri d.DataSource = objDataReader
EmployeeDataGri d.DataBind()
End Sub
-------------------------------------------------------------

Unknown
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Unknown

Source Error:
Line 61: objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)
Stack Trace:

[OleDbException (0x80040e14): Unknown]
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr)
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S
dbParams, Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior,
Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method)
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
Database101.Web Form1.btnRunQue ry_OnClick(Obje ct Sender, EventArgs E) in
c:\Database101\ WebForm1.aspx.v b:61
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.370 5.6060; ASP.NET
Version:1.0.370 5.6060

[sloan]

What is the data type (int, decimal , string, text) of "sales" ?

"johnmay124 8" <jo*********@be llsouth.netwrot e in message
news:z8******** ***********@big news5.bellsouth .net...

>I am having a problem with queries running in this code When I use the
query "SELECT * FROM sample" the code runs and the data grid binds and
shows
the contents of the sample table. If I change the query to filter the
results such as "SELECT * FROM sample WHERE (sales 2000)" the code fails
on - objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection) with an unknown
error.
If I load the database up into access2000 and run the sql queries they run
as expected so I know they are valid queries of the data

I am a noob at asp.net data. Can anybody give me a hand?

The Code I am using is below followed by the error info with the stack
trace.

-----------------------------------------------------------------------------

Imports System.Data.Ole Db
Imports System.Data

Sub btnRunQuery_OnC lick(ByVal Sender As Object, ByVal E As EventArgs)
Dim objConnection As OleDbConnection
Dim objCommand As OleDbCommand
Dim objDataReader As OleDbDataReader
Dim strSQLQuery As String

objConnection = New
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0; Data Source=" &
Server.MapPath( "NewDatabase.md b") & ";")

strSQLQuery = "SELECT * FROM sample"

'strSQLQuery = "SELECT * FROM sample WHERE (sales 2000)"

'strSQLQuery = "SELECT * FROM sample WHERE key_id=5"

'strSQLQuery = "SELECT * FROM sample WHERE last_name='John son'"

objCommand = New OleDbCommand(st rSQLQuery, objConnection)

objConnection.O pen()

objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

lblSQLCommandLa bel.Text = strSQLQuery

EmployeeDataGri d.DataSource = objDataReader
EmployeeDataGri d.DataBind()
End Sub
-------------------------------------------------------------

Unknown
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Unknown

Source Error:
Line 61: objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)
Stack Trace:

[OleDbException (0x80040e14): Unknown]
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr)

System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S
dbParams, Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior,
Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method)
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
Database101.Web Form1.btnRunQue ry_OnClick(Obje ct Sender, EventArgs E) in
c:\Database101\ WebForm1.aspx.v b:61
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.370 5.6060;
ASP.NET
Version:1.0.370 5.6060

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

Try using a parameterized query instead of inline SQL statement. Its best
practices technique anyway.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com
"johnmay124 8" wrote:

I am having a problem with queries running in this code When I use the
query "SELECT * FROM sample" the code runs and the data grid binds and shows
the contents of the sample table. If I change the query to filter the
results such as "SELECT * FROM sample WHERE (sales 2000)" the code fails
on - objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection) with an unknown
error.
If I load the database up into access2000 and run the sql queries they run
as expected so I know they are valid queries of the data

I am a noob at asp.net data. Can anybody give me a hand?

The Code I am using is below followed by the error info with the stack
trace.

-----------------------------------------------------------------------------

Imports System.Data.Ole Db
Imports System.Data

Sub btnRunQuery_OnC lick(ByVal Sender As Object, ByVal E As EventArgs)
Dim objConnection As OleDbConnection
Dim objCommand As OleDbCommand
Dim objDataReader As OleDbDataReader
Dim strSQLQuery As String

objConnection = New
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0; Data Source=" &
Server.MapPath( "NewDatabase.md b") & ";")

strSQLQuery = "SELECT * FROM sample"

'strSQLQuery = "SELECT * FROM sample WHERE (sales 2000)"

'strSQLQuery = "SELECT * FROM sample WHERE key_id=5"

'strSQLQuery = "SELECT * FROM sample WHERE last_name='John son'"

objCommand = New OleDbCommand(st rSQLQuery, objConnection)

objConnection.O pen()

objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)

lblSQLCommandLa bel.Text = strSQLQuery

EmployeeDataGri d.DataSource = objDataReader
EmployeeDataGri d.DataBind()
End Sub
-------------------------------------------------------------

Unknown
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Unknown

Source Error:
Line 61: objDataReader =
objCommand.Exec uteReader(Comma ndBehavior.Clos eConnection)
Stack Trace:

[OleDbException (0x80040e14): Unknown]
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32 hr)
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S
dbParams, Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r behavior,
Object& executeResult)
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method)
System.Data.Ole Db.OleDbCommand .ExecuteReader( CommandBehavior behavior)
Database101.Web Form1.btnRunQue ry_OnClick(Obje ct Sender, EventArgs E) in
c:\Database101\ WebForm1.aspx.v b:61
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.370 5.6060; ASP.NET
Version:1.0.370 5.6060