Skip to main content
Home  › ... 2sxc Apps

Data Tutorials

Tutorial Home
SQL data from a SQL query and DataTable
#9 SQL data from a SQL query and DataReader
DNN data (pages/tabs) from the DNN TabController

The top 10 files found in this portal as returned from DB

This example queries the DNN SQL for the files using DataReader objects.

Requirements
Resources 

@{
  // load the sql connection name from Web.Config
  // the default connection string for DNN is SiteSqlServer
  var conString = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ToString();

  var con = new SqlConnection(conString);
  con.Open();

  // You should always write parameters using the @-syntaxt,
  // and never write them directly into the SQL using string-concatenation
  // to protect yourself from SQL injection attacks
  var command = new SqlCommand("Select Top 10 * from Files Where PortalId = @PortalId", con);
  command.Parameters.Add("@PortalId", CmsContext.Site.Id);
  var myReader = command.ExecuteReader();
}
  1. home.css
  2. background_header.gif
  3. icon-btn-sm-circle-arrow.png
  4. icon-btn-sm-circle-arrow-shadow.png
  5. icon-social-facebook.png
  6. icon-social-linkedin.png
  7. icon-social-twitter.png
  8. icon-social-youtube.png
  9. logo.png
  10. logo2.png
 

<ol>
  @while (myReader.Read())
  {
    <li>@myReader["FileName"]</li>
  }
</ol>
@{
  myReader.Close();
}
SQL data from a SQL query and DataTable
#9 SQL data from a SQL query and DataReader
DNN data (pages/tabs) from the DNN TabController

Source Code of this file

Below you'll see the source code of the file. Note that we're just showing the main part, and hiding some parts of the file which are not relevant for understanding the essentials. Click to expand the code 

@inherits Custom.Hybrid.Razor14
<!-- unimportant stuff, hidden -->
@using System.Configuration
@using System.Data
@using System.Data.SqlClient

The top 10 files found in this portal as... <!-- unimportant stuff, hidden -->

@{
  // load the sql connection name from Web.Config
  // the default connection string for DNN is SiteSqlServer
  var conString = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ToString();

  var con = new SqlConnection(conString);
  con.Open();

  // You should always write parameters using the @-syntaxt,
  // and never write them directly into the SQL using string-concatenation
  // to protect yourself from SQL injection attacks
  var command = new SqlCommand("Select Top 10 * from Files Where PortalId = @PortalId", con);
  command.Parameters.Add("@PortalId", CmsContext.Site.Id);
  var myReader = command.ExecuteReader();
}





<ol>
  @while (myReader.Read())
  {
    <li>@myReader["FileName"]</li>
  }
</ol>
@{
  myReader.Close();
}



<!-- unimportant stuff, hidden -->