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

[@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

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

[@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

[@pinkigour4939]

Your teaching way is ingenious ❤❤❤

[@CodeWithGopi]

Thanks for your valuable feedback

[@arunstreaming]

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

[@qasimzaildar2862]

Thank you sir thanks a lot , one of best tutorial

[@CodeWithGopi]

Thanks for your valuable feedback and support 👍

[@raymondgoh3047]

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

[@SufiyanJamadar-t9h]

hey anyone has the code that he used in the initially to create the employee table

[@CodeWithGopi]

Link available in the description

[@poojasoni9993]

What is no lock in sql

[@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!!

[@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

[@SwatiPriyankaMohanty]

getting edit id 0.how to fix it

[@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

[@SufiyanJamadar-t9h]

i have also the same dought

[@namohoang8292]

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

[@TarzanGamingYT555]

Same doubt

[@debabratasahoo2588]

I also same doubt

[@TusharKumar-rr8tb]

Same doubt

[@SufiyanJamadar-t9h]

yes i have also the same dought

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

[@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

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

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

[@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 ua-cam.com/video/MOldkUAkfcg/v-deo.html

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

[@draveshlokhande8506]

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

[@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!!

[@madhav_drone]

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

[@TarzanGamingYT555]

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

[@NaikIsKing]

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

[@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

[@TheWizardOnTheWeb]

Where i can get the query

[@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

[@asitraining7664]

Louder!

[@CodeWithGopi]

Sure. Will improve on this

[@rabishankargupta6356]

try to speak a bit loude

[@CodeWithGopi]

Sure thanks for your valuable feedback and support 👍

[@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

[@alibaba-ez9un]

pls give the source code

[@shirshantgupta6227]

why i getting Error: unable to save data

[@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

[@shwetadamakale5427]

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