SqlDataAdapter in ADO.NET Part 10

[@mrcode6123]

I cant believe these are made in 2012 and still relevant Great JOB SIR

[@compeng2013]

Great videos! I love how you emphasize everything over and over in each video to just embed it into our brains!! Blessed you are!

[@sasazezelic]

DataAdapter is actually like a burglar. "He" has a (Connection) to know where the good stuff is (Data), he doesn't need anyone to (Open) the connection, he opens it with his own tools, he takes the good stuff and stuffs his pockets with it (DataTable) and then he gets home, gets all the stuff out of his pockets and arranges it neatly on his desk (DataSet). Venkat, you are a gift from programming heaven. You really have a knack of explaining things. I'm learning more from your videos than from an in class education I went to.

[@Csharp-video-tutorialsBlogspot]

Hi Tony, good spot. The code will work even without specifying the data type. However, I personally prefer and suggest to specify the data type as it would make your code more readable. Hope this helps.

[@Csharp-video-tutorialsBlogspot]

Hi Thank you very much for stopping by to ask the question. The answer is, yes you can.

[@dineshchinnadurai8338]

Really good way of teaching. very smart way. I love your way of teaching thank you so much sir... I watched ADO.NET from video 1 to 10 really useful. Thanks again @venkat sir....

[@Stylecatchbandel]

Thanks Venkat Sir for ur active anticipation. Great work done!.Its really needful thought suggested by u. ONE COMPLIMENTENTARY award tht i can hand over 2 u("GENIUS")

[@soumyasahar7379]

Thank you so much sir for explaining these things in such a easy way. Teacher like you make learning new technology very easy. I want to specially appreciate your approach of writing every bit of code from scratch for each video. Like the way of writing Connection strings, sql command object etc are shown in every video. Thank you so much.

[@uzmazubair4288]

very good, u made very easy to understand , very clear words , very very helpful, thanks Venkat

[@kavithasaphal]

the one who dislikes these videos are definitely envious peoples...

[@qurupatriot]

Thanx Venkat, you are a KING! :)

[@sergi3056]

If you use an Application , and not web, you should use at the end another thing. dataGridView.DataSource = ds.Tables[0] (if you dispose of only a DataSet) Thank you for your tutorials kudvenkat !! :)

[@surajborade2123]

Hello Sir, This is amazing work I have ever seen. It builds confidence to learn the Dot Net technology. I am feeling most enthusiastic to learn from such videos. Thanks a lot.

[@mrky92]

You have my greatest compliments for what You are doing! My question is: Do we need "using" or "finnaly" blocks with SqlDataAdapter, since it DOES take care about openning and closing connection to DB? Thanks in advance

[@Csharp-video-tutorialsBlogspot]

You are 100% right. We don't need it.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. 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. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@edmundogriffin3448]

I´m becoming a fan!!!!

[@naveenintel7006]

u r great,plz provide a video on simple project development using ADO.NET and ASP.NET

[@samuelmasuku]

I love the way he explains

[@lootstealeryt7614]

you are amazing thank you very much

[@bulp9893]

sir thanks for upload valuable videos

[@saheena88]

Hi,Venkat...ur videos r awesome..its really very helpfl..I just have one doubt regarding dataadapter...that whether its a part of connected envrnmnt or disconnected envirnmnt..bcoz i read it somewhr tht it falls undr the catgry of connctd envrnmnt....Pls let me kno ..

[@jucalan]

Great video, you can put subtitles, I do not listen very well, and has some deaf people who want to see their video. great job dude

[@ahmedkhalifa3731]

greet video and greet teatcher

[@ranjeet99mishrarock]

Genius Teacher

[@natiggaraisayev]

Very good tutorials

[@rickeyrudey]

first let me say ur videos are awesome. its very clear what u want us to learn here. now lets say if i were to create a store procedure to extract one single data value from a record (lets say for example a name by itself) and assign it to a textbox or a label instead of a grid view. how would i have done that?

[@SuperPresidentObama]

Dear Venkat, I will keep my comments very simple. string myCommentToVenkat = "Thank You"; Sincerely, Your Student

[@neelpatel5456]

it was great! and I almost forgot that Nokia ringtone.!

[@sheenl4601]

Hi sir just a question about the method to pass the parameters to new sql adapter can I use da.SelectCommand.CommandText ="select * from table where...." da.SelectCommand.Connection = con? looking forward to your reply and thks

[@ranaveeraelgani]

Hi Venkat you are doing a great job!. Can you please provide a video for deleting the row in a relational DB. In case " if i want to delete customerID PK from customer Table , cutomerid FK is in order Table" i hope you get the scenario!!...Thank You!!

[@josephoyila6913]

Another great video,please how can we bind an Arraylist using SqlDataAdapter , for example connecting an image, name, price from database to display in web form

[@rajeshs8846]

hi Venkat. incase if i have multiple gridviews(say example 3) then how should i use NextResult() method on each ResultSet

[@immanuveledison7674]

sir ur videos r awsm,but upload some videos on form view,list view,etc.As u have uploaded only abt gridview control...

[@SaikatBhadury]

Nice Video.. Thanks Sir.. I have a question.. What is the deference between DataSet And DataTable?

[@sujannembang5942]

This video is awsome, i would like to know about OleDb DataAdapter and Dataset

[@harikaaakutota7776]

hi venkat where do v use disconnected data access model in real time?in ado.net part10 in dataset v are retrieving group of records....suppose if i retrieve only one value for example ProductName then can i use datatable?using sqlcommand u have explained how to insert,update& delete records from/to a database....but in ado.net part10 u have shown select operation only...could u upload video for insert,update&delete using sqldataadapter...pls

[@arvjugtwan9097]

osm tutorial

[@gobind289]

Hello sir, we can pass multiple inline query with SqlDataAdapter. Is there possible to pass multiple stored procedure with SqlDataAdapter?

[@sohaibhabib308]

sir i have a question for you.i had developed a desktop application by using hardware finger print device .application work very fast on my pc but after making installer and deploy on server application response is very slow and give thumb impression result is very slow .25 second slow response.what the reason behind. please help me

[@harikaaakutota7776]

hi venkat integrated security = SSPI in web.config fie could u tell me what is SSPI...i mean expansion of SSPI.. u told SSPI meand v are using local server

[@shehrozafzal9208]

@8:57 nokia ringtone bell in background.....!!!!!!!!!!

[@sridevipindi1547]

hi venkat sir how to use output parameters with sqladapter

[@prosunchakraborty92]

Hello, Sir, Could you please tell me what are the basic differences between SqlDataAdapter and SqlCommand and when to use one over another ?

[@SomebodyOutTh3re]

thank you !

[@prabu67]

plz. provide a sample program for 1. CRUD operation with Record Navigation 2. One to Many Relation (2 Tier Architecture) 3. Many to Many Relation (3 Tier Architecture). 4. Nested Web Pages (e.g - Purchase Request & Purchase Order) 5. All 4 sample with Stored procedure. Try Thanks. Prabu

[@diwaspoudel7]

Can't we use DataAdapter in Insert ,Delete and Update Operation to database?

[@Ajaysharma-dt5tj]

sir i get an error i.e sqldataadapter is a namespace but use as a type

[@honeesh1]

Thank you

[@krimbelkacem5751]

how to create setup for your dataApp thank you very mutch