DataReader in ADO.Net

Question

I have a grid view in dot net, and want to show all record in gridview with the help of data reader.

Satyapriya Nayak · Answer

Untitled Page 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(); } } }

Sandeep Singh Shekhawat · Answer

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();

Sivaraman Dhamodaran · Answer

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

Krishna Garad · Answer

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

DataReader in ADO.Net

Answers (4)