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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)