Line 1: using System;using System.Data;using System.Data.SqlClient;using System.Configuration;public partial class DynamicPage:System.Web.UI.Page{protected void Page_Load(object sender,EventArgs e){if(!this.IsPostBack){this.PopulatePage();}} private void PopulatePage(){string PageName=this.Page.RouteData.Values["PageName"].ToString();string conString=ConfigurationManager.ConnectionStrings["constr"].ConnectionString; using (SqlConnection con=new SqlConnection(conString)){using(SqlCommand cmd=new SqlCommand("pDynamicPage")){cmd.CommandType=CommandType.StoredProcedure;using (SqlDataAdapter sda=new SqlDataAdapter()){cmd.Parameters.AddWithValue("@Page",PageName); cmd.Connection=con;sda.SelectCommand=cmd;using(DataTable dt=new DataTable()){sda.Fill(dt); this.Title=dt.Rows[0]["Title"].ToString();this.MetaKeywords=dt.Rows[0]["Keywords"].ToString(); this.MetaDescription=dt.Rows[0]["Description"].ToString();lblTitle.Text=dt.Rows[0]["h1"].ToString(); lblContent.Text=dt.Rows[0]["Content"].ToString(); lblPublishedDate.Text =(DateTime.Now).ToString();}}}}}}
|