Connection string in Web.config

 

Connection string in Web.config 

GridView Control Use in .aspx webpage-

<![if !vml]><![endif]> GridView Control

<asp:GridView ID="GridView1" runat="server" Height="270px" Width="524px"

          BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"

          CellPadding="4" >

          <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />

          <RowStyle BackColor="White" ForeColor="#003399" />

          <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />

          <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />

          <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />

        </asp:GridView>

Create Database using MS SQL Server2005/2008. Then create table in sql and save it, Now connect database to our website, Using Server Explorer copy the connection sting path and add connection string tag in web.config file 

First Open Web.Config file

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

// Now Add <connectionStrings> tag in web config file

      <connectionStrings>

          <add name="DatabaseConnectionString1" 

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" 

providerName="System.Data.SqlClient"/>

      

</connectionStrings>

Now Apply code in .cs file as follows-

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

{

    SqlConnection cn = new SqlConnection();

    SqlCommand cmd = new SqlCommand();

   

cn.ConnectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString1"].ConnectionString.ToString();

    protected void Page_Load(object sender, EventArgs e)

    {   // Create Connection Object

        SqlConnection cn = new SqlConnection();

        


// Apply code in single line here- 

    // Now Open Connection

      cn.Open();

        SqlCommand cmd = new SqlCommand("SELECT eid AS EmployeeId , ename AS EmployeeName FROM employee ORDER BY eid", cn);

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();

      da.Fill(ds);

      GridView1.DataSource = ds;

      GridView1.DataBind();

         

       

    }