BL - method calling:

 class Register
    {
        public string Name
        {
            get;
            set;
        }
        public string Age
        {
            get;
            set;
        }
        public string Address
        {
            get;
            set;
        }
       
        public string Gender
        {
            get;
            set;
        }
        public string City
        {
            get;
            set;
        }
        public string Pin
        {
            get;
            set;
        }
        public string MobileNum
        {
            get;
            set;
        }
        public string State
        {
            get;
            set;
        }
        public string Country
        {
            get;
            set;
        }
        public string Email
        {
            get;
            set;
        }
       
        public int SaveToRegister()
        {
            SqlDb db = new SqlDb();
            StringBuilder strb = new StringBuilder();
            strb.Append("Insert into RegisterDetails (Name,Age,Address,Gender,City,Pin,MobileNum,State,Country,Email) values(");
            strb.Append("'" + Name + "',");
            strb.Append("'" + Age + "',");
            strb.Append("'" + Address + "',");
            strb.Append("'" + Gender + "',");
            strb.Append("'"+City+"',");
            strb.Append("'"+Pin+"',");
            strb.Append("'"+MobileNum+"',");
            strb.Append("'" + State + "',");
            strb.Append("'"+Country+"',");
            strb.Append("'"+Email+"')");
            int reg = db.ExecuteNonQry(strb.ToString());
            strb.Remove(0, strb.Length);
            return reg;
        }
        public string Username
        {
            get;
            set;
        }
        public string Password
        {
            get;
            set;
        }
        public int CreateUser()
        {
            SqlDb db = new SqlDb();
            StringBuilder strb = new StringBuilder();
            strb.Append("insert into LoginPage (Username,Password) values(");
            strb.Append("'"+Username+"',");
            strb.Append("'"+Password+"')");
            int re = db.ExecuteNonQry(strb.ToString());
            strb.Remove(0, strb.Length);
            return re;
         }

        public DataTable viewRecords()
        {
            SqlDb db = new SqlDb();
            StringBuilder strb = new StringBuilder();
            strb.Append("Select * from RegisterDetails");
            DataTable dt = new DataTable();
            dt = db.GetTable(strb.ToString());
            return dt;

        }
        public DataTable GetId()
        {
            SqlDb sqdb = new SqlDb();
            String str = "";
            str = "Select Id from RegisterDetails";
            DataTable dt = sqdb.GetTable(str.ToString());
            return dt;
        }

        public DataTable GetName()
        {
            SqlDb sqdb = new SqlDb();
            String str = "";
            str = "select Name,Id from RegisterDetails";
            DataTable dt = sqdb.GetTable(str.ToString());
            return dt;
        }
        public DataTable ViewSelectedRecords(int id)
        {
            SqlDb db = new SqlDb();
            StringBuilder strb = new StringBuilder();
            strb.Append(" Select * from RegisterDetails where Id='"+id+"'");
            DataTable dt = new DataTable();
            dt = db.GetTable(strb.ToString());
            return dt;
        }
      
        public int DeleteRecords(int id)
        {
            SqlDb db = new SqlDb();
            String str = "";
            str = "Delete from RegisterDetails where Id='"+id+"'";
            int rs = db.ExecuteNonQry(str.ToString());
            return rs;
        }     
        public int UpdateRecords(int id)
        {
            SqlDb  sqdb = new SqlDb();
            string strb = "";
            strb = "update RegisterDetails set Name='" + Name + "',Age='" + Age + "',Address='" + Address + "',Gender='" + Gender + "',City='"+City+"',Pin='"+Pin+"',MobileNum='"+MobileNum+"',State='"+State+"',Country='"+Country+"',Email='"+Email+"'  where Id='" + id + "'";
            int rs = sqdb.ExecuteNonQry(strb.ToString());
            return rs;
        }
    }
    
    }