Check Db User exists

Question

please tell me i am created two text box. first textbox enter a name . and second text you go to. check first textbox name in db . is their will display already exists. not their available. so please this problem slove

Rupesh N · Answer

urgent..please tell me any ine.

Rupesh N · Answer

sorry its not working. i taken in 2 textboxs 1 label 1 submit. so if enter text in textbox box and enter texbox2. if already stored name in db display label (already exists) in textbox1 under label. so please urgent slove this

Ramesh Singh · Answer

Hi create a stored procedure to check for text box value(name) into database table. if exiting then return 1 else return 0. if (select count(*) from dbTable where userName=@username >0) then begin return 1; else return 0; end; In .net code write logic: if (returnVal ==1) { 2ndTextbox.Text = already exists ; } esle { 2ndTextbox.Text = not their value; }