Introduction:
Description:
In previous post I explained ExecuteScalar Example, ExecuteNonQuery Example and differences between ExecuteNonQuery, ExecuteReader and
ExecuteScalar in asp.net. Now I will explain ExecuteReader concept with one
example in asp.net using C#.net,
VB.NET.
ExecuteReader
Execute
Reader will be used to return the set of rows, on execution of SQL Query or
Stored procedure using command object. This one is forward only retrieval of
records and it is used to read the table values from first to last.
Before implement this example first design one table UserInformation in your database as
shown below
Column Name
|
Data Type
|
Allow Nulls
|
UserName
|
varchar(50)
|
Yes
|
LastName
|
varchar(50)
|
Yes
|
Location
|
Varchar(50)
|
Yes
|
Once table designed in database enter some dummy data
to test after that write the following code in your aspx page
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1"
runat="server">
<title>Example of
ExecuteReader in asp.net</title>
</head>
<body>
<form id="form1"
runat="server">
<div>
<b>Bind Gridview with
ExecuteReader command object Data</b><br /><br />
<asp:GridView ID="gvUserInfo"
runat="server">
<HeaderStyle BackColor="#df5015"
Font-Bold="true"
ForeColor="White"/>
</asp:GridView>
</div>
</form>
</body>
</html>
|
Now add the following namespaces in code behind
C#
Code
using System;
using System.Data.SqlClient;
using System.Data;
|
After add namespaces write the following code in code
behind
protected void Page_Load(object
sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridview();
}
}
// This method is used to bind gridview from database
protected void BindGridview()
{
using (SqlConnection con = new
SqlConnection("Data
Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))
{
con.Open();
SqlCommand cmd = new SqlCommand("Select UserName,LastName,Location FROM
UserInformation", con);
SqlDataReader dr =
cmd.ExecuteReader();
gvUserInfo.DataSource = dr;
gvUserInfo.DataBind();
con.Close();
}
}
|
VB.NET
Code
Imports System.Data.SqlClient
Imports System.Data
Partial Class VBCode
Inherits System.Web.UI.Page
Protected Sub Page_Load(sender As
Object, e As EventArgs) Handles
Me.Load
If Not
IsPostBack Then
End If
End Sub
' This method is used to bind gridview from database
Protected Sub BindGridview()
Using con As New SqlConnection("Data
Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB")
con.Open()
Dim cmd As New SqlCommand("Select
UserName,LastName,Location FROM UserInformation", con)
Dim dr As SqlDataReader
= cmd.ExecuteReader()
gvUserInfo.DataSource = dr
gvUserInfo.DataBind()
con.Close()
End Using
End Sub
End Class
|
Demo
 |
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
10 comments :
Hi suresh my name is praneeth. I learned various concepts from your blog regarding .net where the faculty of my institute(pvt) failed to explain each and every concept clearly. Thank you very much for sharing your knowledge with persons like me and it was helpful to me very much....!
HI Suresh, Your blogs are a really too good. They have proved very helpful to me. Whenever I am stuck somewhere, i refer to ur blogs.
Thank You very much...
It is really good..
it's really very very good suresh.............its superb.....
Really its very good for beginners...
Hi Suresh,
This is regarding post of Execute Data Reader in asp.net. I want to tell you something and also want to know if we use using (sqlconnection con = new sqlconn........)
then we have to open the connection but don't have to close it. Am I right or not ???
Please clearify with explanation.
Hi Suresh , its really good for beginners .............................................. and thanks very much --------------------------------------kumar
you are not even using 3 tier structure and didnt even use parameters... this is a poor example which will create lots of coupling..
Here we are not explaining about 3 tier structure or sending parameter we are explaining about ExecuteReader concept with example to make people understand concept easily....
Thank you sir it is very easy to understand
Note: Only a member of this blog may post a comment.