Member Avatar for 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...

Edited by kvprajapati because: Added code tags.
  • 2 Contributors
  • 2 Replies
  • 132 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by saneeha.nust
Member Avatar for 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");
Edited by kvprajapati because: n/a
Member Avatar for saneeha.nust

thanks alot... It works....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.