"foreach (var Data in Model)" does not work. I get the following error: "CS1579 foreach statement cannot operate on variables of type 'IndexModel' because 'IndexModel' does not contain a public instance or extension definition for 'GetEnumerator'" I am on Visual Studio 2022. Is there another object I can reference. I have tried many, to no avail.
Hey great video, haven't had any problems until 14:34 . For some reason i can't add "Model" in there, i'm sure i followed every step but i can't seem to add "Model". Would you help me out please ?
@@CSharpCodeAcademy First of all, thank you for answering. Secondly, i did try with your code that was in the description, but it still gave me the same error. I can't seem to type Model in there.
@@CSharpCodeAcademy still the same error unfortunately. I have Microsoft.sqlserver.types and system.data.sqlclient installed but still doesn't work. Do I need to install something else ?
Oh, also, could you make a follow-up to this video on how to do pagination with the database you've already displayed? I'm currently doing an intership in a company and I have to display data from a database like what's on this video, and I'd like to put it in multiple pages
Definitely you can create other types, it depends on what you are fetching and what you'll do with the data, in this tutorial we are fetching text data and we need only string data to display so there are all string types.
@@CSharpCodeAcademy Can You give some samples how to do that? Some link? I'm asking because in this video ExecuterReader has limited number of methods. One of them is toString(). And how to make a conversion to other format, for exaple decimal, but first of all I mean byte, or IFile, Image etc.?
it is display this error to me why ? SqlException: Incorrect syntax near 'Time'. System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action wrapCloseInAction)
Hi, thanks a lot for the video. I am new to this, so bare with me regarding my question. I am trying this out using Visual Studio 2019 mac. I was following this video step by step and so far so good until I reach the timeline at 7.30. I don't find option "Resource" in the Visual Studio 2019 mac version. Can you please HELP ME? Thanks a lot.
i have same probleme but me i have a warning with Microsoft.SqlServer.Types. after that i have an exception with con.ConnectionString = Data_Grid.Properties.Resources.ConnectionString;
Great video, very clear and informative, though a few comments on what you're doing would be nice for a beginner like me... Also it would be nice to have the source code for training purposes, otherwise great job !
Very helpful - thank you. Would it be possible for a user to select the table to be display via a dropdown menu for example? Do you have any guidance for this? Thanks again.
Thanks so much more for the video, you might have literally save my A level, however when I try and open the page with the table on it doesn't load and in the code it says: System.Data.SqlClient.SqlException: 'Windows logins are not supported in this version of SQL Server.' This is a long shot for help but thought I might aswell try, thank you so much either way.
@@CSharpCodeAcademy I'm really sorry but I'm very new to this, where do I change that, its not in the resources file is it? sorry again for my lack of knowledge edit: or is this the "settings" of the actual database? edit edit: I just figured it out, Thank you soo so much again, I straight up would have failed my project without this
thanks so much it's very helpful, but, how can i connect with a db with user and password from sql server authentication using the resources file??... please, can you aswer??
Thanks for your feedback, I'll try my best to improve it for future videos. However in case, the tutorial becomes complicated, you can get the source code from the Github repository and you can find the link in the video description.
I just saw for few seconds .
Welcome music remembered my every day morning.
I think we don't value where we are.
Thank you.
Honestly, God richly bless you. You’re doing his work. Just saved me!
I want to send the retrieved data to Angular project is it possible . If possible how ?
"foreach (var Data in Model)" does not work.
I get the following error:
"CS1579 foreach statement cannot operate on variables of type 'IndexModel' because 'IndexModel' does not contain a public instance or extension definition for 'GetEnumerator'"
I am on Visual Studio 2022. Is there another object I can reference. I have tried many, to no avail.
It is osooom, but i didnt get where u get the "Model" :/ im just learning
Thank you so much, this was the most helpful video.
Why do I have this error? (No parameterless constructor defined for this object)
Hey this video was amazing, perfect pace, its worht atleast 4 Pluralsight videos content wise. Thx again and greetings from Sweden, cheers
Glad you liked it!
i like the background music.
謝謝你的教學視頻，我學會了
great tuto, just straight to the point ty !
wonderfull video, it really helped me alot...thanks👍
Glad to hear that!
Hey great video, haven't had any problems until 14:34 . For some reason i can't add "Model" in there, i'm sure i followed every step but i can't seem to add "Model". Would you help me out please ?
in the description you'll find source code link, get the code from github repository and try to compare.
@@CSharpCodeAcademy First of all, thank you for answering. Secondly, i did try with your code that was in the description, but it still gave me the same error. I can't seem to type Model in there.
use @{ try to type inside these parenthesis }
@@CSharpCodeAcademy still the same error unfortunately. I have Microsoft.sqlserver.types and system.data.sqlclient installed but still doesn't work. Do I need to install something else ?
I have the same error, if you find how to fix it please tell me
Oh, also, could you make a follow-up to this video on how to do pagination with the database you've already displayed? I'm currently doing an intership in a company and I have to display data from a database like what's on this video, and I'd like to put it in multiple pages
Best of luck for your internship and i'll upload video on pagination soon.
@@CSharpCodeAcademy Thank you very much !
I am glad to see your videos. I hope you will upload other videos that relate that. Thanks
I will try my best
Cool..nice work
Thanks!
Hi great video, May i know how to make a hyperlink on the certain collumn?
thanks for this video. iit's really helpful to me.
Glad to hear that
What about other types not only string, if I want to fetch int or (what's more difficult) varbinary, image or file?
Definitely you can create other types, it depends on what you are fetching and what you'll do with the data, in this tutorial we are fetching text data and we need only string data to display so there are all string types.
@@CSharpCodeAcademy Can You give some samples how to do that? Some link? I'm asking because in this video ExecuterReader has limited number of methods. One of them is toString(). And how to make a conversion to other format, for exaple decimal, but first of all I mean byte, or IFile, Image etc.?
Hello your video is awesome but I cannot find nugget package on visual studio 2022
it is display this error to me why ? SqlException: Incorrect syntax near 'Time'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action wrapCloseInAction)
your sql query has incorrect syntax
@@CSharpCodeAcademy THANK YOU dear now it is work
Hi, thanks a lot for the video. I am new to this, so bare with me regarding my question. I am trying this out using Visual Studio 2019 mac. I was following this video step by step and so far so good until I reach the timeline at 7.30. I don't find option "Resource" in the Visual Studio 2019 mac version. Can you please HELP ME? Thanks a lot.
That is your personal problem😮
Great video, I learned a lot. Thank you !
Glad it was helpful!
I'm just beginner in asp.net.
Are asp.net and asp.net core the same or different? And what is mean by MVC?
I'd recommend you to read about .Net Framework & .Net Core and MVC is software architectural pattern,
hello please i have the error "System.Data.SqlClient.SqlException: 'Windows logins are not supported in this version of SQL Server." Can you help me?
are you trying to connect to Azure Sql Db?
i have same probleme but me i have a warning with Microsoft.SqlServer.Types. after that i have an exception with con.ConnectionString = Data_Grid.Properties.Resources.ConnectionString;
Nice & Helpful Video
Thanks for watching
Great video, very clear and informative, though a few comments on what you're doing would be nice for a beginner like me... Also it would be nice to have the source code for training purposes, otherwise great job !
Thanks, will do!
Check OUT, Source Code Link Updated
Thank you !
Please can share db and source code project? Thanks you!
Very helpful - thank you. Would it be possible for a user to select the table to be display via a dropdown menu for example? Do you have any guidance for this? Thanks again.
Do you want to display data based on dropdown selection? Correct me if I'm wrong
Correct, display as in the video but let the user choose what table is displayed (tables would be identical headers but different data within). Thanks
use ajax call to call method & fetch data from controller and use some JS to remove old data & add new data in the table.
Thanks for your reply. Do you have any example of this or point in direction of some example for this?
we demands a short video on drop down(table attributes" :)
How to add search box for searching record from local browser data.
Define a method inside a controller and make ajax call to get data
@@CSharpCodeAcademy can you share me a demo of that how to call ajax to get data?
Sure, I'll post it
@@CSharpCodeAcademy okay thanks
Thank you very much
You are welcome
excellent
Thanks so much more for the video, you might have literally save my A level, however when I try and open the page with the table on it doesn't load and in the code it says:
System.Data.SqlClient.SqlException: 'Windows logins are not supported in this version of SQL Server.'
This is a long shot for help but thought I might aswell try, thank you so much either way.
Try the connection string without the authentication, I mean use trusted connection = true instead the user & pass
@@CSharpCodeAcademy I'm really sorry but I'm very new to this, where do I change that, its not in the resources file is it? sorry again for my lack of knowledge
edit: or is this the "settings" of the actual database?
edit edit: I just figured it out, Thank you soo so much again, I straight up would have failed my project without this
Thanks ❤️❤️❤️❤️❤️❤️
thanks so much it's very helpful, but, how can i connect with a db with user and password from sql server authentication using the resources file??... please, can you aswer??
Here is the connection string format,
Server=YouServerAddress; Database=databaseName;User Id=YourUsername; Password= YourPassword;
@@CSharpCodeAcademy thank you so much!! you're amazing
Want you to teach
how to consume Authantication with
web service soap asmx 😢 asp.net core mvc
Thank you for the video.How to pagging the data ?
check out this video th-cam.com/video/U0zYxZ6OzDM/w-d-xo.html
This video is great.
Thank you great job
nice video, can you please make video on login by Microsoft and Amazon in .netcore
I'll try to publish soon, stay tuned.
OMG , 20 Minutes only to write fetch data code!!! . when you host your server visitor will drinks coffee during fetching.
Thank you 🙏❤🌹
Thanks a ton!!!
Glad it helped!
please stop the music
press "M" to stop the music 😉
honestly this was way too complicated to follow and had multiple errors along the way for me
Thanks for your feedback, I'll try my best to improve it for future videos. However in case, the tutorial becomes complicated, you can get the source code from the Github repository and you can find the link in the video description.
I would really like it if there was no music, it's loud and distracting
Press M to get rid of it 😅
@@CSharpCodeAcademy But... then I can't hear the voiceover???