Error during the execution of an sql comand in C#
Here down there is my code, when I execute it it says that I have an syntax error near GrupetStudentet, While thos query works very good on sql server, but when O write it on my code it says that I have a problem. PLs can somebudy help me if you know th answer.
string ID;
ID = txtIDstudent.Text;
string sql = "SELECT gs.Grupi_ID, (s.Emri + ' ' + s.Mbiemri) as Studenti, n.EmriNivelit as Niveli, k.EmriKursit as Kursi";
sql +="FROM GrupetStudent gs";
sql +="inner join Studenti s on gs.Studenti_ID = s.Studenti_ID";
sql +="inner join Niveli n on gs.Nivel_ID = n.ID_nivelit";
sql +="inner join Kursi k on gs.Kursi_ID = k.ID_kurs";
sql +="WHERE s.Studenti_ID="+ID;
if (txtIDstudent.Text == "")
{
MessageBox.Show("Ju lutem shënoni ID-në e studentit");
}
else
{
SqlDataAdapter DaKerko = new SqlDataAdapter(sql, con);
DataTable dtKerko = new DataTable();
DaKerko.Fill(dtKerko);