I am doing one of the asp tutorials, but all the code is in VB. I’m trying to translate it to C# and I’m getting an error in compilation. Here is the code:

void LoginBtn_Click(Object sender, EventArgs e) {
    if (Page.IsValid)
    {
        System.Data.DataSet userDS = GetUser(UserName.Text, UserPass.Text) ;

** the compiler error flags the next line saying that "(" is expected.  Can you spot what I’m doing wrong?

        if userDS.Tables(0).Rows.Count = 1     
        {
            FormsAuthentication.RedirectFromLoginPage(UserName.Text, true);
        }
        else
        {
            Msg.Text = "Invalid Credentials: Please try again";
        }
    }
}

 

System.Data.DataSet GetUser(string userName, string userPassword)
    {
        string connectionString = "server=\'(local)\'; user id=\'sa\'; password=\'\'; database=\'Orders\'";
        System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);

        string queryString = "SELECT [Users].* FROM [Users] WHERE (([Users].[UserName] = @UserName) AND ([Users" + "].[UserPassword] = @UserPassword))";

        System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
        dbCommand.CommandText = queryString;
        dbCommand.Connection = dbConnection;
 

        System.Data.IDataParameter dbParam_userName = new System.Data.SqlClient.SqlParameter);
        dbParam_userName.ParameterName = "@UserName";
        dbParam_userName.Value = userName;
        dbParam_userName.DbType = System.Data.DbType.String;
        dbCommand.Parameters.Add(dbParam_userName);

 
        System.Data.IDataParameter dbParam_userPassword = new system.Data.SqlClient.SqlParameter();
        dbParam_userPassword.ParameterName = "@UserPassword";
        dbParam_userPassword.Value = userPassword;
        dbParam_userPassword.DbType = System.Data.DbType.String;
        dbCommand.Parameters.Add(dbParam_userPassword);

 

        System.Data.IDbDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
        dataAdapter.SelectCommand = dbCommand;
        System.Data.DataSet dataSet = new System.Data.DataSet();
        dataAdapter.Fill(dataSet);

        return dataSet;
    }