To Connecting the Database to Gridview Using Ado.net example

In Aspx.cs page 

 ------------------------------

 

string connectionString = ConfigurationManager.ConnectionStrings["DropDownListConnectionString"].ConnectionString;

    

    protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection(connectionString);

        con.Open();

        SqlDataReader rd;

        SqlCommand cmd = new SqlCommand("Select * from ddlist", con);

        rd = cmd.ExecuteReader();

        GridView1.DataSource = rd;

        GridView1.DataBind();

        rd.Close();

        con.Close();

    }

 

 

In Aspx page

------------------------ 

  <asp:GridView ID="GridView1" runat="server"> 

 

in web.config

 --------------------------------

<connectionStrings>

  <add name="DropDownListConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&quot;C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DropDownList.mdf&quot;;Integrated Security=True;Connect Timeout=30;User Instance=True"

   providerName="System.Data.SqlClient" />

  

 </connectionStrings>