Insert and update data to database using sqlcommand with parameters in asp.net

public SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString());
    public string conStr = ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString();
    SqlCommand cmd;


 try
        {
     
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }

        cmd = new SqlCommand("select * from [inner] where country='"+ddcountry.SelectedValue+"' and page='"+ddname.SelectedValue+"'", con);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            dr.Close();
            cmd = new SqlCommand("update [inner] set lblp1=@lblp1 where country=@country and page=@page", con);
            cmd.Parameters.Add("@page", SqlDbType.VarChar, 50).Value = ddname.SelectedValue;
            cmd.Parameters.Add("@lblp1", SqlDbType.NText).Value = CKEditor1.Text;
            cmd.Parameters.Add("@country", SqlDbType.VarChar, 5000).Value = ddcountry.SelectedValue;
            //cmd = new SqlCommand("update [inner] set lblp1=N'"+CKEditor1.Text+"' where country='"+ddcountry.SelectedValue+"' and page='"+ddname.SelectedValue+"'", con);
            cmd.ExecuteNonQuery();
       
        }
        else
        {
            dr.Close();
            cmd = new SqlCommand("insert into [inner] values(@country,@page,@lblp1)", con);
            cmd.Parameters.Add("@page", SqlDbType.VarChar, 50).Value = ddname.SelectedValue;
            cmd.Parameters.Add("@lblp1", SqlDbType.NText).Value = CKEditor1.Text;
            cmd.Parameters.Add("@country", SqlDbType.VarChar, 5000).Value = ddcountry.SelectedValue;
            //cmd = new SqlCommand("insert into [inner] values('"+ddcountry.SelectedValue+"','"+ddname.SelectedValue+"',N'"+CKEditor1.Text+"')", con);
            cmd.ExecuteNonQuery();
        }
        con.Close();

        clsAlert.Show("Data Saved Successfully");
        CKEditor1.ReadOnly = true;

        }
        catch (Exception ex)
        {
        }

Read data from table using SQL datareader class in asp.net

public SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString());
    public string conStr = ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString();
    SqlCommand cmd;


 if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }

        cmd = new SqlCommand("select * from IEP", con);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            txtp1.Text = dr[1].ToString();
           

        }
        dr.Close();

        con.Close();

Check connection state closed in asp.net

 public SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString());


 if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }

Set connection string in web.config and call in asp.net

<connectionStrings>
    <add name="SLMFConnection" connectionString="Server=174.122.52.131;Database=abcdb;Uid=admindb;Password=abchenry123;" providerName="System.Data.SqlClient"/>
    <!--<add name="SLMFConnection" connectionString="Data Source=.;Initial Catalog=ConsultPlus;UID=sa;password=tiger123"/>-->
    <!--<add name="SLMFConnection" connectionString="Data Source=.;Initial Catalog=abccms; Integrated Security=True"/>-->

  </connectionStrings>


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 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString());
    public string conStr = ConfigurationManager.ConnectionStrings["SLMFConnection"].ToString();

Insert data to Database using SQL Command class in asp.net

 SqlCommand cmd;
cmd = new SqlCommand("insert into IEP  values('1',N'" + txtp1.Text + "')", con);
                cmd.ExecuteNonQuery();