Ramco Ramco
HI
I am getting error - Incorrect Syntax near publishedAt at cmd.ExecuteNonQuery();
private void InsertVideoDetails(string VideoId, string VideoTitle, string Description, int ViewCount, string LikeCount, string CommentCount, DateTime PublishedAt) { string sql = "INSERT INTO Videos (VideoId, VideoTitle, Description,LikeCount, ViewCount,CommentCount,Published_At) VALUES (@VideoId, @VideoTitle, @Description,@LikeCount, @ViewCount,@CommentCount,@PublishedAt"; string constring = ConfigurationManager.ConnectionStrings["Cnn"].ConnectionString; using (SqlConnection con = new SqlConnection(constring)) { using (SqlCommand cmd = new SqlCommand(sql)) { cmd.Parameters.AddWithValue("@VideoId", VideoId); cmd.Parameters.AddWithValue("@VideoTitle", VideoTitle); cmd.Parameters.AddWithValue("@Description", Description); cmd.Parameters.AddWithValue("@LikeCount", LikeCount); cmd.Parameters.AddWithValue("@ViewCount", ViewCount); cmd.Parameters.AddWithValue("@CommentCount", CommentCount); cmd.Parameters.AddWithValue("@PublishedAt", PublishedAt); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } }
Thanks