Searching Database stops iterator function?

Question

1.00/5 (1 vote)

See more:

Once again hello.....

I am puzzled as to why my iterator function stops when trying to add The code that should only read from the database to compare the hash in my string.

the code that I am trying to accommodate with the database uses exact string pattern matching with booyer moore and the cryptographic hash algorithm of each file being scanned.

I have seen many examples of how to do this type of search one name or one string at a time with a click event but have not seen any example for checking continuously through a filesystem.

Any advise would be greatly appreciated.

A small example of a file search type method or word as string to search if it matches a data row in a database would be perfect and would take me a long way.

thank you in advance

Posted 2-Feb-12 4:24am

Dale 2012

Add a Solution

Comments

Dale 2012 2-Feb-12 11:49am

Ok I have come up with this but it still is not working.........

Imports System.Data.OleDb
Public Class Form1
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
cn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Admin\Desktop\File Enumerator VB.Net\bin\Debug\AVDatabaseX64.accdb;Persist Security Info=True")
cn.Open()
Dim strSearch As String
strSearch = "Select * FROM [MD5 Hash Signature]"
cmd = New OleDbCommand(strSearch, cn)
dr = cmd.ExecuteReader
While dr.Read

If dr(1) = txtSearch.Text Then
Label2.Text = +1
End If
End While
cn.Close()
dr.Close()
End Sub
End Class

It comes up with an error:

The Microsoft Office Access database engine cannot find the input table or query 'MD5 Hash Signature'. Make sure it exists and that its name is spelled correctly.

Dale 2012 2-Feb-12 11:54am

If I fix the line: strSearch = "Select * FROM [MD5 Hash Signature]"

to

strSearch = "Select * FROM MD5 Hash Signature"

I get an error:

Syntax error in FROM clause.

why?.......

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2012-02-02T07:27:00

Solution 1

It's telling you that you don't have a table in the database named (exactly!) "MD5 Hash Signature". Putting the square brackets around the name tells the query processor that the table name either has spaces in it (BAD IDEA!) or a a reserved word being used as an object name (another BAD IDEA!).

All you have to do is open the database and look at the table names to know for sure.

Posted 2-Feb-12 7:27am

Dave Kreskowiak

Comments

Dale 2012 2-Feb-12 21:03pm

well........ I do have two tables .... do i need to first name the table and then the column row of the table?

Dave Kreskowiak 2-Feb-12 22:39pm

You don't know anything about SQL do you?? I would seriously pickup a book on it or on Access before you continue.

The very simplified format for a SELECT statement is:

SELECT columnName1,columnName2,columnNameN, ... FROM tableName WHERE filterExpression

Dale 2012 3-Feb-12 19:23pm

Do you normally ask questions to which you know the answers?. I thank you for the response but am tired of hearing the expression "pick up a book" lol its the age of computers and the internet is a much better resource than any book I have ever read.

Is this site not for asking questions?......

Dave Kreskowiak 3-Feb-12 19:29pm

Do you normally ask questions to which you know the answers? Always.

Yeah, but the problem with the Internet is you don't get the complete story all at once. You get little pieces of information, both good AND BAD, from everywhere and it's up to you to filter out the bad and stitch the good together, hopefully in the correct order.