Incorrect syntax near ' '

[thomaaxha]

hi ,, i have a problem in my web app .. i have a calendar and i want to get the day number id from a table and to put it in another table. I want to find my error , please help me. the code is like this:

String day ="SELECT ID FROM Ditet WHERE Dita = ('" + Calendar1.SelectedDate.Day  + "') ";
        SqlCommand day1  = new SqlCommand (day , con);
        string day3 = day1.ExecuteScalar().ToString();
     String vizita = "INSERT INTO [Vizita] (ID_dita)  VALUES  ('" + day3 + "')";
     SqlCommand cmd1 = new SqlCommand( vizita, con);
     cmd1.ExecuteScalar();

[nicolcrome]

It may be single quotes problem , just replace single quotes with double quotes

return str.Replace("'" , "''");

follow th link

http://net-informations.com/csprj/ado.net/singlequotes.htm

crome.

[vijay6]

Hey thomaaxha, your code don't have errors (i tested, works fine). Except you were opened and closed the connection to your database. In line number 6 in your code you should use ExecuteNonQuery () instead of ExecuteScalar() .

[thomaaxha]

thnx for the advice ,, wish the best 4 u:)