Create ASP.NET Core Web Application With SQL Server Database Connection and CRUD Operations

[@castro4694]

These types of simple apps using multiple technologies are a must for Beginners in any IT field. Most classes give extremely intense courses os too many topics and never get around to putting them together with a simple app like this one. Thank you so much!.

[@chrono105gutierrezhernande8]

Its a very good work, i have a test for a interview and all this video help me to understand and make so good the test if I earn the job you will have all my respect, more than now. this is a very good channel

[@MichaelAMalry-ry7hg]

Thank you for this brilliant tutorial. Very clear, easy to follow, and no fluff -- just straight to the point! 👍👍

[@Warpgatez]

I thought you said “sexist message”. I was looking at something else and then was like “wtf that turned weird fast.” Then saw what you named the variable lol. Very detailed explanation of making a app like this.

[@CforChillandCheese]

I subscribed to your channel. I found that you are one of the best educator and executer on KZbin beside codecamp. I might subscribe your udemy course soon if I land my first job as a programmer. Hope you keep this channel alive. I am proud of you.

[@MichaGrobecki-yh1lx]

This is like the best tutorial I have seen on the internet about this topic. God bless you homie!

[@nguyenduynhan3549]

Exactly. I searched all over the internet and found this tutorial to be the best.

[@TheBerdu]

Yes great job... before people dives into this Entity Framework issues its good to see & learn the old method. Its good for old school Asp and php programmers :)

[@oswaldovirto5896]

Thank you so much. This is one of the best tutorials I've ever followed. I shared this with my friends, liked, and subscribed!

[@DebasmitSamal294]

One of the best video. This is called Technical clarity. Awesome job my friend. Plz keep it up. Thank u

[@empoyasilo52]

This is the type of tutorial that i was looking for.... Thank you for your video! I learned a lot!!!

[@yusufmutawa8785]

درس رائع الف شكر لك Thank you very much Большое спасибо

[@aggelospapapanos5707]

Your voice is like a russians scientist. Keep it up, Very well Explained Tutorials.

[@Boiseman100]

I am very happy to have found this link. within a short time i was able to develop a basic application. thanks a ton for doing this

[@marcelobeani]

Thank you my good Sr. This video was just amazing. Helped me here a lot. Cheers from Brazil devs.

[@Loomy65]

Very clear tutorial and excellent explanation. Thanks mate

[@yakupdogan6279]

This is fool proof tutorial, thanks for your good work.

[@tristanrosales3750]

I have a problem with edit action. i cant edit anything on the form. it says it must be declare the scalar variable "@addressWHERE"..

[@akarshitdhiman5364]

Give a space between double quote and @

[@ПолинаСмирнова-т1к]

Give a space after "@address". Will be "... address=@address " + "WHERE ..."

[@AliAmer23212]

I've got a problem with the edit action , I can't submit any editing on the data and redirecting to index page , it saye incorrect syntax near 'name' but I don't have any programming error in visual studio

[@ayushkumar-ym4oz]

I need a similar setup video demonstrating CRUD operations and database integration in Visual Studio Code, utilizing the same configurations. Please provide

[@ayushkumar-ym4oz]

using vs code

[@amitylab9330]

Thank you for sharing awesome VDO. I cannot waiting for a new section.

[@thetruereality2]

Thank you for your much needed help, bless you. May your channel grow and become very successful.

[@unityvictor787]

Thanks for the tutorial, It's very clear to understand.

[@BenState]

Well done and beautiful accent. From Australia.

[@dpharaoh5297]

I have done all the steps until the minute 16:25. When i run the program, my table data do not appear in the table in the clients page, please help!!

[@nickoalbes6546]

Im having the same problem

[@hiya56677]

Same problem

[@dpharaoh5297]

@@hiya56677 I think the problem was with my PC settings + some minor errors in my code. Some database services were turned off on my PC.

[@Pikachu_1602]

bro did u found the solution any??

[@dpharaoh5297]

@@Pikachu_1602 I honestly don't remember 💀. There was a solution, I remember giving my project to a specialist and he fixed the problem. He debugged the code a bit by bit until he found the problem. So maybe try debugging until it works. But I honestly don't remember what was the problem, it has been a very long time sorry🙁.

[@cezar_akkaya]

thank you, promoted my exam!

[@michaeljohntabique8677]

Very clear tutorial for a beginner like me.

[@thishandharmakeerthi5327]

Straight to the point! Keep up the good work.

[@imsmartsolution4721]

Great Share My Friend, Full Support for you.

[@hussainal-harhoosh4588]

Hi dear, Thanks for the amazing video I followed your instruction, but in time 16:30 when I tried to running the app, it showing only the column names, kindly note I have fill the table before, it should retrieve it ! I used also Microsoft SQL Server Express, so what do you think about that ?

[@harshalipachchigar4715]

I am also getting the same error.How did u resolve it?

[@hussainal-harhoosh4588]

@@harshalipachchigar4715 no still, I repeat all steps again and again, but it shown empty

[@harshalipachchigar4715]

@@hussainal-harhoosh4588 Same happening with me I am not getting the data

[@anupamshukla4287]

I'm also. Not getting data what essu anyone have answer so please tell me I write all code carefully no error found my code but in output we didn't get my data what the essuu

[@codemap6177]

remove the try, catch and trace your code, make sure by including the ClientInfo class inside the public class IndexModel, and this will work with you.

[@tunahanuysal2628]

he made very easy to understand, thank you very much

[@isaacmihaeli3261]

Well, the tutorial is great. As an experienced programmer in ASP pages, I can't understand why in the Razor pages we have to link the controllers in an "old" method. I did it with the previous versions. Now I just connect to the database once and set up the controllers on the pages.

[@scientist100]

Please share as this connection seems reduntant.

[@Diamond-vy1lx]

I love your accent and wow this looks like it will be really helpful for what I have to do

[@NicahMariano]

Great easy to follow tutorial! Thanks!

[@TheJoelBowl]

Great Video!!! Just a question though. How do you reference the Id in the EDIT OnGet SQL Query when it is hidden on the main page. That is, I want to hide the Id on the main page, but use it in the update page

[@seanmcpadden1831]

href="/Clients/Edit?id=@item.id" this part of the Edit button on the main page is where it is referenced for your edit page. This really tripped me up because I didn't add ?id=@item.id on the main page.

[@drario11]

@@seanmcpadden1831 thanks, got it all worked out. can't have any errors, synthesis, This video helped me a lot, how to use the right way to do it, the database connection.

[@utkarshapuranik6510]

​@@seanmcpadden1831 thanks a lot , i was struggling whole day for it ..

[@unsalsevinc5969]

@@seanmcpadden1831 thank you

[@DrBeast100]

@seanmcpadden1831 thanks, that was helpful!

[@nastyakrasnoshapka2948]

Thank you! Video was clear and extremely helpful, saved lots of my time

[@Zara2379M]

The video is great, I hope you will be successful and victorious

[@gatormark]

This is exactly what I was looking for. Thanks

[@katimboallan4605]

What a nice video. Easy to learn. Thx

[@vidyadhartanksale1892]

Thank you for this Brilliant tutorial. I need this for my feature..

[@hasancancevahir8706]

i have a problem about that situation 16:20 .No errors from the console whatsoever but i cant see my data on the Clients page. Any help please?

[@hasancancevahir8706]

i was just wrote my sql password wrong :)

[@saisankeerthpalakurthy2385]

@@hasancancevahir8706 me too loll

[@BurakOzgurr]

sql string add TrustServerCertificate=True

[@axelarlx]

@@BurakOzgurr where i need to put this line???

[@squantrill]

Hi getting and error at 16:23 when you first preview the webpage to list the client Exception thrown: 'System.Data.SqlClient.SqlException' in System.Data.SqlClient.dll. Please advise. Thank you

[@sithvlv8391]

Thank you so much, this is very clear and can help me to learn my web app.

[@cman2458]

Actually a good tutorial. Thank you.

[@cman2458]

Do you by any chance know how to filter the list? There are many tutorials using CRUD Pages with LINQ but not much along the SQL Path.

[@amirzamirsoft_khawrai]

Amazing and very easy to understand

[@russsharp3767]

I've tried several times to apply this technique to my current project, by following the video step-by-step, sentence-by-sentence, but when I click the new page, it just shows the page title, column headings, and the button to add a new record. (It doesn't display the existing records from my SQL Server table. Everything else works perfectly up to that point while following the instructions in the video.) I have been trying to figure out what I'm missing for days now. Any hints would be much appreciated.

[@daviddragan610]

I was having the same issue, check that the "String connectionString = "Data Source=.\\[your server connection data source *must be copied from properties, not title of database*]" and "String sql = "SELECT * FROM [name of your table]";" statements are correct

[@alexis_withluv]

same issue T_T Did you perhaps found out what was missing?

[@GamerX-qn7ou]

start the project in debugging mode and you will see exactly what the errors are, took me a while to figure since I am new, for me it had to do with the security certificate, if its the same for you try adding "Trust Server Certificate=True" to you connection string

[@kelpiig6141]

@russsharp3767 @daviddragan610 @GamerX-qn7ou I have tried all of the methos you guys provide, yet my SQL table is still not displaying :(

[@kelpiig6141]

figured it out. I had to delete the "Trust Server Certificate" from the connection string...weird

[@adheeshburthia3584]

Just what I needed, you earned a subscriber...

[@joaovictor-mz1wz]

Dude, you are amazing!! I had a problem when displaying the database on the website, I didn't understand why...

[@Aditi67885]

Same with me

[@utkarshapuranik6510]

facing same issue , did you resolved it?

[@hjalabderrazak489]

great video Mr.Daldoul keep it up

[@chandrakarthikeyan252]

Thank you for this excellent tutorial....

[@igorkamerzan]

Thank you for your brilliant tutorial, keep going, pls!

[@mberymounana588]

Hi guy! You are great. Great and clear work. Thank's a lot!!!

[@hermanuslawing5923]

Thankyou so much bro this is really helpfull 🙏

[@adamrashid9146]

Thankyou so much, very helpful and concise

[@lukaszsiema3643]

Hi, can you give me the whole 47 line? It's cut and I cant see what it is written there. 22:30 The one starting with

[@BoostMyTool]

I am using bootstrap alert, you can search for bootstrap alert version 5 to find the full code of the alert. Anyway, this is line 47:

[@kathirinfotech]

Sir, Thanks for the Video. I have followed Each Step perfectly. But the Table Header only displayed @16:35 inside the @foreach loop its not going. any help could you please do me sir, Please

[@MANISH-ug1kj]

same problem, how did you resolved?

[@kathirinfotech]

@@MANISH-ug1kj Hi Bro, i have started learning about c#. after that, now i can able to create softwares in my own. i suggest you to start learning bro. Thank you

[@MANISH-ug1kj]

@@kathirinfotech resource??

[@matthewellis9885]

I've got as far as 16:30 having followed your precise instructions yet when the page opens and I go to the 'Clients' page there's no data? No errors from the console whatsoever. Any help please?

[@hasancancevahir8706]

Mee too. İ could not find anything about it.

[@anands8999]

I'm facing the same issue

[@matthewellis9885]

Looks like a few of us are having the same issue. It would be nice to get some help from the creator.

[@huuthangnguyen5032]

@@matthewellis9885 change "Password=************" in const connectionString to "Password=YourPassword"

[@matthewellis9885]

@@huuthangnguyen5032 Thank you, that worked. I've added an extra folder for another page I want and used the same connection string in the index page with a similar query "SELECT * FROM Album" (different table name) but when I run I get no results - shows columns but no data. If I go back to the first page I created as part of this demo I get all my info.

[@sergevandeputte7587]

Hi, great tutorial. Where can I find the source code?

[@spacekidgaming6654]

Thank you so much for this, it really helped with my assignment

[@poornachandrarao5142]

Hi, can you please help me with this, i've followed all the stpes but i'm facing issue while click on edit and delete options.

[@Heavvenz]

@@poornachandrarao5142 same did you ever figure it out?

[@MateusStefens]

Thank you man, you save my life

[@syedzawarshah1343]

Sir it is just awesome 👍

[@bzcal]

try this , but I stuck in displaying data in the table, my code the same with yours? is there I missed?

[@sid3384]

How u convert string to int? 11:20

[@seanmcpadden1831]

Just take off the " " + and it works fine

[@HaploBartow]

at 16:30 when I run my application, my table is not getting filled. I am using a SQL connection to a SQL server and I know the connection string is correct. What am I missing? Debug statements inside the beginning of the OnGet() function are never being reached.

[@HaploBartow]

Nevermind, I had an error with importing Int64 as String and also wasn't handling null DB records from my database. User error!

[@MariaClara-rb3xd]

Im having the same issue, what did you do to fix it?? I've been trying to fix it for literally hours

[@HaploBartow]

@@MariaClara-rb3xd See my comment above. I had an error with data types, importing in64 as string and not handling null values correctly.

[@Rundtj45]

In my case (16:59 min) shows List of Clients are empty ? What is the problemm? pls give me any suggestion

[@sahannawarathne449]

Remove the created date coloumn from the database

[@Pikachu_1602]

@@sahannawarathne449 it's still not working bro!

[@geeseeoh]

Thank you. I just found this video and was able to follow it without any issues!

[@ahlamabdaljawwad3583]

thank you so much , you help meee to solve a task !!!

[@enescelebi2411]

Must declare the scalar variable "@addressWHERE". how to fix that error

[@Eferson15]

You need to add a space after address=@address. Otherwise it thinks its all one word

[@CarConsoleCulture]

thks ma' man, u actually same my carreer hahaha, i lit need exactly do this

[@GustavoAMD]

I love your accent man

[@jesuseduardo5658]

Hi, I'm stucked in the clients table view, when I run the app, the page it not shows the data from database on the table. I've been checking what's wrong in the code.

[@asmafekroun-yh8fy]

I have a same probleme, I did exactly the same thing butthe page it not shows the data from database on the table

[@grbsql]

Excelente video. Muchas gracias por compartirlo. Felicitaciones

[@ahlamabdaljawwad3583]

you are the best !!!!!!!!!!!!!!!!!!!!!!

[@minishaji9285]

Very Good presentation. Structure to follow. Pls provide the vedios for publishing in IIS for sql server data

[@jeffsouza9040]

Great tutorial. Thanks. One question. The bootstrap styles are applying to the master layout page, but not the individual razor pages. Am I doing something wrong?

[@sawairasana]

Sir it is a wonderful tutorial ... i am working on razor pages for the 1st time. can you kindly tell me if you have a tutorial on Authentication and authorization such that two users with same roles cant alter eachother records.

[@shriraamnd8239]

After adding the edit model and html page when i try to click edit button it gives me http 404 error .can you please let know if any nuget packages needed to be added or am i missing something ,because i watched the video closely and did exactly as same but while clcking edit getting http 404 error ..

[@zmb6991]

Great job thanks for sharing.

[@AntoninaPanayiotou]

14:38 where is the Model and the listClients that are defined?

[@MateusStefens]

same here. Do you fixed?

[@piyush4830]

sir, first of all a lot of thanks to you . I was asking that do we need to add a link to the bootstrap or is there inuilt bootstrap packages ? bcoz in that html file you were using bootstrap classes so ...?

[@kenmtb]

Great video, thank you. Question: I am new to web dev. Is this a common way to connect a web app to a database? I see sooooo many technologies used.

[@ellonmusketwannabe2201]

i have problem with the edit part can you help me ? it doesnt get client id

[@sadiquej]

wonderful , please do one mode video, how to do the on the website instead of website

[@af8000]

Very nice work, but how can we search for some information when the list of clients is so big, please advice, thanks

[@Abhis_Workplace]

Great video. Very easy to understand . just wanted to know more about the shortcut keys used at 11:09

[@debergi340]

It's called video cut

[@asadullah-bq7bj]

Sir your teaching method is outstanding can you pleaze make a complete tutorial on asp.net core mvc 6

[@saraalharbi1510]

Thank you for sharing, I've a question could I insert multiple rows by importing an excel sheet?

[@jaliyaat321]

Nice Tutorials

[@danwelch557]

At 16:35 my list of clients don't show up. Help

[@HammadHussain1]

Same, I'm not sure if he will solve this issie

[@ohadbekhor2167]

Make sure all your code is correct and check the sql connection & code

[@prasenjitjana1009]

Thanks for the tutorial but some places code didn't even we can see so its hard to solve and copy and pasting is a quick method but you should at least let us see what you are implementing . Again thanks for sharing

[@BoostMyTool]

I think that the hidden parts of the code are easy to guess. for example, the connection string should be copied as explained, so you don't need to see my code. also, the html buttons can be copied from the documentation website of bootstrap

[@danieleliyahu3014]

Thank u so much, such a great tutorial!!

[@nealdorelis5703]

Nice ! Could you continue this app showing how to print the data and how to make a dash broad of graphical with it ?

[@dhruvrajendranath9436]

I'm facing an issue. The page is loading but despite creating db connection and foreach. Table is blank

[@MrMouseGood]

me too

[@qistina3609]

hello, im having the same problem, did you ever found a solution?

[@alfareaz]

Excellent! Is it the last? No series video to THIS ONE?

[@drario11]

16:42 I tried to do it, but I couldn't, my code didn't show an error, but when it goes to show the list of customers, the records don't appear

[@drario11]

I can understand the video. you can't miss anything very good class😂😂🤣😆

[@saisankeerthpalakurthy2385]

@@drario11 How bro ? Can you explain me ?

[@StriveforGainz]

Amazing video! Thank you!

[@parakimax]

Don't you think that the edit form is very similar to the add form? Wouldn't it be better to make one universal form for both of these operations?

[@asmafekroun-yh8fy]

Hello, thank you for this excellent video, just a question I did exactly the same thing but it doesn't show the result of my query, no error message

[@ConexoesParanormais]

It helped me a lot, could you teach me how to save pdf files with the same project, I'm searching and I can't find anything about it!

[@jevonne8160]

how would i connect on the mac my sql server studio management is running in a docker container ?

[@isaacmihaeli3261]

kudos for the excellent tutorial. I had a problem when I run the application the client table was not detected. It happens when I go to the "while" loop.

[@AntoninaPanayiotou]

also what if our id is how to do the POST method for integers and decimals?

[@hasanmougharbel8030]

Hey there,keep up the great work in your channel. I have only a general enquiry as a newbie sql learner. Could i channel shopify live data into an sql application?(This should be an application developed for a company of 50 employees mainly for the sake of generating reports and analytics)) Is this an easy process to undertake as a sql beginner? What should i keep in mind and what are the tools or softwares that i should work with right from the beginning. For notice, I made my mind to work with microsoft sql server, also our company has a dedicated server. Thanks for taking care of my enquiry.

[@DeepThoughts_]

Yes, it is possible to channel Shopify live data into an SQL application. This can be done by integrating the Shopify API with your SQL application, which will allow you to extract data from Shopify and store it in your SQL database. As a SQL beginner, this may not be an easy process. However, there are many resources available to help you learn and implement this integration. You can start by reading Shopify's API documentation and learning the basics of SQL. When integrating Shopify with SQL, there are a few things you should keep in mind: Data security: Ensure that the data being transferred between Shopify and your SQL database is secure and encrypted. Data accuracy: Ensure that the data being transferred is accurate and reliable. This can be done by setting up regular data validation and verification processes. Data privacy: Ensure that you are compliant with data privacy regulations when collecting and storing customer data. In terms of tools and software, you can use Microsoft SQL Server to store and manage your data. You can also use tools such as Power BI or Tableau to create reports and visualizations based on the data. Overall, integrating Shopify with SQL can be a complex process, but with the right resources and tools, it is possible to generate valuable reports and analytics for your company