sql server compact query error.There was an error parsing the query. [ Token line number = 1,Token line offset = 12,Token in error = 1 ] .

See more:

C#

Hi,
My code is in C# Asp.net is,

con.Open();

                string qry1 = "select top 1 a.coursename,a.name,a.feespaid,a.admissionid,b.invoicenumber from tb_studentfees a inner join tb_invoice b on a.admissionid=b.admissionid where a.admissionid="+ lbladmissionnumber.Text +" order by b.invoicenumber desc";
                SqlCeDataAdapter da1 = new SqlCeDataAdapter(qry1, con);
                DataTable dt = new DataTable();
                da1.Fill(dt);
                if (dt.Rows.Count > 0)
                {

I run this query successfully in MSSQL,but showing error

"There was an error parsing the query. [ Token line number = 1,Token line offset = 12,Token in error = 1 ] "


in SQL Server compact.

Please help.