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 + "'));";
}