ASP Dot NET Online Training Services by Quontra Solutions: How to use DataReader in ASP.NET

Tuesday, 29 July 2014

DataReader example: how to use DataReader in asp.net

<%@ Page Language=“C#” %>
<%@ Import Namespace=“System.Data” %>
<%@ Import Namespace=“System.Data.SqlClient” %>
<%@ Import Namespace=“System.Configuration” %>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<script runat=“server”>
protected void Page_Load(object sender, System.EventArgs e) {
if (!Page.IsPostBack) {
SqlConnection MyConnection;
SqlCommand MyCommand;
SqlDataReader MyReader;
MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["AppConnectionString1"].ConnectionString;
MyCommand = new SqlCommand();
MyCommand.CommandText = “SELECT TOP 10 * From PRODUCTS”;
MyCommand.CommandType = CommandType.Text;
MyCommand.Connection = MyConnection;
MyCommand.Connection.Open();
MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);
GridView1.DataSource = MyReader;
GridView1.DataBind();
MyCommand.Dispose();
MyConnection.Dispose();
}
}
</script>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head runat=“server”>
<title>DataReader example: how to use DataReader in asp.net</title>
</head>
<body>
<form id=“form1″ runat=“server”>
<div>
<asp:GridView ID=“GridView1″ runat=“server”>
</asp:GridView>
</div>
</form>
</body>
</html>

ASP Dot NET Online Training Services by Quontra Solutions