asp.net login on line : Hello at the end of this i get an syntax error, but i cant figure out what causes the error

                SqlDataAdapter sda = new SqlDataAdapter("Select * From bruker Where Brukernavn='" + Textbox1.Text + "' and Passord='" + TextBox2.Text"");
