How to retrive data from database to asp.net page

Hi Arvind,

Accessing Database Data

ASP.NET 2.0 provides two Data Source controls designed specifically to access data from a database:

• SqlDataSource - useful for accessing data from any database that resides in a relational database. The "Sql" in the control name does not refer to Microsoft SQL Server, but rather the SQL syntax for querying relational databases, for the SqlDataSource control can be used to access not only Microsoft SQL Server databases, but Microsoft Access databases, Oracle databases... basically any OLE-DB or ODBC-compliant data store.
• AccessDataSource - the AccessDataSource is very similar to the SqlDataSource. The key difference is that instead of requiring a connection string to the database, the AccessDataSource control allows you to simply specify the file path to the Access .MDB file through its DataFile property.

Both controls have virtually the same featureset, the only difference being how you specify the connection information. In fact, the AccessDataSource control is really superfluous since Microsoft Access databases can be accessed through the SqlDataSource control just as easily. (True, you have to provide a connection string rather than simply the path to the file, but Visual Studio 2005 can automatically create appropriate connection strings for those databases residing in your App_Data folder.)
How to do with example read here:
http://www.4guysfromrolla.com/articles/022206-1.aspx

Hi Arvind,

Here Data will be displayed in a Gridview from the database.


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
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlDataAdapter ad = new SqlDataAdapter();
    SqlCommand cmd = new SqlCommand();
    SqlDataAdapter sqlda;
    DataSet ds;
    string str;


  protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        SqlConnection conn = new SqlConnection(connStr);
        conn.Open();
        str = "select * from Contacts";
        cmd = new SqlCommand(str, conn);
        sqlda = new SqlDataAdapter(cmd);
        ds = new DataSet();
        sqlda.Fill(ds, "Contacts");
        conn.Close();
        GridView1.DataSource = ds;
        GridView1.DataMember = "Contacts";
        GridView1.DataBind();
        }
    }
   
  
    }



Thanks