ASP.net -how to use class file for connection in C#?

Question

how to use class file for connection in C#?

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 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 " ?> 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 --> 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 > 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. --> 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 > The section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> authentication mode = " Windows " /> The 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. --> 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 > 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 > 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 Page title > 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(); } } /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}