July 10, 2020
  • 7:43 pm #36 CÁCH LÀM KEM TRÉT BÁNH SINH NHẬT – Butter Whipping Cream [ Góc Bánh Trái ]
  • 7:40 pm Tân Tiếu Ngạo Giang Hồ Tập 05 | Trần Kiều Ân, Hoắc Kiến Hoa | Phim Kiếm Hiệp Võ Thuật Lồng Tiếng
  • 7:38 pm 2D SANS VS CHARA BATTLE | Undertale: The Judgement (Undertale fangame)
  • 7:35 pm Cảnh tuyệt đẹp khu nghỉ dưỡng 5 sao FLC Quy Nhơn nhìn từ trên cao
  • 7:33 pm We bought a cheap SSD from Ali Express..



sqldatareader has no constructors defined

Text version of the video

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

In this video we will learn about
1. The purpose of SqlDataReader
2. Creating an instance of SqlDataReader
3. Reading data using SqlDataReader’s Read() method

Nguồn: https://chaoticpharmacology.com/

Xem thêm bài viết khác: https://chaoticpharmacology.com/cong-nghe/

admin

RELATED ARTICLES

49 COMMENTS

  1. Aqib sagheer Posted on July 7, 2020 at 7:38 am

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

    Reply
  2. Mohammad Rafiee Posted on July 7, 2020 at 7:38 am

    You're the best

    Reply
  3. غ ق Posted on July 7, 2020 at 7:38 am

    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.

    Reply
  4. Varun Kumar Posted on July 7, 2020 at 7:38 am

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

    Reply
  5. Naod Agere Posted on July 7, 2020 at 7:38 am

    Best of Best!

    Reply
  6. George Nikou Posted on July 7, 2020 at 7:38 am

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

    Reply
  7. Solutions Posted on July 7, 2020 at 7:38 am

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

    Reply
  8. Mina shaker Posted on July 7, 2020 at 7:38 am

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

    Reply
  9. Sohail Siddiq Posted on July 7, 2020 at 7:38 am

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

    Reply
  10. Joel Malaran Posted on July 7, 2020 at 7:38 am

    excellent

    Reply
  11. ven ding Posted on July 7, 2020 at 7:38 am

    Best Teacher !

    Reply
  12. Abhijeet Bhagat Posted on July 7, 2020 at 7:38 am

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

    Reply
  13. Olaiya Habeeb Posted on July 7, 2020 at 7:38 am

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

    Reply
  14. Arslan Ali Posted on July 7, 2020 at 7:38 am

    this query seems to generate problem in my code

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

    Reply
  15. Arslan Ali Posted on July 7, 2020 at 7:38 am

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

    Reply
  16. Arslan Ali Posted on July 7, 2020 at 7:38 am

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

    Reply
  17. Kamal Arora Posted on July 7, 2020 at 7:38 am

    Venkat you are a Very good teacher

    Reply
  18. pratim mishra Posted on July 7, 2020 at 7:38 am

    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' "

    Reply
  19. Rachel Weiland Posted on July 7, 2020 at 7:38 am

    I love you Venkat

    Reply
  20. aditya saxena Posted on July 7, 2020 at 7:38 am

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

    Reply
  21. Vignesh Sriram Posted on July 7, 2020 at 7:38 am

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

    Reply
  22. kavitha's dream world Posted on July 7, 2020 at 7:38 am

    u r the best..

    Reply
  23. La fille zen Posted on July 7, 2020 at 7:38 am

    So well explained. Thank you

    Reply
  24. Sandeep Apsingekar Posted on July 7, 2020 at 7:38 am

    Can I fill the data using Dataset and data reader?

    Reply
  25. Bimal Das Posted on July 7, 2020 at 7:38 am

    Thank you sir

    Reply
  26. hussein haider Posted on July 7, 2020 at 7:38 am

    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

    Reply
  27. Priyaranjan Das Posted on July 7, 2020 at 7:38 am

    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

    Reply
  28. עידן לייפר Posted on July 7, 2020 at 7:38 am

    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!

    Reply
  29. Will Posted on July 7, 2020 at 7:38 am

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

    Reply
  30. MrJcyank Posted on July 7, 2020 at 7:38 am

    Thanks Venkat, greetings from the Dominican Republic!

    Reply
  31. Carl Sousa Posted on July 7, 2020 at 7:38 am

    Best .NET teacher ever.

    Reply
  32. raj kumar Posted on July 7, 2020 at 7:38 am

    hai venkut very very helping tutorials keep it up thanks

    Reply
  33. raj kumar Posted on July 7, 2020 at 7:38 am

    hai great good tutorials no competitions thanks to uuuuu

    Reply
  34. TheNopseudo Posted on July 7, 2020 at 7:38 am

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

    Reply
  35. Kamlakant Chapalgaonkar Posted on July 7, 2020 at 7:38 am

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

    Reply
  36. Phani A Posted on July 7, 2020 at 7:38 am

    you sir, are simply the best. 

    Reply
  37. eko heri Posted on July 7, 2020 at 7:38 am

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

    Reply
  38. harika aakutota Posted on July 7, 2020 at 7:38 am

    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

    Reply
  39. harika aakutota Posted on July 7, 2020 at 7:38 am

    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?

    Reply
  40. kudvenkat Posted on July 7, 2020 at 7:38 am

    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.

    Reply
  41. TAN YEW MENG Posted on July 7, 2020 at 7:38 am

    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.

    Reply
  42. maheshkumardsi Posted on July 7, 2020 at 7:38 am

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

    Reply
  43. Dhaval Jaiswal Posted on July 7, 2020 at 7:38 am

    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….

    Reply
  44. kudvenkat Posted on July 7, 2020 at 7:38 am

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

    Reply
  45. Dhaval Jaiswal Posted on July 7, 2020 at 7:38 am

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

    Reply
  46. Dhaval Jaiswal Posted on July 7, 2020 at 7:38 am

    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 ??

    Reply
  47. ammu bisht Posted on July 7, 2020 at 7:38 am

    a+ for all videos

    Reply
  48. Ab S Posted on July 7, 2020 at 7:38 am

    Thanks for the sharing and helping the comunity

    Reply
LEAVE A COMMENT