SqlCommand cmd;
    static string connString =     System.Web.Configuration.WebConfigurationManager.ConnectionStrings["conn"].ConnectionString;
    DbCommand dbcommand;
    SqlDatabase db = new SqlDatabase(connString);
    public static SqlConnection scon = new SqlConnection(connString);





 #region Connection function
    public void CreateConnection()
    {
        if (scon.State != ConnectionState.Open)
        {
            scon.Open();
        }
    }
    public void CloseConnection()
    {
        scon.Close();
    }
    #endregion





 #region Common Function
    public DataSet GetDataSet(string SQL)
    {
        DataSet dsInv = new DataSet();
        dbcommand = db.GetSqlStringCommand(SQL);
        dsInv = db.ExecuteDataSet(dbcommand);

        return dsInv;
    }
    public DataTable GetDataTable(string SQL)
    {
        DataTable dtInv = new DataTable();
        dbcommand = db.GetSqlStringCommand(SQL);
        ds = db.ExecuteDataSet(dbcommand);
        if (ds.Tables.Count > 0)
        {
            dtInv = ds.Tables[0];
        }
        return dtInv;
    }




 public int ExecuteQuery(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = db.ExecuteNonQuery(dbcommand);
        return Retval;
    }
    public int ExecuteScalar(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
        return Retval;
    }
    public int ExecuteIntScalar(string qur)
    {
        int Retval = 0;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToInt32(db.ExecuteScalar(dbcommand));
        return Retval;
    }
    public string ExecuteStringScalar(string qur)
    {
        string Retval = string.Empty;
        dbcommand = db.GetSqlStringCommand(qur);
        Retval = Convert.ToString(db.ExecuteScalar(dbcommand));
        return Retval;
    }



 <add name="conn" connectionString="Data Source=; Initial Catalog=;User ID=;Password=;MultipleActiveResultSets=True;Connect TimeOut=100000;Pooling=true;Max Pool Size=250;Min Pool Size=100;"/>

Read More

Data table Class Table Shorting

 protected void GridView1_PreRender(object sender, EventArgs e)
    {
        dtInv = objDataAccess.GetDataTable("select * from tbl_fin_Customerregistration");
        GridView1.DataSource = dtInv;  //GetData is your method that you will use to obtain the data you're populating the GridView with

        GridView1.DataBind();

        if (GridView1.Rows.Count > 0)
        {
            //Replace the <td> with <th> and adds the scope attribute
            GridView1.UseAccessibleHeader = true;

            //Adds the <thead> and <tbody> elements required for DataTables to work
            GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;

            //Adds the <tfoot> element required for DataTables to work
            GridView1.FooterRow.TableSection = TableRowSection.TableFooter;
        }

    }


                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" width="100%" CssClass="table table-striped table-bordered table-hover gvv" OnPreRender="GridView1_PreRender" >
                        </asp:GridView>





 <script language="javascript" type="text/jscript">
        $(document).ready(function () {
            $('#dataTables-example').DataTable({
                responsive: true,
                "lengthMenu": [[10, 25, 50, 100, 500, 1000, 1000000], [10, 25, 50, 100, 500, 1000, "All"]]
            });
        });
        $(document).ready(function () {
            $('.gvv').DataTable({
                responsive: true,
            "lengthMenu": [[10, 25, 50, 100, 500, 1000, 1000000], [10, 25, 50, 100, 500, 1000, "All"]]
            });
        });
    </script>

Read More

List Spand

<script>    
 $(function () {
          var pgurl = window.location.href.substr(window.location.href.lastIndexOf("/") + 1);

          $("ul li a").each(function () {

              if ($(this).attr("href") == pgurl) {
                  //alert(pgurl);

                  $(this).parent().addClass("active");
                  //$(this).parent().find('li').addClass("active");
                  // $(this).addClass("active");
                  $(this).parent().parent().parent().addClass("active");
                  $(this).parent().parent().parent().parent().parent().addClass("active");
                  //alert($(this).parent().parent().parent().find('li').addClass("active");
              }
          })
      });

  
   </script>

Read More