C# sqlDataAdapter WHERE clause incorect syntax

See more:

C#

Hi!


I'm getting an error at da.Fill(dt) when i run the application, it says "Incorrect syntax near '='." and it's because WHERE clause because when i comment it out it runs with no errors.
can anyone please help me?

here's some code:

private void Kombi_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'kombiDBDataSet.KombiStateTbl' table. You can move, or remove it, as needed.
            this.kombiStateTblTableAdapter.Fill(this.kombiDBDataSet.KombiStateTbl);
            numberPlateComboBox.Text = oldIndexText;
            oldIndexText = numberPlateComboBox.Text;  
   

            conn.ConnectionString =(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Projects\RentalPlus\RentalPlus\KombiDB.mdf;Integrated Security=True;User Instance=True");
            conn.Open();

            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            ds.Tables.Add(dt);
            SqlDataAdapter da = new SqlDataAdapter();
            String Param1 = this.Text;

            da = new SqlDataAdapter("SELECT RentalTbl.NumberPlate, RentalTbl.PricePD, RentalTbl.FromDate,"
            + "RentalTbl.ToDate, ClientTbl.CompanyName, ClientTbl.ContactName, ClientTbl.Mobile,"
            + "ClientTbl.Email FROM RentalTbl INNER JOIN ClientTbl ON RentalTbl.ClientID = ClientTbl.ClientID"
            + "WHERE(RentalTbl.NumberPlate = @Param1)", conn);
            
            da.Fill(dt);

            singleHistoryDataGridView.DataSource = dt.DefaultView;

            conn.Close();
                  
        }