matching username and password

Question

hi i am using two textboxes for username and password. how to match whether this exist in datbase or not through c# code only.

tom christ · Answer

write a stored procedure : CREATE PROCEDURE Sp_Scheduler_Login @userName nvarchar(50)@password nvarchar(50) as If Exists(select * from tbl_Scheduler_Project where userName=@userName AND password=@password ) Return 1 ELSE Return 0 GO and call this stored proc where u want to use. or DataSet ds= new DataSet() fill this ds with the query (select * from tbl_AdminLogin where username = ' + TextBox1.text + ' and pass = ' + TextBox2.Text + ') if(ds.Table[0].Count>0) { allready exist } else { new user }

Rajkumar Murugesan · Answer

Hi U can use this kind of technic to check CREATE TABLE User( username varchar(50) password varchar(50) ) dim int temp; SqlConnection con=new SqlConnection(connection String here); con.open(); SqlCommand cmd=new SqlCommand(SELECT count(*)FROM user WHERE username=' ') SqlDataReader dr=cmd. ExecuteReader(); while(dr.Read()); { temp=Convert. ToInt64(dr[0]); } if(temp==0) { Response.Redirect(Login.aspx); } else Response.Redirect(Welcome.aspx); i hope that this will work out...