Full CRUD Operations Using ASP.NET Core And ADO.NET | CRUD with SQL Stored Procedure | .Net 7.0

[@MUSICA1742]

Great! Thank you for the explanation

[@CodeWithGopi]

Thanks for your valuable feedback and support

[@CodeWithGopi]

Thank you for your feedback and support! If you're able, please consider supporting my channel by becoming a member or using Super Thanks.

[@pinkigour4939]

Your teaching way is ingenious ❤❤❤

[@CodeWithGopi]

Thanks for your valuable feedback

[@raymondgoh3047]

May I know why do we need to use try and catch in usp_insert-employeee as there was no condition?

[@kowsalyal6594]

sir kindly reply me where the link of create employe when i click create employee it is showing error. this localhost can't be found

[@CodeWithGopi]

Pls Check the Index

[@aravinthaanswaminaathanraj6030]

Hi, I'm getting the same message "No Employees available at this moment" even-though I'm able to add data's via Create button or be it in the backend. How to resolve it ? Why the data's are not displayed n the employee Index ?

[@CodeWithGopi]

Hi, debug and check whether the data is coming from the DB

[@aravinthaanswaminaathanraj6030]

@@CodeWithGopi Yeah, got it. Thanks. return View(employees); missed to include employees while returning the view!!

[@poojasoni9993]

What is no lock in sql

[@ManishKumar-yo7jz]

Informational video 👍🏻👍🏻 But You forget to write return ; Statement in If(!modelstate.isvalid) { Tempdata["errormsg"]=......... Return; } In [HttpPost] create action method.

[@CodeWithGopi]

Thanks for the update

[@arunstreaming]

There is no link which explain view creation. If there any, plz share it. Thank you

[@namohoang8292]

Is there any SQL code at the beginning? The WITH line is finished ON... what else?

[@nirmalthomas8838]

Same doubt

[@debabratasahoo2588]

I also same doubt

[@TusharKumar-rr8tb]

Same doubt

[@andressierra9260]

Where can I download the script to create the employee table, there is a piece missing that I can't see on the right side please

[@CodeWithGopi]

Will share the script link.

[@andressierra9260]

@@CodeWithGopi yes, please. Thank you

[@qasimzaildar2862]

Thank you sir thanks a lot , one of best tutorial

[@CodeWithGopi]

Thanks for your valuable feedback and support 👍

[@tufaneser1053]

How can ı get this project's source codes ? I can't find it on your Github profile.

[@CodeWithGopi]

We are providing the source code for members only. If possible you can join as a member.

[@CodeWithGopi]

Thanks for taking a membership and your support. Please 🙏 share your email address and will share the source code.

[@tufaneser1053]

I guess you forgot the send to me source codes :)@@CodeWithGopi

[@tufaneser1053]

??@@CodeWithGopi

[@aravinthaanswaminaathanraj6030]

Hi, I'm getting an Error : Keyword not supported: 'trust server certificate' while running the application!! How to resolve it ??

[@CodeWithGopi]

Please try this and let me know if you have any issues kzbin.info/www/bejne/g4DPlZ6LdtCZmck

[@aravinthaanswaminaathanraj6030]

@@CodeWithGopi "Data Source=DESKTOP-XXXXXXX;Initial Catalog=CRUDWithADONet;Integrated Security=True;Encrypt=True;Trust Server Certificate=True", this is my default connection string. It still didn't work out for me.

[@aravinthaanswaminaathanraj6030]

I tried this "Trust Server Certificate=True changed to TrustServerCertificate=True", by removing the space in between, it works now.

[@sumitmaske1461]

Hi Gopi, I'm getting error when I'm trying to delete the records. Please kindly help me on this !

[@CodeWithGopi]

What is the error

[@sumitmaske1461]

@@CodeWithGopi Hey , Thanks for the reply ! issue got resolved. Basically error was model binding in DeleteConfirmed method.

[@SwatiPriyankaMohanty]

getting edit id 0.how to fix it

[@draveshlokhande8506]

Which nuget packet's are installed for this crud opreation?

[@s.f.a7615]

you said that you already explained how to create views manually step by step in previous view but i havent got it it there is no reference or address for the video and no numbering there although the video is great is easy to understand thanks

[@aravinthaanswaminaathanraj6030]

Hi, I'm getting an "Error : Model data is invalid" while trying to update the data. How to resolve it ??

[@aravinthaanswaminaathanraj6030]

@CodeWithGopi Any updates/ suggestions ?

[@rodrigoklein]

While trying to execute the Insert procedure, i got the following error: Msg 208, Level 16, State 6, Procedure usp_Insert_Time, Line 2 [Batch Start Line 26] Invalid object name 'DBO.usp_Insert_Time'. Can someone help me?

[@Raj_Vishwa1]

make sure u have changed Master database into ur database name while executing

[@CodeWithGopi]

Sp is not available in selected db

[@oguzhannejatkarabas7139]

After I did the "Read Data" part, when I started it it gives this error. Can you help ? InvalidOperationException: The view 'Index' was not found. The following locations were searched: /Views/Home/Index.cshtml /Views/Shared/Index.cshtml

[@CodeWithGopi]

View not avaliable. Pls check

[@creightonchingarande7542]

i was following along and I notice your sqlreader has no parameters how did you do that it did not work for me at all I had to do this using(SqlDataReader dr = _command.ExecuteReader()) { whil(dr.Read()) { Employee employee = new Employee(); .... employeeList.Add(employee); } } _connection.Close();

[@nileshtambe998]

Thank you had the same issue!!

[@TheWizardOnTheWeb]

Where i can get the query

[@madhav_drone]

where can i get the script added for view Kindly post it sir it will be helpful

[@nirmalthomas8838]

sir for beginners the stored procedure is tough,try to make it simple next time

[@CodeWithGopi]

Thanks for your valuable feedback and support.

[@sumitmaske1461]

I'm totally agree with you

[@VinSetty]

Hi sir..... can you please provide in previous videos like CrudwithCodeFirst and CascdingDDL project videos sir............. please sir I have based on the project one task will be there sir ............ please sir can you provide as soon as possible sir......... still I am waiting your videos links sir........ and How can I contact sir

[@VinSetty]

previous videos will not be there sir

[@NaikIsKing]

Thanks Gopi, Nice, Please share the code for this video

[@advX]

You can just use the stored procedure name in the CommandText, you can remove the square brackets ("[", "]") and the "[dbo]". Happy coding :D

[@CodeWithGopi]

Thanks for yiur valuable feedback. [] not mandatory. But if we have multiple schemas, better to use schema and performance wise also good to use schema. 🙏 pls correct me if I am wrong.

[@shirshantgupta6227]

why i getting Error: unable to save data

[@asitraining7664]

Louder!

[@CodeWithGopi]

Sure. Will improve on this

[@alibaba-ez9un]

pls give the source code

[@arghyamallick7357]

I am getting this error "InvalidOperationException: The view 'Edit' was not found. The following locations were searched: /Views/Employee/Edit.cshtml /Views/Shared/Edit.cshtml" while clicking the edit option. Please suggest

[@CodeWithGopi]

Edit View not available. Please create it and try

[@arghyamallick7357]

@@CodeWithGopi Done..

[@arghyamallick7357]

@@CodeWithGopi thanks

[@rabishankargupta6356]

try to speak a bit loude

[@CodeWithGopi]

Sure thanks for your valuable feedback and support 👍

[@shwetadamakale5427]

The type name 'models' does not exist in the type 'Employee'