How do I write a SQLDataSource Update Command to the Screen for Troubleshooting?

Posted on 2011-10-14
Last Modified: 2012-05-12
I've got an sds update command that is not updating the underlying db nor is it throwing any errors. I would like to print the update string to the screen after it generates so I can see why the update is failing. The command is in sds located in the aspx file.
Question by:MCallas
    LVL 7

    Expert Comment

    If I understood the question correctly then you want to print the update commad on the page for troubleshooting. Can we try Response.Write(Sqldatasource1.UpdateCommand.ToString()); or just check with the sql server profiler whats going wrong.

    Accepted Solution

    Yes, you understood my question correctly. I tried the Response.Write(sdsCurrentTraining.UpdateCommand.ToString()); but it literally wrote "Response.Write(sdsCurrentTraining.UpdateCommand.ToString());" to the screen.
    How do I check with the sql server profiler? I don't have Performance Tools under my SQL Server 2008 menu.

    Author Closing Comment

    No sense in beating a dead horse here. Thanks anyway.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Problem to be resolved in this article Currently, development of website and web application can be done without writing thousands of lines of programming code by hand. Description This can be done through by using a open source framework such …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now