SqlCommand in ado.net - Part 4

[@binodkarki7040]

Its not kUDVENKAT, its GUDvenkat. (Y)

[@Csharp-video-tutorialsBlogspot]

+Binod Karki GUDvenkat. I like it. Thank You. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.

[@shumailakhaliq4982]

sir plz describe how can we display a single image from database on webpage my binding html image tag in asp.net using ado.net. i am not finding any help.please help

[@shumailakhaliq4982]

Sir what if we are returning the url of single image from database and displaying it by html img tag?..what will be code

[@franbellagamba3489]

I have no words man, thank you so much for these awesome and simple explanations. I have a test in 9 days and haven't managed to study properly because of my job. I sit here 2 or 3 hours a day listening to you and I get a full week of class in a day

[@Csharp-video-tutorialsBlogspot]

The DataBind() method binds the data to the control on which you have invoked it. If this method is not called, the data will not be bound to the control and will not be displayed. Setting DataSource property and invoking DataBind() method is required if you want the data to be displayed in the databound controls like DropDownList, ListBox, GridView, Repeater etc. Hope this answers your question.

[@anandms7537]

Sir, your videos are still so fresh even in 2020 after 8 years, no words to describe how good you are

[@kinjalkaushik3196]

Oh guy! You saved my marks. Today I had an exam and it went wonderful. All because of you. Thank you so much! 😊

[@ivan4686]

Mr Venkat, thank you very much for your valueable lessons! These are the best .NET tutorials in KZbin

[@Nopad001]

Dear sir, I really want to thank you for your tutorials. I love the way you teach. Best tutorials I ever found

[@indurnuguri1]

Hi Venkat, You are doing an absolutely phenomenal work. Your way of explaining things is very elegant, done in a simple way to make it understandable for anyone new to the technology. The developers community should be thankful to you for spreading your vast knowledge to everyone on the internet free of cost. Thanks and all the best to you!

[@ajvbhavani6620]

i have watched all of your ado.net videos. It is very use for me and your way of explanation is very nice, its very understandable to everyone . I want to learn more about .net

[@PrachiSingh-et3kz]

you are a very good teacher! Clear explanations and control on managing the content. Superb.

[@SyedKollol]

Venkat Da, I am really getting excited with your videos. The more I am watching the more I am getting interested. Excellent work and God Bless you.

[@mini_rajnikant3616]

no words for this wonderful teacher. thumbs up!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!111

[@flo0fi]

Literally solved my problem for under a minute. God bless you venkat ,your videos are so helpful :)

[@Kaiyoga2]

Thank you so much for all your tutorials. I don't know what i would do without you !

[@skumaropx12]

Great!! Nice tutorials. I loved your way of explaining things.

[@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.

[@katalinnemeth6348]

It is really wonderful that you explain all possibility and every aspect of the theme.

[@vitalkumar8879]

Thanks for giving us these much stuff. Which helps me a lot lot....

[@ahmedabuhalawa7932]

thank you too much,I was confused but now every thing is better.

[@santoshkumar-uv1jc]

thank you very much venkat garu..... your videos are very clear for understanding so your vedios are very helpful.. pls share any J query videos pls..

[@vasanthkamath8158]

all of ur tutorial so far i hav watched are sooo amazing...sir im requesting u to add videos on windows application...

[@sergi3056]

Excellent ! I love your tutorials.

[@er.sameer525]

SO deep making understanding and being helpful for us , thank you sir

[@govindsharma4691]

can we have some videos on Xamarin please

[@sarahahmed2112]

in Response.Write() we can use " " instead of "", right? And why is it that "" works anyway? Because I don't think that would work in C++'s cout. Is defined for C#?

[@getsufuma812]

thanks! my mind is clear after ur explanation

[@Csharp-video-tutorialsBlogspot]

Hi Pooja, thank you very much for your interest in PragimTech videos. I have included the link for the complete ADO.NET video tutorial playlist, in the description of this video. This playlist contains all the videos in a logical sequence. Please let me know if you have found part 3.

[@-Harambe]

Venkat, when do you use Ado connection vs Entity Framework?

[@SG_Isha_2024]

Venkat your videos are soo soo awesome. :) I want to thank you for all your video tutorials. Seriously man, a very very big thanks. U r my virtual teacher. :) Anytime, If i can be of some help to you, i will be very happy to help. Regards

[@devilji4]

Dude you are still awesome!

[@mickeysaini]

Good work buudy !!!

[@shahzaibriaz6552]

Brilliant Brilliant Absolutely Brilliant Tutorials

[@muazabdool6047]

Your explanations are clear and precise thank you good sir

[@monishan1943]

Sir can you put video of one small project then we come to know how to use all these regarding C# && asp.net..

[@socerboy06]

I wonder after you execute the command text in asp.net,and then you went in to the sql server08,why you execute the T-sql again?

[@eldershima]

i honestly love this guy

[@isogunro]

I have watched 6 of your videos so far and they are all excellent! You have done a great job. I have learned something from each one and looking forward to learning from all of them. I really think this will give me the foundation to prepare for certification exam 70-516. Do you cover LINQ also?

[@sergioesteban7663]

nonquery also excecutes read operations?

[@evostefanov9258]

I have to say thank you for creating this playlist. These videos are just such a great resource. Having said that, I have been struggling with a problem for the last few days and I just can't find the help to solve it all the way. I am not senior in C# so forgive me if I am missing something simple here. Here is the question - I am trying to write a script in SSIS which converts a System.Object into a list of strings so I can then select the Max value from all the strings, how can I do that exactly because using the data adapter just doesn't work for me. I don't care if i convert to a list of strings or a data column, or an array - I just need to select the Max value stored in the System.Object. Please help! And thanks again for these videos.

[@nimeshambalalpatel3032]

hello sir! why we have done totalrows.toString() when already the method executNonQuey is returning a integer value which we are storing in an integer variable?

[@rakeshkusuma8811]

Hi Venkat i am a beginner to ADO.Net This video is very help for learning things quicky..thanks alottt i tired delete command with ExecuteReader instead of ExecuteNonQuery.. and it deleted the row from table so what is the main difference between ExecuteReader and ExecuteNonQuery Please Help to understand..

[@katalinnemeth6348]

If you want to execute a command in the database like insert, update or delete then use the ExecuteNonQuery statement. But you won't get back any data from the database. If you want to get data from the database then use the ExecuteReader. Like it's name seems, it is only read the data in the database.

[@akkaradechsrithongchai7766]

Very good ,Thank you

[@Csharp-video-tutorialsBlogspot]

Sure, will do it soon. 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.

[@mohv1903]

Thank You. These really helped

[@gopalbharadva9623]

i get very knowledge from you sir

[@sunilkumarm4789]

awsome tutorials

[@atulbhadoriya9702]

sir i have a problem bcoz i dont know how to create table in mysql and i have n knowleg of c# plz tell me solution

[@sksubhi1138]

I'm facing a problem with web application I don"t get the data in the GridView at the browser but in the Windows Forms Application i can .

[@subhamaydatta2413]

kudvenkat I'm trying to provide the connection string in the web.config file, but an error occurs : "System.InvalidOperationException: Instance failure"...but when I hard code the exact same connection string in the webform, it works...please help..

[@rakeshsharma4777]

Subhamay Datta may i know the connectionstring that u mention in web.config file.

[@safeerkhan8706]

thank you soooo much

[@eldershima]

awesome

[@glorylandingloryland4433]

Respect dude!

[@semikolon4229]

Thanks Venkat

[@1prdas1]

Thank you!

[@VipinSharma-ex6rj]

too great... thanks lot :)

[@sandeepadode1]

Why do we have to convert the total rows to ToString in Response.Write()? Can't we simply write as TotalRows and not TotalRows.ToString()?

[@0prirate656]

how to insert data in multiple data in commandetext?

[@davidespada01]

dont use the command line because its hard if ur not used on it, choose any free Database admin tool to play with database in GUI i recommend sql developer from oracle, ya the default is connect to oracle but you can add a JDBC file for MySql and SqlDeveloper will connect to it > google : connect SqlDeveloper to My sql its easy

[@civilized.savage]

file not found error occured at con.open() plz help

[@amitpandey3057]

How to connect Oracle database

[@ameemansari7537]

Does anyone knows how to insert multiple rows??

[@thedude3544]

thank you !!

[@aamezkhanpathan3188]

how to create Sql connection file in c# Class

[@PoomulusRobsBanksOnTV]

Check out part 2, you can do it in the aspx.cs file but it is recommended to do such in the web.config

[@varshavasudev1530]

How do I find web.config file

[@MrPelaoDominique]

Thanks!

[@developernader]

ConnectionStrings in web.config configuration file - Part 3