programmingnoob

so I am writing a C#program that determines whether a given name exists in the MySql database

after determining the database and all that...
first, I execute on C#....
and then I go through the entries until it finds the given name....

alternatively, what I could do is use...
but then I dont know how C# would catch it if mysql tells it that it matched nothing, which implies empty set.


I was also wondering... whether my approach is appropriate and efficient for searching large databases... or are there better (yet simple) approaches?

programmingnoob

I mean for example, while inserting an entry into mysql, it can catch for exception and determine if error number is 1062, then the entry already exists....

Infinite Recursion

I suggest your alternative approach, but make sure you take the case sensitivity into consideration. Depending on how you query the database, normally you could determine if the query yielded any results based on how many records were returned from the query.

The "already exists" error is something that can be handled also, again, depending on how you are connection to the database and which method you are using to submit transactions.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

programmingnoob

oh I know how to deal with 'already exists' error....
what I was asking is what does it do when I execute the below command using C#
then if there is no 'example' entry in name column, then what does it return to C#, that I could check against?
I know I am not saying it in a very clear way...

lectricpharaoh

If you're using VS.NET 2005, you might consider using the wizards for the table adapter, etc stuff. Then you can create your queries with the wizard as well, or enter the actual SQL statements if you're comfortable with that. Then, when you execute your select query, you get a table filled with zero or more records. Simply count the number of rows (ie records), and you know whether anything was returned.

__________________
A man's knowledge is like an expanding sphere, the surface corresponding to the boundary between the known and the unknown. As the sphere grows, so does its surface; the more a man learns, the more he realizes how much he does not know. Hence, the most ignorant man thinks he knows it all. - L. Sprague de Camp

Infinite Recursion

"then if there is no 'example' entry in name column, then what does it return to C#, that I could check against?"

Execute the query using an invalid value for the name, then print out what the resulting value is (probably null), and note the Exception returned. There may also be a mysql_fetch_row type of function that will yield 0 or null based on the results of the query that is passed in. If time permits, I'll tinker with it a bit when I get home and respond with a more descriptive answer.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

Fourth

this is the answer to my knowledge. at least in my experience with asking for things in a database in mysql the return of an empty result is null.