Earliar posts i explained how to bind data to grid view, bind data to dropdownlist in grid view, Export Gridview Data to Word Document, Sorting and Paging in Gridview, Edit,Delete,Update in Gridview.Here i will show how to bind data to grid view using Data reader in asp.net
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Bind data to Gridview with DataReader in asp.net</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="GVdynamicdr" runat="server" AutoGenerateColumns="False"
>
<Columns>
<asp:BoundField DataField="drOrderID" HeaderText="drOrderID"/>
<asp:BoundField DataField="OrderName" HeaderText="drOrderName"/>
<asp:BoundField DataField="drPhone" HeaderText="drPhone"/>
<asp:BoundField DataField="drAddress" HeaderText="drAddress"/>
<asp:BoundField DataField="drAmount" HeaderText="drAmount"/>
</Columns>
</asp:GridView>
</form>
</body>
</html>
CodeBehind:
using System;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data...
Read Full Story
