Creating a Super-Simple DotNetNuke Module with the ExecuteSQL DAL+ method RSS

• • Reply
  

  adefwebserve...

  Contributor

  5912 Points

  1207 Posts

  MVP

  Creating a Super-Simple DotNetNuke Module with the ExecuteSQL DAL+ method

  Jun 28, 2006 03:40 PM|LINK

   Creating a
  
  DotNetNuke Module with the ExecuteSQL DAL+ method

  There is a new 4th DAL+ method that has been added to DotNetNuke 4.3.1 or higher (or DotNetNuke 3.3.1 or higher):
  

  ExecuteSQL()

   

  It allows you to  use code such as:

  
  Dim mySqlString As New StringBuilder()
  mySqlString.Append("SELECT FriendlyName, Description ")
  mySqlString.Append("FROM DesktopModules ")
  mySqlString.Append("WHERE (NOT (Version IS NULL)) ")
  mySqlString.Append("ORDER BY FriendlyName")
  
  Me.GridView1.DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString()), IDataReader)
  
  Me.GridView1.DataBind()

  I have written a tutorial that demonstrates it's use:

  http://www.adefwebserver.com/DotNetNukeHELP/DNN_ShowMeThePages

   

   

  Why is this a big deal?

  • You don't need to use stored procedures
  • You are STILL able to support multiple data sources
  
  Open Light Group
  LightSwitchHelpWebsite.com | ADefWebserver.com