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 =  GETHEAD  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 =  GETHEAD  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:Calibrisans-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;}