two conditions in where clause...

[saneeha.nust]

I need to apply the "&" operator in where clause...
the code is:

com = new OleDbCommand("select Accesstype from FTPSitesAuthorisation WHERE (SiteName = @site_name) & (UserName=@user_name)", conn);

It does not give any error,,, but the result is not correct , the "and" operation
is not applied...

please guide , where am I wrong...

[kvprajapati]

Use and operator.

com = new OleDbCommand("select Accesstype from FTPSitesAuthorisation WHERE SiteName = @site_name and [UserName]=@user_name", conn);
com.Parameters.AddWithValue("@site_name","site_name_here");
com.Parameters.AddWithValue("@user_name","user_ame_here");

[saneeha.nust]

thanks alot... It works....