ASP.Net ช่วยแนะนำโค๊ดการย้ายข้อมูลด้วยค่ะไม่แน่ใจว่ามาถูกทางหรือยัง

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ManageRoleMenu();

            string userNameEdit = this.User.Identity.Name;
            ProfileCommon profileEdit = this.Profile;

            selectcompany2.Visible = false;
            showdata2.Visible = false;
            selecttye.Visible = false;
            keycontract.Visible = false;
            cmdnext.Visible = false;
            showcontract.Visible = false;



            ClickPopup(cmdSearch, @"Admin/Company/" + PageName() + ".aspx", "../../SearchComp.aspx");

            ClickPopup(cmdSearch2, @"Admin/Company/" + PageName() + ".aspx", "../../SearchComp.aspx");

            if (Request.QueryString["c"] != null)
            {
                if (Session["company"].ToString() == "1")
                {
                    txtSearch.Text = GetCompanyName(Request.QueryString["c"].ToString());
                    cmdnext.Visible = true;
                   
                }
                else
                {
                    txtSearch2.Text = GetCompanyName(Request.QueryString["c"].ToString());
                    cmdnext2.Visible = true;

                     BindCompanyLeft(Session["company"].ToString());

                }
            }
   
        }

    }
    protected void cmdSearch_Click(object sender, EventArgs e)
    {
        Session["company"] = "1";
    }
    protected void cmdSearch2_Click(object sender, EventArgs e)
    {
        Session["company"] = Request.QueryString["c"].ToString();
        BindCompanyLeft(Session["company"].ToString());

    }

    private void BindCompanyLeft(string companyID)
    {

        DataTable dt = new DataTable();
        dt = GetCom();

        if (dt.Rows.Count > 0)
        {
            lblcompany1.Text = GetCompanyName(Request.QueryString["c"].ToString());
            lbladdress.Text = dt.Rows[0]["CompanyAddress"].ToString();

            optkey1.DataSource = dt;
            optkey1.DataTextField = "Person";
            optkey1.DataValueField = "KeyContractPersonID";
            optkey1.DataBind();
            optkey1.RepeatDirection = RepeatDirection.Vertical;
        }
        else
        {
            selectcompany2.Visible = false;
            Alert("Info", "No Data", true);
        }
        selectcompany1.Visible = false;
        selectcompany2.Visible = true;
        keycontract.Visible = true;
        showcontract.Visible = true;
        showdata2.Visible = true;
        selecttye.Visible = true;
        lblto2.Visible = true;
        ddlProp.Visible = false;
        Label2.Visible = false;
        cmdSet.Visible = false;


    }

    private void BindCompanyRight(string companyID)
    {
        DataTable dt = new DataTable();
        dt = GetCom2();

        if (dt.Rows.Count > 0)
        {
            lblcompany2.Text = GetCompanyName(Request.QueryString["c"].ToString());
            lbladdress2.Text = dt.Rows[0]["CompanyAddress"].ToString();

            optkey2.DataSource = dt;
            optkey2.DataTextField = "Person";
            optkey2.DataValueField = "KeyContractPersonID";
            optkey2.DataBind();
            optkey2.RepeatDirection = RepeatDirection.Vertical;

            company1.Visible = true;
            company2.Visible = true;
            selecttye.Visible = true;
            lblcompany1.Visible = true;
            lbladdress.Visible = true;
            lbladdress2.Visible = true;
            lblcompany2.Visible = true;

 
        }

        else
        {
            Alert("Info", "No Data", true);
        }
    }
    protected void cmdnext_Click(object sender, EventArgs e)
    {
        BindCompanyLeft(Session["company"].ToString());

        lblto2.Visible = false;
        cmdnext2.Visible = false;
    }
    protected void cmdnext2_Click(object sender, EventArgs e)
    {
        BindCompanyRight(Request.QueryString["c"].ToString());

        lblto2.Visible = true;
        lblsearch2.Visible = false;
        txtSearch2.Visible = false;
        cmdSearch2.Visible = false;
        cmdnext2.Visible = false;
        lblto.Visible = false;
    }
    private DataTable GetCom()
    {
        using (SqlConnection cn = new SqlConnection(Globals.Settings.Contacts.ConnectionString))
        {
            string sql = " SELECT  tbx_KeyContractPerson.ComPersonName + '  (' + tbx_Properties.PropDisplay + ')' AS Person, tbx_TranKeyContract.PropID, tbx_TranKeyContract.KeyContractPersonID ,tbx_Company.CompanyAddress";
            sql = sql + "  FROM tbx_KeyContractPerson INNER JOIN ";
            sql = sql + "  tbx_TranKeyContract ON tbx_KeyContractPerson.KeyContractPersonID = tbx_TranKeyContract.KeyContractPersonID INNER JOIN ";
            sql = sql + "  tbx_Properties ON dbo.tbx_TranKeyContract.PropID = dbo.tbx_Properties.PropID INNER JOIN ";
            sql = sql + "  tbx_Company ON dbo.tbx_TranKeyContract.CompanyID = dbo.tbx_Company.CompanyID";
            sql = sql + "  WHERE tbx_Company.CompanyName = '" + txtSearch.Text + "'";


            //Request.QueryString["c"].ToString().ToDecimal()
            SqlCommand cmd = new SqlCommand(sql, cn);
            cmd.CommandType = CommandType.Text;
            cn.Open();
            DataTable dt = new DataTable();

            System.Data.Common.DbDataReader dr;
            dr = cmd.ExecuteReader();

            dt.Load(dr);
            return dt;
        }
    }
    private DataTable GetCom2()
    {
        using (SqlConnection cn = new SqlConnection(Globals.Settings.Contacts.ConnectionString))
        {
            string sql = " SELECT  tbx_KeyContractPerson.ComPersonName + '  (' + tbx_Properties.PropDisplay + ')' AS Person, tbx_TranKeyContract.PropID, tbx_TranKeyContract.KeyContractPersonID ,tbx_Company.CompanyAddress";
            sql = sql + "  FROM tbx_KeyContractPerson INNER JOIN ";
            sql = sql + "  tbx_TranKeyContract ON tbx_KeyContractPerson.KeyContractPersonID = tbx_TranKeyContract.KeyContractPersonID INNER JOIN ";
            sql = sql + "  tbx_Properties ON dbo.tbx_TranKeyContract.PropID = dbo.tbx_Properties.PropID INNER JOIN ";
            sql = sql + "  tbx_Company ON dbo.tbx_TranKeyContract.CompanyID = dbo.tbx_Company.CompanyID";
            sql = sql + "  WHERE tbx_Company.CompanyName = '" + txtSearch2.Text + "'";

            SqlCommand cmd = new SqlCommand(sql, cn);
            cmd.CommandType = CommandType.Text;
            cn.Open();
            DataTable dt = new DataTable();

            System.Data.Common.DbDataReader dr;
            dr = cmd.ExecuteReader();

            dt.Load(dr);
            return dt;
        }
    }
	}