Create Connection class and call it in webpage

Satyapriya Nayak
Nov 08, 2011

7k
0
2
- facebook
- twitter
- linkedIn
- Reddit
- WhatsApp
- Email
- Bookmark

In this blog we will know how to create a connection class and then how we can call this class in a webpage.

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>

/// Summary description for connection

/// </summary>

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"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

</sectionGroup>

</configSections>

<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>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

Visual Basic options:

Set strict="true" to disallow all data type conversions

where data loss can occur.

Set explicit="true" to force declaration of all variables.

-->

</assemblies>

</compilation>

<pages>

</namespaces>

</controls>

</pages>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

</customErrors>

-->

</httpHandlers>

</httpModules>

</system.web>

<system.codedom>

</compiler>

</compiler>

</compilers>

</system.codedom>

<!--

The system.webServer section is required for running ASP.NET AJAX under Internet

Information Services 7.0. It is not necessary for previous version of IIS.

-->

<system.webServer>

</modules>

</handlers>

</system.webServer>

</dependentAssembly>

</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">

<title>Untitled Page</title>

</head>

<body>

<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();

}

Thanks for reading

Next Recommended Reading ASP.NET How Encrypt Connection Strings Section in Web.Config File