DataReader in ADO.Net

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Gridview_reader._Default" %>

using System; using System.Collections; 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; namespace Gridview_reader { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); str = "Select * from employee"; com = new SqlCommand(str, con); con.Open(); SqlDataReader reader; reader = com.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); reader.Close(); con.Close(); } } }

                SqlConnection con = new SqlConnection(constring);

                 SqlCommand cmd = new SqlCommand("_sp_GetEmployee", con);

                 cmd.CommandType = CommandType.StoredProcedure;

                con.Open();

                IDataReader idr = cmd.ExecuteReader();               

                grdEmployee.DataSource = idr;

                grdEmployee.DataBind();

 

Please refer this link. I hope you will get the answer.

Use the collection for example create the List fill this list from datareader and then bind it to grid