webformaspx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace Test_1
{
    public class Ado_Dot_Net_Class
    {
        SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
        static SqlConnection con = new SqlConnection("server=DESKTOP-VH35VBK; database=TestProjectDB; integrated security=true");
           
        public static string getName
        {
            get;
            set;
        }
        public static string getAge
        {
            get;
            set;
        }
        public static string getGender
        {
            get;
            set;
        }
        public static string getProfession
        {
            get;
            set;
        }
        public static int getId
        {
            get;
            set;
        }

        public static void Insert_into_tbl(string query, SqlParameter[] prm)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = query;
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddRange(prm);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
       
        }

        public static void insert_into_std()
        {
            SqlParameter[] prm = new SqlParameter[4];
            prm[0] = new SqlParameter("@name", getName);
            prm[1] = new SqlParameter("@age", getAge);
            prm[2] = new SqlParameter("@gender", getGender);
            prm[3] = new SqlParameter("@profession", getProfession);

            //SqlCommand cmd = new SqlCommand("Insert_Into_Std_info", con);
            //cmd.CommandType = CommandType.StoredProcedure;
            //cmd.Parameters.AddRange(prm);
            //con.Open();
            //cmd.ExecuteNonQuery();
            //con.Close();

            Insert_into_tbl("Insert_into_std_info", prm);

        }

        public static void insert_into_srv()
        {
            //SqlParameter[] prm = new SqlParameter[4];
            //prm[0] = new SqlParameter("@name", getName);
            //prm[1] = new SqlParameter("@age", getAge);
            //prm[2] = new SqlParameter("@gender", getGender);
            //prm[3] = new SqlParameter("@profession", getProfession);

            string query = "insert into dbo.SRV_info (name,age,profession,gender) values (@name,@age,@profession,@gender)";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.Parameters.AddWithValue("@name", getName);
            cmd.Parameters.AddWithValue("@age", getAge);
            cmd.Parameters.AddWithValue("@profession", getProfession);
            cmd.Parameters.AddWithValue("@gender", getGender);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }

        public static void insert_into_bsn()
        {
            SqlParameter[] prm = new SqlParameter[4];
            prm[0] = new SqlParameter("@name", getName);
            prm[1] = new SqlParameter("@age", getAge);
            prm[2] = new SqlParameter("@gender", getGender);
            prm[3] = new SqlParameter("@profession", getProfession);

            //SqlCommand cmd = new SqlCommand("Insert_Into_Bsn_info", con);
            //cmd.CommandType = CommandType.StoredProcedure;
            //cmd.Parameters.AddRange(prm);
            //con.Open();
            //cmd.ExecuteNonQuery();
            //con.Close();

            Insert_into_tbl("Insert_into_Bsn_info", prm);
        }

        public static DataSet bind_Grid(string ProcedureName)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = ProcedureName;
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            //con.Open();
            da.Fill(ds);
            //con.Close();

            return ds;
            //DataTable dt = new DataTable();
            //for (int j = 0; j < GridView1.Rows.Count; j++)
            //{
            //    DataRow dr;
            //    GridViewRow row = GridView1.Rows[j];
            //    dr = dt.NewRow();
            //    for (int i = 0; i < row.Cells.Count; i++)
            //    {
            //        dr[i] = row.Cells[i].Text;
            //    }

            //    dt.Rows.Add(dr);
            //}
          

        }

        public static DataSet Std_info_Bind()
        {
            return bind_Grid("Show_in_grid_Std_nfo");
        }

        public static DataSet Srv_info_Bind()
        {
            return bind_Grid("Show_in_grid_Srv_nfo");
        }

        public static DataSet Bsn_info_Bind()
        {
            return bind_Grid("Show_in_grid_Bsn_nfo");
        }

        public static void UpdateIntoStd()
        {
            SqlParameter[] prm = new SqlParameter[5];
            prm[0] = new SqlParameter("@id", getId);
            prm[1] = new SqlParameter("@name", getName);
            prm[2] = new SqlParameter("@age", getAge);
            prm[3] = new SqlParameter("@gender", getGender);
            prm[4] = new SqlParameter("@profession", getProfession);
            Insert_into_tbl("Update_std_info", prm);

        }

        public static void UpdateIntoSrv()
        {
            SqlParameter[] prm = new SqlParameter[5];
            prm[0] = new SqlParameter("@id", getId);
            prm[1] = new SqlParameter("@name", getName);
            prm[2] = new SqlParameter("@age", getAge);
            prm[3] = new SqlParameter("@gender", getGender);
            prm[4] = new SqlParameter("@profession", getProfession);
            Insert_into_tbl("Update_srv_info", prm);

        }

        public static void UpdateIntoBsn()
        {
            SqlParameter[] prm = new SqlParameter[5];
            prm[0] = new SqlParameter("@id", getId);
            prm[1] = new SqlParameter("@name", getName);
            prm[2] = new SqlParameter("@age", getAge);
            prm[3] = new SqlParameter("@gender", getGender);
            prm[4] = new SqlParameter("@profession", getProfession);
            Insert_into_tbl("Update_bsn_info", prm);

        }

        public static void DeleteFromSrv()
        {
            SqlParameter[] prm = new SqlParameter[1];
            prm[0] = new SqlParameter("@id", getId);
            Insert_into_tbl("DeleteFromSrv", prm);

        }

        public static void DeleteFromStd()
        {
            SqlParameter[] prm = new SqlParameter[1];
            prm[0] = new SqlParameter("@id", getId);
            Insert_into_tbl("DeleteFromStd", prm);

        }

        public static void DeleteFromBsn()
        {
            SqlParameter[] prm = new SqlParameter[1];
            prm[0] = new SqlParameter("@id", getId);
            Insert_into_tbl("DeleteFromBsn", prm);

        }
    }
}