Check Db User exists

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

0

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";

}

0

urgent..please tell me any ine.

0