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

  • 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

  • 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

     

  • 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.

    :)

  • Jeroen Breuer 4908 posts 12265 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

  • 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

Please Sign in or register to post replies

Write your reply to:

Draft