using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class DomainView : System.Web.UI.Page { //SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]); SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); IFormatProvider DtFormat = new System.Globalization.CultureInfo("en-GB", true); DataSet ds = new DataSet(); ShowHide objSH = new ShowHide(); FillDD objFillDD = new FillDD(); Validate objValidate = new Validate(); Extra objExtra = new Extra(); Dashboard ojbDash = new Dashboard(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string domid = Request.QueryString["Id"]; lblWhr1.Text = domid; Get_ClientDetails01(); fill_DGDetails(); } } void Get_ClientDetails01() { try { SqlDataAdapter adp = new SqlDataAdapter("Select Id,ClientId,ClientName from VW_DomainMaster Where Id ='" + lblWhr1.Text + "'", con); adp.Fill(ds, "Cmas1"); DgDomain.DataSource = ds.Tables["Cmas1"]; DgDomain.DataBind(); } catch (Exception exp) { lblDgerr.Text = ("DG Alert! : " + exp.Message); } } void fill_DGDetails() { try { string view = "Select Id,DomId,DomainName, convert(varchar(11),DRegDate,101)as DRegDate, convert(varchar(11),DExpDate,101)as DExpDate,convert(varchar(11),HRegDate,101)as HRegDate, convert(varchar(11),HExpDate,101)as HExpDate,HRegisterBy,HFtpUrl,HUid,HPass,HSpace,EntryBy,convert(varchar(10),EntryDate,101)as EntryDate,companyname from dbo.VW_DomainHosting Where DomId ='" + lblWhr1.Text + "' order by Id Desc"; SqlDataAdapter adp1 = new SqlDataAdapter(view, con); DataSet ds1 = new DataSet(); adp1.Fill(ds1, "DH1"); DGDetails.DataSource = ds1.Tables["DH1"]; DGDetails.DataBind(); } catch (Exception exp) { lblDgerr.Text = ("DG Alert! : " + exp.Message); } } }