WHAT IS THE DIFFERENCE BETWEEN DATA SET AND DATA READER.

=> Data reader provides forward only and read-only access to data while the dataset object can hold more than one table ( In other words more than one row set ) from the same data source as well as the relationships between them.

=> Dataset is a disconnected architecture while data reader is connected architecture. 

=> Dataset can persist contents while data reader can't persist contents they are forward only.

DataAdapter :-

DataAdapter will acts as a Bridge between DataSet and database. This dataadapter object is used to read the data from database and bind that data to dataset. Dataadapter is a disconnected oriented architecture

Data Reader Example :- 

Protected void BindGridview()
{
using (SqlConnection conn = new SqlConnection("Data Source=abc;Integrated Security=true;Initial Catalog=Test"))
{
con.Open();
SqlCommand cmd = new SqlCommand("Select UserName, First Name,LastName,Location FROM Users", conn);
SqlDataReader sdr = cmd.ExecuteReader();
gvUserInfo.DataSource = sdr;
gvUserInfo.DataBind();
conn.Close();
}
}

Dataset Example :-

protected void BindGridview()

{

    SqlConnection conn = new SqlConnection("Data Source=abc;Integrated Security=true;Initial Catalog=Test");

    conn.Open();

    SqlCommand cmd = new SqlCommand("Select UserName, First Name,LastName,Location FROM Users", conn);

    SqlDataAdapter sda = new SqlDataAdapter(cmd);

    DataSet ds = new DataSet();

    da.Fill(ds);

    gvUserInfo.DataSource = ds;

    gvUserInfo.DataBind();

}

Share

& Comment

Tweet