| Server IP : 172.67.214.117  /  Your IP : 172.69.214.234 Web Server : Microsoft-IIS/10.0 System : Windows NT WAVE 10.0 build 20348 (Windows Server 2016) AMD64 User : IWPD_458(indias) ( 0) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/inetpub/vhosts/indiasmartbazaar.com/pimsharyana.in/ | 
| Upload File : | 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class details : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Getdetails();
        }
    }
    private void Getdetails()
    {
        if (Request.QueryString.ToString() != "" && Request.QueryString.ToString() != null)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
            SqlCommand SqlCmd = new SqlCommand("SP_Get_News", conn);
            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.Parameters.Add("@ID", SqlDbType.Int).Value = Request.QueryString["ID"].ToString();
            conn.Open();
            SqlDataAdapter Da = new SqlDataAdapter(SqlCmd);
            DataTable Dt = new DataTable();
            Da.Fill(Dt);
            conn.Close();
            if (Dt.Rows.Count > 0)
            {
                lblhead.Text = Dt.Rows[0]["heading"].ToString();
                lblcontent.Text = Dt.Rows[0]["ckeditor"].ToString();
            }
        }
    }
}