Forum Moderators: open

Message Too Old, No Replies

Thinking... How to Search a name in SQL

I am using SQL with 1 table

         

Kernel

9:16 pm on May 27, 2005 (gmt 0)

10+ Year Member



Hi frinends!
I search the whole forum but not find a single post on how to search a name in Sql database through a text box.

How?
1) If i enter a name in text box to check if that name is exists or not
2) I am using vb.net, SQL Database, Table

Please help!
Kernel

txbakers

1:01 am on May 28, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



When the user clicks submit:
1) dim notthere as boolean = true
2) run a query: "select name from table where name = '" the name in the box + "'"

3) if query is EOF then name is not there
4) ELSE notthere = false

5) if notthere then
6) make your insert

Kernel

10:29 am on May 28, 2005 (gmt 0)

10+ Year Member



txbakers!
Can u explain it in Code words of .net
Or can paste an example

:)

Thanks for helping...

TheNige

8:03 pm on May 31, 2005 (gmt 0)

10+ Year Member



I would suggest reading the many tutorials that are already out there on the Internet. Check out ASP.Net for starters.