Progress Monitor for IdealProgrammer.com

Take Swift, Intelligent, Massive, Planned, Loving, Effective (S.I.M.P.L.E.) Action to Transform Self into Ideal

Skip Repetitive Navigational Links

Home

News

Presenters

Contact

Please login

C# ASP.NET ConfigurationManager ConnectionString Source Code Example

Description: Illustrates using Configuration Manager to retrieve connection string from web.config file in C# ASP.NET. The configuration manager can be used to do many things with regard to configuration, but this example just illustrates retrieving the connection string.

Example Webform Code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ConfigurationMgrConnectionString.aspx.cs" Inherits="Configuration_ConfigurationMgrConnectionString" %>
 
<!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 id="Head1" runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>

Example Code Behind:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
partial class Configuration_ConfigurationMgrConnectionString : System.Web.UI.Page
{
 
	protected void  // ERROR: Handles clauses are not supported in C#
Page_Load(object sender, System.EventArgs e)
	{
		SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Northwind_ConnectionString"].ConnectionString);
 
		// Create the command object
		string str = "SELECT EmployeeID, FirstName, LastName FROM Employees";
		SqlCommand cmd = new SqlCommand(str, con);
 
 
		SqlDataAdapter da = new SqlDataAdapter(cmd);
 
		DataSet ds = new DataSet();
 
		da.Fill(ds, "Employees");
		GridView1.DataSource = ds;
		GridView1.DataBind();
 
	}
}

Example Connection String:

<connectionStrings>
    <add name="Northwind_ConnectionString"
      connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" />
  </connectionStrings>