SqlDataReader in ADO.NET Part 8

Perfect (y) .. Love to see and learn through your lectures <3

You're the best

Thank you, Doctor Venkat. I have nothing better to offer you than to invite you to the greatest blessing in the universe, which is the blessing of Islam and enough for it to be grace .. God says change the religion of God they desire and for him the safest of the heavens and the earth voluntarily and his hatred and to him they return … He also says .. that religion is with God Islam and who seeks Other than the religion of Islam, it will not be accepted from him, and he is in the hereafter among the losers .. He also says .. There is no compulsion in religion, so whoever disbelieves the tyrant and believes in God, he adheres to the trustworthy loop, which is inseparable and God is All-Knowing.

Your voice is really soothing..
.
.
.
I think I want to go to bed now!!

Best of Best!

This has helped me with my vb.net/mySQL project. Thank you very much!

Using Block ensures the connection is closed ina timely fashion, nice tutortial

if i made store procedure with only a select statmet will that prevent from sql injecion

Hello

No words to thanks I pay 20000 in university that is only for degree but I learn free from your vedios

excellent

Best Teacher !

@kudvenkat i really like your videos. You cover the topics very nicely and each video is kept of appropriate length. Great job!!!

Sir, Please how many years it takes you to become an excellent programmer? coz you are just too good. Too good I reapeat.

this query seems to generate problem in my code

SqlCommand getuserinfo = new SqlCommand("SELECT * FROM tbl_admin WHERE user '" + txtUser + "' AND password '" + txtPwd + "'", con);

SqlCommand getuserinfo = new SqlCommand("SELECT * FROM tbl_admin WHERE user '" + txtUser + "' AND password '" + txtPwd + "'", con);

Great Information , Simple And Effective , Subscribed ,Liked , Thank You !

Venkat you are a Very good teacher

Hi,

I really appreciate your help on my issue, while declaration of sqldatareader object (SqlDataReader rdr = cmd.ExecuteReader()) I received an error saying "cannot implicitly converter type 'System.Data.SqlClient.SqlDataReader' to 'projectname.SqlDataReader' "

I love you Venkat

I dont understand the purpose of "table.Rows.Add(dataRow)" this line code

Sir, can you suggest me good books for .NET and JavaScript.

u r the best..

So well explained. Thank you

Can I fill the data using Dataset and data reader?

Thank you sir

thank you very much sir your explanations are intensively clear so it made it easy to comprehend and learn such huge amount of information in short time

Hello venkat sir ,
great sir i am Ur online video student and your video series helping me so much. Because  Your explanations are so simple and clear. I watched around five hundred of your videos already

That video helped me so much. Your explanations are so simple and clear, you make it fun to learn. I watched around hundred of your videos already.Thank you!

What about the SqlCommand cmd object. Should this be declared within a using Block so that it will get disposed? Thanks

Thanks Venkat, greetings from the Dominican Republic!

Best .NET teacher ever.

hai venkut very very helping tutorials keep it up thanks

hai great good tutorials no competitions thanks to uuuuu

Have you ever request  yourself about where is your indiscryptible "attirance" for caramel coming from?
Thank's for your tuto, as every time

Thanks Venkat. You explained everything in very simple language. Thanks again for sharing these videos.

you sir, are simply the best. 

Hi venkat, greeting familiar yes
to insert update delete tutorial on C # what is not?
thank you so much for helping us.

continuation…if so can u show us how to cahnge the data using sqlexecutereader pls?
sqldatareader requires an active connection to the datasource,while reading data….what does it mean…pls tell us….thanks in advance

hi venkat ,
from this video v learned that sqldatareader is read only,forward only and requires active connection….
1)even sqlexecutereader also used to retrieve the records….
2)before v write cmd.sqlexecutereader v write connectin.open and same is the case with sqdatareader
so what is the difference between sqldatareader and sqlexecutereader…..pls clarify this doubt
3)from this video v learned that v cannot change the data using sqldatareader.can v change data using sqlexecuterader?

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.

Besides closing the connection or the reader with the Using statement or in the Finally block, there is also another way which specify the "CloseConnection" behavior within the parentheses of the ExecuteReader method of a command object. It is one of the members of the CommandBehavior enumeration, and is generally being used as such SqlDataReader reader = cmd.ExecuteReader(CommandBehav­­ior.CloseConnection). The connection will be closed automatically when the data reader is closed.

HI venkat….Can you plz share how to write a parameterised query that inlcudes WHERE clause..Because we cannot pass comma separated values as parameters directly…can you please shows us how to deal with these parametersied queries especially for WHERE and LIKE clauses..

Hello Sir,
I have solved the above error. Actually There was an issue with the name of the class which i had given to be SqlDataReader, which is an already existing class in Ado.Net Framework. So I changed the name of the class file and the issue was resolved. But thank you so much for checking it. And also, your videos are the source of tremendous knowledge. I have share them to as many Facebook Pages as I can, also with my juniors….

Hi Dhaval, is this error at compile time or at run time? Can you please post the code here.

To be specific, only this video.. Otherwise all the other videos are so helpful….

Hello Sir, there seems to be some error for these videos. I am using Visual studio 2012 and there is an error at line :

using (SqlDataReader rdr = cmd.ExecuteReader())

Error 1 Cannot implicitly convert type 'System.Data.SqlClient.SqlDataReader' to 'StoreProcedureEgOne.SqlDataReader'

Can you help me with that please ??

a+ for all videos

Thanks for the sharing and helping the comunity