namespace Ocean2.Web.Dal.Reporting
{
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security; /// <summary>
/// Summary description for DataAccess
/// </summary>
public partial class DataAccess
{
System.Data.SqlClient.SqlConnection Connection;
public DataAccess()
{
Connection = new System.Data.SqlClient.SqlConnection();
Connection.ConnectionString = ConfigurationManager.ConnectionStrings["ComicsConnectionString"].ConnectionString;
}
private System.Data.SqlClient.SqlConnection CreateConnection()
{
return Connection;
}
public System.Data.DataSet Page(int PageId)
{
System.Data.SqlClient.SqlCommand Cmd = new System.Data.SqlClient.SqlCommand();
Cmd.CommandText = @"Select
[pageid],[pagename],[title],[keywords],[description]
From [Page]
where (
[pageid] = @pageid)
Order By
[PageId]
";
Cmd.CommandType = System.Data.CommandType.Text;
Cmd.Connection = this.CreateConnection();
System.Data.SqlClient.SqlParameter Parameter;
//---------------------------------------------------
// PageId
//---------------------------------------------------
Parameter = new System.Data.SqlClient.SqlParameter();
Parameter.ParameterName = "@PageId";
Parameter.SourceColumn = "PageId";
Parameter.Precision = 10;
Parameter.Size = 4;
Parameter.IsNullable = false;
Parameter.Value = PageId;
Cmd.Parameters.Add(Parameter);
System.Data.SqlClient.SqlDataAdapter Adapter;
Adapter = new System.Data.SqlClient.SqlDataAdapter();
Adapter.SelectCommand = Cmd;
System.Data.DataSet ds = new System.Data.DataSet();
Adapter.Fill(ds);
return ds;
}
public System.Data.DataSet PageItems(int pageid)
{
System.Data.SqlClient.SqlCommand Cmd = new System.Data.SqlClient.SqlCommand();
Cmd.CommandText = @"Select
[pageitemid],[ordernum],[pageid],[title],[article]
From [PageItems]
where (
[pageid] = @pageid)
Order By
[ordernum],
[PageitemId]
";
Cmd.CommandType = System.Data.CommandType.Text;
Cmd.Connection = this.CreateConnection();
System.Data.SqlClient.SqlParameter Parameter;
//---------------------------------------------------
// pageid
//---------------------------------------------------
Parameter = new System.Data.SqlClient.SqlParameter();
Parameter.ParameterName = "@pageid";
Parameter.SourceColumn = "pageid";
Parameter.Precision = 10;
Parameter.Size = 4;
Parameter.IsNullable = false;
Parameter.Value = pageid;
Cmd.Parameters.Add(Parameter);
System.Data.SqlClient.SqlDataAdapter Adapter;
Adapter = new System.Data.SqlClient.SqlDataAdapter();
Adapter.SelectCommand = Cmd;
System.Data.DataSet ds = new System.Data.DataSet();
Adapter.Fill(ds);
return ds;
}
}
}
Ocean2.Web.Dal.Reporting.DataAccess DB = new Ocean2.Web.Dal.Reporting.DataAccess();
System.Data.DataSet ds = DB.Page(PageId);
