Click here to Skip to main content
15,893,337 members

Comments by Suresh9724 (Top 1 by date)

Suresh9724 23-Jan-12 6:00am View    
still get error like ::

Incorrect syntax near '.'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '.'.

Source Error:

Line 21: SqlCommand cmd = new SqlCommand("update tbl_bid set Availablebid = Availablebid + (select Package_Price from package where pac_id = Convert.ToInt32(e.CommandArgument)) where l_id=1 ", con);
Line 22: con.Open();
Line 23: cmd.ExecuteNonQuery();
Line 24: con.Close();
Line 25: }