how i can check if text box value exist in data base or not plzzz helppp

Recommended Answers

All 3 Replies

Write a select query to check if textbox value is there in DB.If the number of record returned is greater than 0,then textbox value already exist

Query will be something similar to:-

SELECT count(*) from your_table where field = textbox.value

Read more about count http://msdn.microsoft.com/en-us/library/ms175997.aspx
So if it returns more than 0,that means record exist in DB with the value of textvalue

what method are you using? are you using adodc? adodb? DAO? what database are you using?

how i can check if text box value exist in data base or not plzzz helppp

It's better to understand if you post your code. How far you doing this.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.