Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

Hi I have a problem trying to update and insert a new record into a table i'm using this update and insert command.

   <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MYSQL_ISDB %>" 
    ProviderName="<%$ ConnectionStrings:MYSQL_ISDB.ProviderName %>" 
    SelectCommand="SELECT t_diary_all.Log_ID, vrqsummary.VUpdated, vrqsummary.VWho, vrqsummary.VCompany, vrqsummary.VContact, vrqsummary.VNotes, vrqsummary.VSR, vrqsummary.VLocation, vrqsummary.VDue_Date, vrqsummary.VComplete_Flag, 
                  t_diary_all.Updated, t_diary_all.Who, t_diary_all.Company, t_diary_all.Contact, t_diary_all.Notes, t_diary_all.SR, t_diary_all.Location, t_diary_all.Due_Date, t_diary_all.Complete_Flag FROM t_diary_all INNER JOIN vrqsummary ON t_diary_all.Log_ID = vrqsummary.Log_ID"
    InsertCommand="INSERT INTO [t_diary_all] ([Log_ID], [Updated], [Who], [Company], [Contact], [Notes], [SR], [Location], [Due_Date], [Complete_Flag]) VALUES (@Log_ID, @Updated, @Who, @Company, @Contact, @Notes, @SR, @Location, @Due_Date, @Complete_Flag)" 
    UpdateCommand="UPDATE [t_diary_all] SET [Updated] = @Updated, [Who] = @Who, [Company] = @Company, [Contact] = @Contact, [Notes] = @Notes, [SR] = @SR, [Location] = @Location, [Due_Date] = @Due_Date, [Complete_Flag] = @Complete_Flag WHERE [Log_ID] = @Log_ID">

</asp:SqlDataSource>

This is the error message I am getting http://www.telerik.com/ClientsFiles/450229_error2.jpg

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.