Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Petr Snobelt 923 posts 1535 karma points
    Jul 22, 2009 @ 09:23
    Petr Snobelt
    0

    Using datalayer

    Hi,

    I need run simple sql command (shrink transaction log) .In v3 I use sqlCommand, in v4 there datalayer is introduced, but I can't find any documentation how to use it. What is recommended way to do it in v4?

    Thanks

    Copy Link
  • Peter Dijksterhuis 1442 posts 1722 karma points
    Jul 22, 2009 @ 09:41
    Peter Dijksterhuis
    0

    Hi Petr,

    You could try something like:

    SqlHelper.ExecuteNonQuery("truncate table cmsContentXml");

    HTH,

    PeterD

    Copy Link
  • Max 144 posts 166 karma points
    May 01, 2012 @ 09:37
    Max
    0

    does the SqlHelper allow you to retrieve or select all data from the database

     

    Copy Link
  • Tim 1193 posts 2675 karma points MVP 4x c-trib
    May 03, 2012 @ 15:26
    Tim
    0

    @Max, yup it certainly does. Assuming you want a DataReader, you can use SqlHelper.ExecuteReader() to return info from the database.

    :)

    Copy Link
  • Jeroen Breuer 4909 posts 12266 karma points MVP 5x admin c-trib
    May 03, 2012 @ 17:51
    Jeroen Breuer
    0

    You can find an example of the SqlHelper here in the UpdateDAMP method: http://damp.codeplex.com/SourceControl/changeset/view/86116#1765747

    Jeroen

    Copy Link
  • czy 12 posts 32 karma points
    Jul 17, 2012 @ 12:12
    czy
    0

    Oh, sqlhelper is discussed here? I just completed a performance study on it. please refer to Proformance study in sqlhelper

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies