roy barlow

roy barlow

  • NA
  • 13
  • 0

Query Strings

Nov 27 2007 6:46 AM

Is there any way to break the CommandText line below, so it's not one long string. I'm from an Access/VBA background where we use an & _ to wrap the text and make it more readable, but I can't figure how wrap it in c#...

Thanks in advance.

Roy.

private void btnLogin_Click(object sender, EventArgs e)

{

System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();

string user=userTxt.Text;

string password = passwordTxt.Text;

command.CommandText = "SELECT u.userID FROM Users AS u WHERE (((u.userName)='" + user + "') AND ((u.password)='" + password + "'));";

}


Answers (1)