Please navigate to the bottom of the page for Table of Contents

Thursday, June 2, 2011

Explain ASP.NET data binding using DataSets and DataSourceControls

In a data centric web application, you are required to bind data to a UI control (such as GridView or Repeater). This data can come from a variety of sources. In an interview, it is important for you to know a couple of simple ways to bind data (from say SQL Server table) to a web UI control. This is a very complex topic and there are entire books written on this subject. In this post we will explore two very basic ways to bind data from SQL to the web control.

Using DataSet to bind data

In the first example, we will explore an old way of bind data using DataSets. You will still find this code in many established (legacy) code bases and it is worthwhile to dig deeper in this style. The basic idea is that you get your data in a DataSet and then set that data to the DataSource prperty of your Data bound control and then call DataBind(). The code snippet below shows a simple ASPX page and it’s code behind:

<%@ Page Language="C#" AutoEventWireup="true" 
CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication2.WebForm1" %>

<!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="GridView1" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>


The code behind file loads data from the SQL into a DataSet and then binds it to the control.


using System;
using System.Data;
using System.Data.SqlClient;

namespace WebApplication2
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string connString = "some valid conn string";
            SqlConnection connection = new SqlConnection(connString);

            using (SqlCommand cmd = new SqlCommand("Select * from Products", connection))
            {
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);

                GridView1.DataSource = ds;
                GridView1.DataBind();
            }
        }
    }
}


Using Data Source controls to bind data


The other method of displaying data is using the Data Source controls. ASP.NET provides seven built-in data source controls; each targeting a specific data type. I urge you to explore and understand each of the following controls: SqlDataSource, LinqDataSource, ObjectDataSource, XmlDataSource, and so on. These controls can be configured extensively which is beyond the scope of this post. The example below illustrates the simplest use of a SqlDataSource with a GridView control to display data.


The code snippet below shows a very simple declarative way of defining the SqlDataSource.


<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
SelectCommand="SELECT * FROM [Products]"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" />


The same GridView we difined in our first example can be used with slight modifications. Instead of using DataSource and BindData() calls, we just use the DataSourceID property of the control.

 

<asp:GridView ID="GridView1" runat="server"
    DataSourceID="SqlDataSource1" >
</asp:GridView>


We have barely scratched the surface of Data binding. But this should give a good base for preparing for your interview skills for data binding.

Posted by Nikhil Singhal at 6:57 PM
Tags: ,

79 comments:

  1. navyaDecember 21, 2015 at 3:44 AM

    Very interesting and good Explanation
    ASP NET Training
    ASP NET Training
    ASP NET Online Training
    C-Sharp Training
    Dot Net Training in Chennai
    Online .Net Training

    ReplyDelete
  2. All in One Shopping AppsNovember 1, 2016 at 12:06 PM

    Free Recharge Coupons and offers - > Free Recharge Tricks

    ReplyDelete
  3. johnMay 23, 2020 at 12:15 PM

    You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! Data Blending in Tableau

    ReplyDelete
  4. Data Science puneMay 28, 2020 at 9:02 PM

    This comment has been removed by the author.

    ReplyDelete
  5. Data Analytics PuneMay 29, 2020 at 4:36 AM

    Nice post and valuable information thank you.
    Data Analytics Course in Pune
    Data Analytics Training in Pune

    ReplyDelete
  6. Emerging TechnologyMay 29, 2020 at 9:25 AM

    Nice post and valuable information, writing is simply great, thanks for sharing.
    Business Analytics Course in Pune
    Business Analytics Training in Pune

    ReplyDelete
  7. tejaswiniJune 7, 2020 at 9:57 PM

    I was very pleased to find this site.I wanted to thank you for this great read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post.
    data science certification malaysia

    ReplyDelete
  8. yashJune 7, 2020 at 10:41 PM

    I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you!
    data science training in bhilai

    ReplyDelete
  9. Data Science puneJune 10, 2020 at 7:58 AM

    Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    Data Science Course in Pune
    Data Science Training in Pune

    ReplyDelete
  10. GauravJune 10, 2020 at 10:11 PM

    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.
    data science training in indore

    ReplyDelete
  11. training courseJune 10, 2020 at 11:30 PM

    I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
    Data Science Training in Hyderabad | Data Science Course in Hyderabad

    ReplyDelete
  12. UnknownJune 11, 2020 at 12:51 AM

    I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    data science training in vijayawada

    ReplyDelete
  13. training courseJune 11, 2020 at 5:45 AM

    You are in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!
    Business Analytics Course in Hyderabad | Business Analytics Training in Hyderabad

    ReplyDelete
  14. 360digitmgasJune 11, 2020 at 7:15 AM

    Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates.
    data science training in coimbatore

    ReplyDelete
  15. ramJune 11, 2020 at 6:18 PM

    I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article.

    data science course in guntur

    ReplyDelete
  16. AtheefJune 13, 2020 at 1:25 AM


    It has fully emerged to crown Singapore's southern shores and undoubtedly placed her on the global map of residential landmarks. I still scored the more points than I ever have in a season for GS. I think you would be hard pressed to find somebody with the same consistency I have had over the years so I am happy with that.
    data science training in noida

    ReplyDelete
  17. ramJune 14, 2020 at 6:49 PM

    I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    data science training in guntur

    ReplyDelete
  18. GauravJune 15, 2020 at 3:06 AM

    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.
    data science training in indore

    ReplyDelete
  19. UnknownJune 15, 2020 at 3:25 AM

    I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you!
    data science training in vijayawada

    ReplyDelete
  20. 360digiTMGJune 15, 2020 at 11:49 AM

    I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    data science course in guduvanchery

    ReplyDelete
  21. 360digitmgasJune 15, 2020 at 11:50 AM

    Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates.
    data science training in coimbatore

    ReplyDelete
  22. 360DigiTMG AurangabadJune 16, 2020 at 5:17 AM

    Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
    data science training in aurangabad

    ReplyDelete
  23. ramJune 17, 2020 at 7:09 PM

    I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.

    data science course in guntur

    ReplyDelete
  24. ramJune 19, 2020 at 11:26 PM

    Great post I must say and thanks for the information. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.

    data science course in guntur

    ReplyDelete
  25. 360digiTMGJune 21, 2020 at 5:49 AM

    I have express a few of the articles on your website now, and I really like your style of blogging. I added it to my favorite’s blog site list and will be checking back soon…
    data science course in guduvanchery

    ReplyDelete
  26. 360digitmgJune 24, 2020 at 11:50 PM

    Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    data science course in ecil

    ReplyDelete
  27. 360digitmgJune 29, 2020 at 11:10 PM

    I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.
    data science training in ecil

    ReplyDelete
  28. 360digitmgJuly 3, 2020 at 2:46 AM

    Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    artificial intelligence course in ecil

    ReplyDelete
  29. 360digitmgJuly 4, 2020 at 9:46 AM

    Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    artificial intelligence training in ecil

    ReplyDelete
  30. PriyankaJuly 7, 2020 at 3:26 AM

    Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
    Data Analyst Course

    ReplyDelete
  31. 360DigiTMGJuly 15, 2020 at 10:14 PM

    Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written.
    data science course in hyderabad
    data analytics course in hyderabad
    business analytics course in hyderabad

    ReplyDelete
  32. best August 30, 2020 at 5:33 AM

    Going back to my personal experience, after the theoretical part I have done the Internship programme, which consist in a period of 3 months work experience made up of doing the task that a digital marketer would deal on a daily basis routine. digital marketing course in hyderabad

    ReplyDelete
  33. 360digiTMGSeptember 4, 2020 at 11:13 AM

    I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have for sharing.
    software skills

    ReplyDelete
  34. hrithiksaiSeptember 14, 2020 at 3:26 AM

    Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data sciecne course in hyderabad

    ReplyDelete
  35. hrithiksaiSeptember 16, 2020 at 1:46 AM

    Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data sciecne course in hyderabad

    ReplyDelete
  36. hrithiksaiSeptember 18, 2020 at 4:21 AM

    Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data sciecne course in hyderabad

    ReplyDelete
  37. hrithiksaiSeptember 19, 2020 at 4:17 AM

    Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data science course

    ReplyDelete
  38. hrithiksaiSeptember 24, 2020 at 12:09 AM

    Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data sciecne course in hyderabad

    ReplyDelete
  39. UnknownSeptember 30, 2020 at 10:59 PM

    Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    360digitmg

    ReplyDelete
  40. hyder31October 29, 2020 at 5:20 AM

    Nice Blog

    Digital Marketing Course in Hyderabad

    ReplyDelete
  41. Mohd ShariqueNovember 11, 2020 at 12:03 PM

    Wow! Such an amazing and helpful post this is. I really really love it. I hope that you continue to do your work like this in the future also.

    Apache Spark Training in Pune
    Spark Training Institute in Pune

    ReplyDelete
  42. EXCELRNovember 21, 2020 at 5:06 AM

    Thanks for sharing great information. I highly recommend you.data science courses

    ReplyDelete
  43. EXCELRNovember 22, 2020 at 1:35 AM

    Thanks for sharing the valuable information. it’s really helpful.Best data science courses in hyerabad

    ReplyDelete
  44. UnknownNovember 25, 2020 at 7:24 PM

    Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.
    data science using python and r programming Guwahati

    ReplyDelete
  45. Excelr TuhinDecember 9, 2020 at 7:53 AM

    I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
    data science courses

    ReplyDelete
  46. saketh321December 10, 2020 at 10:39 PM

    This is a splendid website! I"m extremely content with the remarks!ExcelR Data Analytics Course

    ReplyDelete
  47. 360DigiTMGNoidaJanuary 15, 2021 at 11:55 PM

    Your content is very unique and understandable useful for the readers keep update more article like this.
    data science training

    ReplyDelete
  48. 360DigiTMGJanuary 16, 2021 at 4:12 AM

    Thanks for the information about Blogspot very informative for everyone
    data scientist malaysia

    ReplyDelete
  49. 360DigiTMGJanuary 16, 2021 at 4:24 AM

    Thanks for the information about Blogspot very informative for everyone
    digital marketing course

    ReplyDelete
  50. HuongkvJanuary 17, 2021 at 7:53 PM

    Liên hệ đặt vé tại Aivivu, tham khảo

    săn vé máy bay giá rẻ đi Mỹ

    vé máy bay từ mỹ về việt nam 2021

    từ canada về việt nam quá cảnh ở đâu

    vé máy bay từ hàn quốc về việt nam

    ReplyDelete
  51. 360DigiTMGNoidaFebruary 2, 2021 at 1:22 AM

    Hello there to everyone, here everybody is sharing such information, so it's fussy to see this webpage, and I used to visit this blog day by day
    data science course noida

    ReplyDelete
  52. 360DigiTMGFebruary 5, 2021 at 2:26 AM

    Happy to visit your blog, I am by all accounts forward to more solid articles and I figure we as a whole wish to thank such huge numbers of good articles, blog to impart to us.
    data science certification

    ReplyDelete
  53. Datascience Course AnalystFebruary 8, 2021 at 3:33 AM

    Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    Data Science Course in Bangalore

    ReplyDelete
  54. InstituteBlrFebruary 17, 2021 at 3:51 AM

    I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    data analytics course in bangalore

    ReplyDelete
  55. 360DigiTMGFebruary 18, 2021 at 1:27 AM

    Nice article. I liked very much. All the information given by you are really helpful for my research. keep on posting your views.
    data scientist training malaysia

    ReplyDelete
  56. 360digiTMG TrainingFebruary 19, 2021 at 10:38 PM

    Well we really like to visit this site, there is a lot of useful information we can get here.
    Best Data Science Courses in Hyderabad


    ReplyDelete
  57. Datascience BooksFebruary 21, 2021 at 11:30 PM

    Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
    Data Science Training in Bangalore

    ReplyDelete
  58. AI course in puneFebruary 22, 2021 at 8:21 AM

    I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    artificial intelligence course in pune

    ReplyDelete
  59. 360digitmgdelhiFebruary 22, 2021 at 10:13 PM

    Wow, amazing post! Really engaging, thank you.
    best data science course in delhi

    ReplyDelete
  60. data analytics booksFebruary 26, 2021 at 9:14 PM

    I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
    data analytics training in bangalore

    ReplyDelete
  61. dataanalyticscourseMarch 12, 2021 at 2:41 AM

    You have an extremely knowledge perspective.It’s incredible how thorough your work is.
    machine learning course

    ReplyDelete
  62. Michael L CatudalMarch 15, 2021 at 12:51 PM

    wm casino
    respect55
    เรียนภาษาอังกฤษ
    poker
    xxx
    xxx
    xxx ไทย

    ReplyDelete
  63. Data Science Training in ChennaiMarch 15, 2021 at 8:44 PM

    I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
    Data Science Training in Chennai

    ReplyDelete
  64. Data Science Training in ChennaiMarch 15, 2021 at 8:52 PM

    Actually i read it yesterday but I had some ideas about it and today i wanted to read it again because it is so well written
    Data Science Training in Chennai

    ReplyDelete
  65. Data Science Training Institute in Bangalore - 360DigiTMGMarch 16, 2021 at 2:23 AM

    i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
    data science courses in hyderabad

    ReplyDelete
  66. AI ExpertMarch 17, 2021 at 4:19 AM

    I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    artificial intelligence course in pune

    ReplyDelete
  67. Michael L CatudalMarch 22, 2021 at 3:45 AM

    บาคาร่า
    คาสิโนออนไลน์
    พวงหรีด
    ufabet
    ufa
    เว็บบอล

    ReplyDelete
  68. Michael L CatudalMarch 22, 2021 at 3:53 AM

    เว็บแทงบอล
    โควิด
    รับทำ seo
    ufabet
    ufa
    kardinalsticksiam.com

    ReplyDelete
  69. 360digiTMG TrainingMarch 23, 2021 at 10:46 PM


    Very awesome!!! When I searched for this I found this website at the top of all blogs in search engines.

    Best Institutes For Digital Marketing in Hyderabad


    ReplyDelete
  70. Data Analytics Courses in BangaloreMarch 26, 2021 at 10:32 PM

    I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    data analytics course in bangalore

    ReplyDelete
  71. Data Analytics Courses in BangaloreMarch 26, 2021 at 10:33 PM

    I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    data analytics course in bangalore

    ReplyDelete
  72. Marty SockolovMarch 27, 2021 at 10:31 AM

    kardinal stick

    ReplyDelete
  73. Cho co March 29, 2021 at 12:25 PM

    For most successful advertisers, the greatest selling point is a bit of mystery. Find the beauty hidden in mundane things. dig this

    ReplyDelete
  74. 360DigiTMGMarch 30, 2021 at 4:14 AM

    "Very Nice Blog!!!


    Please have a look about "
    data science courses malaysia

    ReplyDelete
  75. Michael CatudalApril 3, 2021 at 8:52 AM

    Watch movies online sa-movie.com, watch new movies, series Netflix HD 4K, ดูหนังออนไลน์ watch free movies on your mobile phone, Tablet, watch movies on the web.

    SEE4K Watch movies, watch movies, free series, load without interruption, sharp images in HD FullHD 4k, all matters, ดูหนังใหม่ all tastes, see anywhere, anytime, on mobile phones, tablets, computers.

    GangManga read manga, read manga, read manga online for free, fast loading, clear images in HD quality, all titles, อ่านการ์ตูน anywhere, anytime, on mobile, tablet, computer.

    Watch live football live24th, watch football online, ผลบอลสด a link to watch live football, watch football for free.

    ReplyDelete
  76. siskaApril 6, 2021 at 3:14 AM

    SamudraBet Situs Judi Online Terbaik, Terpercaya dan Terbesar di Indonesia. Menyediakan permainan :

    Judi bola terbaik

    Judi slot online terpercaya

    Poker online terbaru

    Live casino online

    Judi sabung ayam

    ReplyDelete
  77. vistatotoApril 9, 2021 at 6:08 AM

    VISTATOTO
    VISTATOTO
    VISTATOTO
    VISTATOTO
    VISTATOTO
    VISTATOTO

    ReplyDelete
  78. Data Analytics Courses in BangaloreApril 20, 2021 at 2:22 AM

    I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    data science course fees in bangalore

    ReplyDelete

Subscribe to: Post Comments (Atom)