SQL Search

[Jollywg]

I'm trying to figure out how to use SQL to search for a record and return a Boolean value to tell me whether its there or not.

Thanks in advance!!
Jolly

[tlhintoq]

Database How two parts 1 and 2

http://bytes.com/topic/net/insights/635615-how-use-database-your-program

http://bytes.com/topic/net/insights/817960-how-use-database-your-program-part-ii

[Jollywg]

thanks for the post, but i didnt see anything that would actually let me store the result of a boolean value

[tlhintoq]

I'm trying to figure out how to use SQL to search for a record and return a Boolean value to tell me whether its there or not.

thanks for the post, but i didnt see anything that would actually let me store the result of a boolean value

These two questions aren't really the same thing, but addressing the original question...
Search for a record, which I am sure was in the tutorials.
If the returned results contain the record set your boolean to true.

[semomaniz]

first create a boolean and set it to true, then declare the sql statements and then execute it and assign it to a Datareader. then check for if reader has rows. if no rows return false.

[Jollywg]

semomaniz: how do i check to see if the reader has rows (select count?) once I do that how do assign that SQL to a C# variable?

[Jollywg]

semomaniz: I got it figured out.

Thanks for the posts everyone!

[semomaniz]

I am glad you did figure out