connection.cs file

 

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

///

/// Summary description for connection

///

public class connection

{

 

    static string my_connection1 = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    static SqlConnection my_connection = null;

    public static SqlConnection get()

    {

        if (my_connection == null)

        {

 

            my_connection = new SqlConnection(my_connection1);

 

            my_connection.Open();

 

        }

        return my_connection;

    }

}

 

web.config file

 

xml version="1.0"?>

<configuration>

      <configSections>

            <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

                  <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

                        <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

                        <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

                              <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>

                              <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

                              <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

                              <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

                        sectionGroup>

                  sectionGroup>

            sectionGroup>

      configSections>

      <appSettings/>

      <connectionStrings>

            <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\emp.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

      connectionStrings>

      <system.web>

           

            <compilation debug="true" strict="false" explicit="true">

                  <assemblies>

                        <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

                        <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                        <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

                        <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

                  assemblies>

            compilation>

            <pages>

                  <namespaces>

                        <clear/>

                        <add namespace="System"/>

                        <add namespace="System.Collections"/>

                        <add namespace="System.Collections.Generic"/>

                        <add namespace="System.Collections.Specialized"/>

                        <add namespace="System.Configuration"/>

                        <add namespace="System.Text"/>

                        <add namespace="System.Text.RegularExpressions"/>

                        <add namespace="System.Linq"/>

                        <add namespace="System.Xml.Linq"/>

                        <add namespace="System.Web"/>

                        <add namespace="System.Web.Caching"/>

                        <add namespace="System.Web.SessionState"/>

                        <add namespace="System.Web.Security"/>

                        <add namespace="System.Web.Profile"/>

                        <add namespace="System.Web.UI"/>

                        <add namespace="System.Web.UI.WebControls"/>

                        <add namespace="System.Web.UI.WebControls.WebParts"/>

                        <add namespace="System.Web.UI.HtmlControls"/>

                  namespaces>

                  <controls>

                        <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                        <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                  controls>

            pages>

           

            <authentication mode="Windows"/>

           

            <httpHandlers>

                  <remove verb="*" path="*.asmx"/>

                  <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                  <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                  <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>

            httpHandlers>

            <httpModules>

                  <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

            httpModules>

      system.web>

      <system.codedom>

            <compilers>

                  <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

                        <providerOption name="CompilerVersion" value="v3.5"/>

                        <providerOption name="WarnAsError" value="false"/>

                  compiler>

                  <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

                        <providerOption name="CompilerVersion" value="v3.5"/>

                        <providerOption name="OptionInfer" value="true"/>

                        <providerOption name="WarnAsError" value="false"/>

                  compiler>

            compilers>

      system.codedom>

     

      <system.webServer>

            <validation validateIntegratedModeConfiguration="false"/>

            <modules>

                  <remove name="ScriptModule"/>

                  <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

            modules>

            <handlers>

                  <remove name="WebServiceHandlerFactory-Integrated"/>

                  <remove name="ScriptHandlerFactory"/>

                  <remove name="ScriptHandlerFactoryAppServices"/>

                  <remove name="ScriptResource"/>

                  <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                  <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

                  <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

            handlers>

      system.webServer>

      <runtime>

            <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

                  <dependentAssembly>

                        <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>

                        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

                  dependentAssembly>

                  <dependentAssembly>

                        <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>

                        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

                  dependentAssembly>

            assemblyBinding>

      runtime>

configuration>

 

 

 

How to call the connection.cs class in a given program

 

 

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

 

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Pagetitle>

head>

<body>

    <form id="form1" runat="server">

     <asp:GridView ID="GridView1" runat="server">

     asp:GridView>

    form>

body>

html>

 

 

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            bindgrid();

        }

    }

    public void bindgrid()

    {

        SqlCommand com = new SqlCommand("select * from employee", connection.get());

        SqlDataAdapter sqlda = new SqlDataAdapter(com);

        DataSet ds = new DataSet();

        sqlda.SelectCommand = com;

        sqlda.Fill(ds, "employee");

        GridView1.DataSource = ds;

        GridView1.DataMember = "employee";

        GridView1.DataBind();

       

    }

   

}