Search thrue Database

[Animal]

Hey,

I've got the following problem: I'm trying to create a small tool that
must be able to search thrue a database using a search-criteria, that
has to be entered by the user in a TextBox. The results of the search
are displayed in a small datagrid.
My problem is that I've no idea how to create the search functionality
with VB.NET. The datadase used is a smal access database.
Maybe one of you can give me a hint....

Thnx!!

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

[Armin Zingler]

"Animal" <di**@phantom s-dot-nl.no-spam.invalid> schrieb

I've got the following problem: I'm trying to create a small tool
that must be able to search thrue a database using a search-criteria,
that has to be entered by the user in a TextBox. The results of the
search are displayed in a small datagrid.
My problem is that I've no idea how to create the search
functionality with VB.NET. The datadase used is a smal access
database. Maybe one of you can give me a hint....

Maybe I misunderstood.. .

Use ADO.NET to access the database. Some Keywords:
- System.Data.Ole Db.OleDbConnect ion
- System.Data.Ole Db.OleDbCommand
- System.Data.Ole Db.OleDbDataRea der
- System.Data.Dat aSet

More ADO.NET:
<F1>
VS.NET
.NET Framework
Programming with .NET Framework
-> Accessing Data
VB and VC#
-> Accessing Data
ADO.NET group: microsoft.publi c.dotnet.framew ork.adonet
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Animal]

> Armin Zinglerwrote:
"Animal" <di**@phantom s-dot-nl.no-spam.invalid> schrieb

I've got the following problem: I'm trying to create a small tool
that must be able to search thrue a database using a search-criteria, that has to be entered by the user in a TextBox. The results of the
search are displayed in a small datagrid.
My problem is that I've no idea how to create the search
functionality with VB.NET. The datadase used is a smal access
database. Maybe one of you can give me a hint....

Maybe I misunderstood.. .

Use ADO.NET to access the database. Some Keywords:
- System.Data.Ole Db.OleDbConnect ion
- System.Data.Ole Db.OleDbCommand
- System.Data.Ole Db.OleDbDataRea der
- System.Data.Dat aSet

More ADO.NET:
<F1>
VS.NET
.NET Framework
Programming with .NET Framework
-> Accessing Data
VB and VC#
-> Accessing Data
ADO.NET group: microsoft.publi c.dotnet.framew ork.adonet
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html[/quote:eaaae8d79 c]

Armin,

Thnx for the hint!
This is what I tried. The code is based on an example given on the
Microsoft site:
Public Sub ReadMyData(ByVa l myConnString As String)
Dim mySelectQuery As String = "SELECT Doc ID, Subject,
Title, created " & _
"FROM Document WHERE Title LIKE " &
TextBox1.Text
Dim myConnection As New
OleDb.OleDbConn ection(myConnSt ring)
Dim myCommand As New OleDb.OleDbComm and(mySelectQue ry,
myConnection)
myConnection.Op en()
Dim myReader As OleDb.OleDbData Reader =
myCommand.Execu teReader()
Try
While myReader.Read()

Console.WriteLi ne(myReader.Get Int32(0).ToStri ng()
+ ", " _
+ myReader.GetStr ing(1))
End While
Finally
' always call Close when done reading.
myReader.Close( )
' always call Close when done reading.
myConnection.Cl ose()
End Try
End Sub
The sub is called by a click on a button.
As soon as the sub is called I'll get the following error:

"An unhandled exception of typ "System.Data.Ol eDb.OleDbExcept ion"
occured in system.data.dll "

The exception gets raised on the line containing:
[code:1:eaaae8d7 9c]Dim myReader As OleDb.OleDbData Reader =
myCommand.Execu teReader()[/code:1:eaaae8d7 9c]

Does anybody has an idea why this exception is raised??

Thnx!!

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.co m The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

[Armin Zingler]

"Animal" <di**@phantom s-dot-nl.no-spam.invalid> schrieb

Public Sub ReadMyData(ByVa l myConnString As String)
Dim mySelectQuery As String = "SELECT Doc ID, Subject,
Title, created " & _
"FROM Document WHERE Title LIKE " &
TextBox1.Text
Dim myConnection As New
OleDb.OleDbConn ection(myConnSt ring)
Dim myCommand As New OleDb.OleDbComm and(mySelectQue ry,
myConnection)
myConnection.Op en()
Dim myReader As OleDb.OleDbData Reader =
myCommand.Execu teReader()
Try
While myReader.Read()

Console.WriteLi ne(myReader.Get Int32(0).ToStri ng()
+ ", " _
+ myReader.GetStr ing(1))
End While
Finally
' always call Close when done reading.
myReader.Close( )
' always call Close when done reading.
myConnection.Cl ose()
End Try
End Sub
The sub is called by a click on a button.
As soon as the sub is called I'll get the following error:

"An unhandled exception of typ "System.Data.Ol eDb.OleDbExcept ion"
occured in system.data.dll "

The exception gets raised on the line containing:
[code:1:eaaae8d7 9c]Dim myReader As OleDb.OleDbData Reader =
myCommand.Execu teReader()[/code:1:eaaae8d7 9c]

Does anybody has an idea why this exception is raised??

You can catch the exception and examine it. Probably there's a syntax error
in the SQL string. Have a look at it.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister. org/news/learn2quote.htm l