Advertisement
In this article I will explain how to bind grid view using
data reader in asp.net
I am creating a table in sqlserver as shown
USE [dotnetdb]
GO
/******
Object: Table [dbo].[Employee] Script Date: 10/27/2013 14:36:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employee](
[EmpId] [nvarchar](50) NOT NULL,
[EmpName] [nvarchar](50) NOT NULL,
[EmpAddress] [nvarchar](50) NOT NULL,
[EmpDesignation] [nvarchar](50) NULL
) ON [PRIMARY]
GO
I created a webform with name EmpInfo.aspx
<%@ Page Language="C#"
AutoEventWireup="true" CodeBehind="EmpInfo.aspx.cs"
Inherits="BindGrid.EmpInfo" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form
id="form1" runat="server">
<div>
<asp:GridView
ID = "gridview" runat = "server" AutoGenerateColumns =
"false" >
<Columns>
<asp:BoundField
DataField = "EmpId" HeaderText = "EmpId" />
<asp:BoundField
DataField = "EmpName" HeaderText = "EmpName" />
<asp:BoundField
DataField = "EmpAddress" HeaderText = "EmpAddress" />
<asp:BoundField
DataField = "EmpDesignation" HeaderText = "EmpDesignation"
/>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
In EmpInfo.aspx.cs I am writing the logic to display data in
gridview.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
namespace BindGrid
{
public partial class EmpInfo :
System.Web.UI.Page
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["dotnetdbConnectionString"].ToString());
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindGrid();
}
}
public void
bindGrid()
{
SqlCommand cmd = new
SqlCommand("select
* from Employee",con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
gridview.DataSource = dr;
gridview.DataBind();
con.Close();
}
}
}
}
In web.config I am adding the connecting string
<connectionStrings>
<add name="dotnetdbConnectionString" connectionString="Data
Source=CHINNU;Initial Catalog=dotnetdb;User ID=sa;Password=password123" providerName="System.Data.SqlClient" />
</connectionStrings>
Finally press F5 we can get the out put as shown.
Advertisements
Thanks for that.Your sharing for this technologies information is excellent.
ReplyDeletePython Training in Chennai
I am creating an application for a asp.net class that I am taking. ... The approach I have taken (as we learned in class) was to get the query results via the SqlDataReader and bind it to a GridView. .... UI; using System.Web.UI.WebControls; using System.Data.SqlClient; public partial class ....
ReplyDeleteGood Article.. PHP Training in Chennai
ReplyDeleteThis information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
ReplyDeleteRegards,
Angularjs training in chennai|Node JS training|Python Training in Chennai
Nice post. Thanks for sharing. . QTP Training in Chennai | Software Testing Training in Chennai
ReplyDeleteExcellant content. To know the details and importance of python course visit below. Python is an object oriented high level programming language which is built in data structures combined with dynamic typing and dynamic binding making it very attractive for rapid application development.
ReplyDeletePython Training in Chennai | Python Course in Chennai
very nice article
ReplyDeletehttp://hadooptraininginhyderabad.co.in/salesforce-training-in-hyderabad/
nice posats..
ReplyDeleteSAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works. Among the five certification programs that SAS Institute has come up with, SAS training can be considered as the entry point into the big data and the data analytics industry.
SAS online training in hyderabad
Thanks for sharing such an informative post. J2EE Training | Mainframe Training | SQL Server DBA Training
ReplyDeletebind grid using data reader nice posts..
ReplyDeleteHadoop online training .All the basic and get the full knowledge of hadoop.
hadoop online training
dontnet is simple and effective programming language ,you mentioned a great points in the article online microstrategy training
ReplyDeletenice and really helpful article to everyone... thanks for sharing
ReplyDeleteselenium training in chennai | selenium training institute in chennai | Android training in chennai | android training institute in chennai
100% Job Oriented R Programming for more Information click to
ReplyDeletedatastage training in chennai
I gathered some needful information through your blog. Big Data Training | Oracle DBA Online Training | SQL Server DBA Online Training
ReplyDeleteExcellent post!!!.
ReplyDeleteoracle training in chennai
Thanks for sharing.........
ReplyDeleteinformatica training in chennai
Nice .| ONLINE TRAINING | A chef's standard uniform for a chef includes a hat called a toque, necktie .| Chef Online Training | OpenStack Online Training
ReplyDeleteWonderful article. Thanks for sharing.
ReplyDeleteweb design training institute in Chennai
Professional Expert level Android Training in chennai, Android App Development
ReplyDeleteAndroid Training | Android App Development | Training in chennaiProfessional Expert level Android Training in chennai, Android App Development
Android Training | Android App Development | Training in chennai
CREDO SYSTEMZ provides best software training in Chennai which includes all the latest technologies too such as ANDROID TRAINING, SELENIUM TRAINING, HADOOP TRAINING, BIGDATA TRAINING, SOFTWARE TESTING TRAINING
ReplyDeletenice and useful post.
ReplyDeleteC-Net training in chennai
good one.... thanks for sharing
ReplyDeletejava j2ee training course contents | java j2ee training institutes in chennai | java j2ee training | java training in chennai velachery
Nice blog. If anyone interested to learn SAS Training visits GangBoard. We are the best provider of SAS Online Training | Data Science with R Training | Data Science with Python Training | Hadoop Training
ReplyDeleteThanks for sharing such a interesting Post..
ReplyDeleteAndroid Training Institute in Chennai |Android Training with Placement in Chennai | Android Training in Chennai
This is the best TIME to lead your bright future..........................| Dot Net Training in Chennai
ReplyDeleteDot Net in IT Field
Hi, I'm really happy well and it's we have found this very fascinating useful web page.We written that the very good manner. Selenium Training in Chennai | Selenium Training in Velachery
ReplyDeleteThanks for sharing this information and keep updating us regularly. This information is really useful to me.
ReplyDeletePHP Training in Chennai | PHP Course in Chennai | PHP Training institute in Chennai
Fantastic article... thanks for your information.... it is very useful to me to learn, keep rocks and updating...
ReplyDeleteDot Net Training in chennai | Dot Net Training institute in chennai
Thank for posting this useful Post..
ReplyDeleteSix Sigma Certification Training in Chennai | Six Sigma Exam Center in Chennai | Six Sigma Green Belt Training in Chennai
Thanks for sharing your wonderful post..keep updating..
ReplyDeleteIOS Training Institute in Chennai | No.1 IOS Developer Training in Chennai | Best IOS Training in Chennai | Online IOS Training in Chennai
I am happy to read your post..Thank you for updating such a wonderful post..IEEE Project Center in Chennai | IEEE Project Center in Velachery
ReplyDeleteHi, am a big follower of your blog. I am really happy to found such a helpful and fascinating post that is written in well manner.
ReplyDeletewhite label website builder
The actual time and effort taken to create this wonderful article were really great, thanks much for sharing the useful content...
ReplyDeleteBest Online Software Training Institute | Data Science Training
Really great blog, it's very helpful and has great knowledgeable information.
ReplyDeleteBest Digital Transformation Services | Austere Technology Solutions
Nice blog with excellent information. Thank you, keep sharing.
ReplyDeleteBest Cloud Solutions | Austere Technologies
Really great blog, it's very helpful and has great knowledgeable information.
ReplyDeleteBest Software Security Services | Austere Technology
Wow...What an excellent informative blog, really helpful. Thank you.
ReplyDeleteBest Software Services Company | Austere Technology
Great work. Quite a useful post, I learned some new points here.I wish you luck as you continue to follow that passion.
ReplyDeleteMobile Apps Training
Excellent informative blog, keep for sharing.
ReplyDeleteBest System Integration services | Massil Technologies
Nice..Its informative...Its very useful for me to understand..Keep on sharing..
ReplyDeleteSee more:Data Science Online Training
This comment has been removed by the author.
ReplyDeleteHey, would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would enjoy your content. Please let me know. Thank you.
ReplyDeleteAutomation anywhere Training in Chennai | Best Automation anywhere Training in Chennai
uipath training in chennai | Best uipath training in chennai
Blueprism Training in Chennai | Best Blueprism Training in Chennai
Rprogramming Training in Chennai | Best Rprogramming Training in Chennai
Machine Learning training in chennai | Best Machine Learning training in chennai
Machine Learning Training in Chennai | Machine Learning Training Institute in Chennai
Devops Training in Chennai | Devops Training Institute in Chennai
Data Science Training in Chennai | Data Science Course in Chennai
Selenium Training in Chennai | Selenium Training Institute in Chennai
https://www.google.com/recaptcha/api2/payload?p=06AOLTBLS62nOsdDNU4Uk-KhJcvNqrfPJtvBByyNR2r6B0bsD7TSJehhB2f4CbYjRDS7Qp3-kl2a_6GSfFm8_jmBmoh3OxHxyeu_wQlYAU_S8ielOCgCu3L8dWRzSczmV0jmipLSbH6Bd2kdK4vZAbYpPE8NnHWTG68wcgljJ7E-bT48-nWjQQteE&k=6LdyZ_4SAAAAAKirYQFAvI_BEKsYyTQLdCegE8Ah&id=2
ReplyDeleteYour Blog is really awesome with useful information and informative article.Thanks for sharing such a wonderful and excellent post with us.keep updating such a amazing post..
ReplyDeleteISTQB Certification Training Center in Chennai | ISTQB Certification Exams in Velachery | ISTQB Certification Training in Velachery | ISTQB Certification Exams in Madipakkam
Thanks for sharing your wonderful and very useful information.keep updating such a impressive and attractive blog with interesting content.
ReplyDeleteJava Training in Chennai | Java Training in Velachery | Java Training Center in Medvakkam | Java Training in Pallikaranai | Java Courses in Chennai | Java Online Training in Guindy
Good article!!! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
ReplyDeleteBest UI Path Training Institute in Chennai | Best UI Path Training in Velachery | Best UI Path Certification Training in Pallikaranai
your Blog is really useful for me,its really very interesting and informative information post.keep updating such an amazing post.
ReplyDeleteLinux Certification Training in Chennai | Linux Training Institute in Chennai | Linux Training Center in Adayar | Best Linux Training in Pallikaranai
Your Blog is really amazing,its really useful for me and informative content with helpful information.keep updating such a wonderful post..
ReplyDeleteTally ERP9 Training in Chennai | Best Tally Training in Chennai | Tally Training Center in Pallikaranai | No.1 Tally ERP9 with GST Courses in Velachery
Very informative blog. Helps to gain knowledge about new concepts and techniques.Thanks a lot for sharing this wonderful blog.keep updating such a excellent post..
ReplyDeleteBest PCB Design Training in Chennai | No.1 PCB Design Course in Velachery | Best PCB Training in Chennai
Thanks for sharing this information,this is helpful to me a lot...It is amazing and wonderful to visit your site.
ReplyDeleteWeb Designing Training Institute in Chennai | Web designing Training in Velachery | Web Design Training Center in Velachery
This is a great inspiring article.I am pretty much pleased with your good work. You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post..
ReplyDeleteBest ISTQB Certification Training in Chennai | No.1 ISTQB Certification Training Center in Chennai | ISTQB Certification Exam Center in Velachery | ISTQB Certification Training in Saidapet
It is awesome and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeletePCB Design Training Institute in Chennai | PCB Designing Training in Velachery | PCB Design in Pallikaranai | PCB Course in Chennai
Wow...What an excellent informative blog, really helpful. Thank you so much for sharing such a wonderful article with us.keep updating..
ReplyDeleteMatLab Training Institute in Chennai | MatLab Training in Velachery | Matlab Training Center in Chennai | MatLab Courses in Pallikaranai | MatLab Training with Placement in Chennai
Thank you so much for posting this. I really appreciate your work. Keep it up. Great work!
ReplyDeleteBest Selenium Certification Training in Chennai | Selenium Training Institute in Chennai at Velachery | Selenium Course Training in Chennai | Selenium Training Center in Velachery
Thanks for posting this useful content, Good to know about new things here.It was so good to read and useful to improve my knowledge as updated one, keep blogging…
ReplyDeleteMicroSoft Azure Training Institute in Chennai | Azure Certification Training in Velachery | Azure Certification Training in Adyar
I have read your blog its very attractive and impressive. I like it your blog.Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.
ReplyDeleteVMware Certification Training in Chennai | VMware Certification Exam Center in Chennai | VMware Exams Center in Taramani | VMware Certification Exams in Chennai
Your Blog is really amazing with useful and helpful content for us.Thanks for sharing.keep updating more information.
ReplyDeleteEmbedded System Training Institute in Chennai | Embedded Training in Velachery | Embedded System Training in Guindy
Thank you for a wonderful post. I get more kind of information and Keep it up...!
ReplyDeleteCorporate Training in Chennai
Corporate Training Companies in Chennai
Linux Training in Chennai
Pega Training in Chennai
Advanced Excel Training in Chennai
Tableau Training in Chennai
Primavera Training in Chennai
Job Openings in Chennai
Power BI Training in Chennai
Oracle DBA Training in Chennai
Placement Training in Chennai
Learned a lot of new things in this post. This post gives a piece of excellent information.
ReplyDeletespoken english classes in bangalore
Spoken English Classes in Chennai
spoken english class in coimbatore
spoken english class in madurai
devops training in bangalore
DOT NET Training in Bangalore
best spoken english classes in bangalore
Spoken English in Chennai
best spoken english institute in coimbatore
best spoken english center in madurai
ReplyDeleteThanks for this wonderful blog. keep update more information about this
Ethical Hacking Course in Chennai
Hacking Course in Chennai
Ethical hacking course in bangalore
Ethical hacking course in coimbatore
Ethical Hacking Training in Chennai
Certified Ethical Hacking Course in Chennai
Ethical Hacking Training Institute in Chennai
Ethical hacking Training institute in bangalore
Software Testing Training in Chennai
ielts coaching centre in coimbatore
I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
ReplyDeletedata analytics courses
machine learning course malaysia
big data analytics malaysia
data science course
Valuable one, Thanks for sharing waiting for next update...
ReplyDeleteDOT NET Training in Chennai
asp .net training in chennai
best .net training institute in chennai
dot net institute in chennai
dot net training in Tambaram
Html5 Training in Chennai
Spring Training in Chennai
Struts Training in Chennai
Wordpress Training in Chennai
SAS Training in Chennai
I see some amazingly important and kept up to length of your strength searching for in your on the site
ReplyDeleteData Science Training Malaysia
Big Data Analytics Malaysia
Data Analytics Course Malaysia
It is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it!
ReplyDeletebig data course malaysia
data scientist course in malaysia
data analytics courses
360DigiTMG
Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!big data analytics course malaysia
ReplyDeletedata science course malaysia
data analytics courses
360DigiTMG
ReplyDeleteThanks for sharing such a great information.It is really one of the finest article and more informative too. I want to share some informative data about net developer training and c# training videos . Expecting more articles from you.
Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, microstrategy tutorial but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
ReplyDeleteIOT Training in Bangalore - Live Online & Classroom
ReplyDeleteIOT Training course observes iot as the platform for networking of different devices on the internet and their inter related communication. good job
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating nice page
ReplyDeleteAi & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
I want you to thank for your time of this wonderful read!!! I definately enjoy every little bit of it and I have you bookmarked to check out new stuff of your blog a must read blog!
ReplyDeleteData Science Institute in Bangalore
Great information very useful blog keep up the good work thank you.
ReplyDeleteData Science Course in Hyderabad
Fascinating article with relevant information, good work thank you.
ReplyDeleteData Analytics Certification Training 360DigiTMG
Python language is not only easy to grasp, but emphasizes less on syntax which is why a few mistakes here and there doesn't give as much trouble as some other languages does. unindent does not match any outer indentation level python
ReplyDeleteThis is an awesome motivating article.I am practically satisfied with your great work.You put truly extremely supportive data. Keep it up. Continue blogging. Hoping to perusing your next post
ReplyDeleteBest Institute for Data Science in Hyderabad
Great information, nice to read your blog. Keep updating.
ReplyDeletepositive effects of social media
applications of artificial intelligence
ai applications
what is php used for in web design
rpa uipath jobs
php developer interview questions
What an extremely wonderful post this is. Genuinely, perhaps the best post I've at any point seen to find in as long as I can remember. Goodness, simply keep it up.
ReplyDeletedata science course
Good article!!! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
ReplyDeletepython Training in chennai
python Course in chennai
I truly like your composing style, incredible data, thankyou for posting.
ReplyDeleteData Science Training in Hyderabad
Such a very useful information!Thanks for sharing this useful information with us. Really great effort.
ReplyDeletedata science course in malaysia
Mua vé tại đại lý vé máy bay Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ giá rẻ
vé máy bay hải phòng phù cát
vé máy bay huế hồ chí minh
giá vé máy bay sg hn
chuyến bay hồi hương từ mỹ về việt nam
taxi đi sân bay nội bài
combo hà nội nha trang
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
ReplyDeletebest data science course
Thank you for sharing wonderful content
ReplyDeletebest data science course
This post is very simple to read and appreciate without leaving any details out. Great work!
ReplyDeletemachine learning course in aurangabad
ReplyDeleteThis blog is really awesome. I learned lots of informations in your blog. Keep posting like this...
German Classes in Bangalore
German Language Course in Bangalore
German Language Course in Hyderabad
German Language Course in Delhi
German Language Classes in Pune
Informative article. Thanks for sharing with us.keep it up.
ReplyDeleteartificial intelligence training in chennai
Great post. keep sharing such a worthy information.
ReplyDeleteSalesforce Training in Chennai
That is nice article from you , this is informative stuff . Hope more articles from you . I also want to share some information about Agro Fertilizer Company in India
ReplyDeleteMy rather long internet look up has at the end of the day been
ReplyDeletecompensated with pleasant insight to talk about with my family and
friends.
node js course in chennai
oracle course in chennai
ASP Dot Net Training in Chennai
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Anyway, I’ll be subscribing to your feed and I hope you post again soon.
ReplyDeletebusiness analytics training in hyderabad
Great work! You explain all the things very simply about grid view. Thank you for serving this information with us. Best data analytics course in Noida
ReplyDeleteHow kind of you to say so. Thanks very much. Ziyyara offers private tuition classes for class 12 students who want to excel in their studies and achieve academic success.
ReplyDeleteBook A Free Demo Today visit Private Tuition Classes for Class 12
The blog you shared is very good. I expect more information from you like this blog. Thank you. Ziyyara Edutech’s online English language classes in Kuwait are designed to provide a comprehensive and immersive learning experience, with a strong emphasis on spoken English proficiency.
ReplyDeleteFor more info visit English language Class in kuwait
Thanks for adding it to my knowledge. You are wonderful writer. Your articles are very helpful and easy to understand. Spoken English Classes in Saudi Arabia: We focus on practical communication skills, enabling you to converse fluently in English.
ReplyDeleteFor Book a demo now Online Tuition for english in Saudi Arabia
Thank you for sharing this valuable content. It's great to learn about new topics here. I look forward to sharing this information with others.
ReplyDeleteSAP FICO Training in Hyderabad
The blog on binding GridView using DataReader is a great guide for developers. At RaiseinTech Academy, our tech courses offer hands-on training to help you master essential skills for a successful career .
ReplyDeleteNice article. It was worth reading.
ReplyDeleteDigital Marketing Course in Bangalore