DataSet in asp.net Part 11

In this video we will learn about
1. Loading 2 or more tables into a DataSet, and giving these tables a meaningful name.
2. Binding the tables in the DataSet to user interface databound controls like GridView, using the Tables collection property of the DataSet object.

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All ADO .NET Text Articles

All ADO .NET Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. For email alerts, when new videos are uploaded, please subscribe to my channel. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.

[Csharp-video-tutorialsBlogspot]

Sure, I am currently working on ado.net and asp.net concepts. As soon as I am done with these. I will surely record videos on deployment. Thank you very much for taking time to give the feedback

[johnsongeorge]

well done Sir GOD bless you more and more to make a such videos for us it's very help full

[Csharp-video-tutorialsBlogspot]

Hi Raseeth, what ever you are doing to debug is correct. But use just F5 instead of CTRL + F5. F5 is for running the application in debug mode, where as CTRL + F5 is for running an application without debugging. When you run the application using CTRL + F5, no debug symbols will be loaded and hence the breakpoints will not be respected and the execution of code will not stop at break points. Hope this helps.

[rakesh]

Very clear sir I'm get a good understand

[RobsonM]

Thanks Kudvenkat! You really know how to teach. Wish you the best.

[naveenprasad]

Explained clearly... Your videos are best..

[yanalanikhil]

hello sir, i really liked your videos on asp and ado.net .these videos taught me a lot
i really appreciate you for the videos and u r helping people like me around the world who are the beginners to .net
i hope u l b updating all u r videos .
once again thank you sir
bye.

[zahabtauqueer]

Hello sir thanx a lot for those videos... Can u give a video on an overall small website in which we can feed or retrieve data or call a procedure from a database..in order to understand what's the coding behind button clicks...in wpf or asp.net

[kahanx]

Watching this after a decade, still helpful to me...

[heezukaa]

Hello sir. does NextResult method in DataSet with DataTableReader can be use to display data it seem like SqlDataReader that having same method which is NextResult method but when i try to used NextResult method in DataSet with DataTableReader i have throwing errors . thank you

[benyaminbahal]

I can not deny the fact that this ADO.NET tutorial is awesome, However seems you have forgotten to talk about DataTable in ado.net and when to use them?

[davidespada]

Hi Venkat
very nice video, i wish as soon you finish the gridView and maybe Repeater and if there is any more useful data controls to go back to ADO.NET.
Q: get a single value from the data set?
thanks

[mauricioful]

hello thank you very much for the tutorials I do not speak english but I will try, which elements have the property dataset? I'm trying to put a result on a panel or on a label, can that be done?

[rahull]

Hi Venkat,

First I want to appreciate you for these great videos.
I have a question for you. Can you please tell me why are you not using any ExecuteReader() methods while you are using the Data set instead of Data reader.

Thank you

[sureshguruvelli]

in method overriding i want call virtual mehod and normal mehod in base class without using child object and without using parent object.in this how many ways are there to call base class mehods.pls tell me.

[krimbelkacem]

i really liked this series of ADO.NET
can you make a course about deployement (create a setup for yor App) of application that runs a database with it either in sql server or in sql serverver compact as clickOnce Application
i didn't find a course of you talking about this topic
thank you
than

[sureshguruvelli]

datareader is forward access but i want to go back i.e to go to previous is not possible in datareader but is it possible in datareader to view the previous record only with data reader but not dataset.

[VillageFarmerKisan]

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1061: 'webform1_aspx' does not contain a definition for and no extension method accepting a first argument of type 'webform1_aspx' could be found (are you missing a using directive or an assembly reference?)

Source Error:




Line 11: <div style="height: 358px; width: 1268px">
Line 12:
Line 13: <asp:GridView ID="GridView1" runat="server" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2"
Line 14: <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
Line 15: <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />


Source File: studio Line: 13

how to Solve this Erorr I am New leaner

[sureshguruvelli]

why data set dosenot contain prefix like sqldatareader, sqlcommand and mysqldatareader and mysqldatareader.any reason is there why dataset doesn't contain any classes.