how to write the querry at the login with user name given but password is null

[developerit]

Hi , iam using asp.net2.0 with c# with backend sql server 2000. in my database some user dosent have password (null) and some user having password .when iam checking the user it is giving message invalid user or password. can you correct my querry which helps me

SqlCommand cmd = new SqlCommand("select * from Usersprogrammer where UserName='" + txtusername.Text + "' and OrPassword='"+txtpassword.Text+"'", con);

[Eduard Keilholz]

This should do the trick if I understand your question correctly

string sQuery = "SELECT * FROM Usersprogrammer where ((UserName = '" + txtusername.Text + "') and ((OrPassword is null) or (OrPassword = '" + txtpassword.Text + "')))"

.: I love it when a plan comes together :. http://www.zonderpunt.nl

[Tej Aj]

check this post http://opexsolution.com/forum/viewtopic.php?f=15&t=60&p=182#p182[^]

[developerit]

thanks for code project team ...... this logic helps me