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

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 64

  • @s.f.a7615
    @s.f.a7615 7 місяців тому +1

    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

  • @ManishKumar-yo7jz
    @ManishKumar-yo7jz 7 місяців тому +1

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

  • @pinkigour4939
    @pinkigour4939 Рік тому +2

    Your teaching way is ingenious ❤❤❤

  • @MUSICA1742
    @MUSICA1742 8 місяців тому +1

    Great! Thank you for the explanation

    • @CodeWithGopi
      @CodeWithGopi  8 місяців тому

      Thanks for your valuable feedback and support

    • @CodeWithGopi
      @CodeWithGopi  4 місяці тому

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

  • @qasimzaildar2862
    @qasimzaildar2862 Рік тому +1

    Thank you sir thanks a lot , one of best tutorial

    • @CodeWithGopi
      @CodeWithGopi  Рік тому

      Thanks for your valuable feedback and support 👍

  • @nirmalthomas8838
    @nirmalthomas8838 10 місяців тому +2

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

    • @CodeWithGopi
      @CodeWithGopi  10 місяців тому +1

      Thanks for your valuable feedback and support.

    • @sumitmaske1461
      @sumitmaske1461 7 місяців тому

      I'm totally agree with you

  • @advX
    @advX 5 місяців тому

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

    • @CodeWithGopi
      @CodeWithGopi  5 місяців тому

      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.

  • @namohoang8292
    @namohoang8292 Рік тому +2

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

  • @aravinthaanswaminaathanraj6030
    @aravinthaanswaminaathanraj6030 7 місяців тому +1

    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
      @CodeWithGopi  7 місяців тому +1

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

    • @aravinthaanswaminaathanraj6030
      @aravinthaanswaminaathanraj6030 7 місяців тому

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

  • @raymondgoh3047
    @raymondgoh3047 7 місяців тому

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

  • @sumitmaske1461
    @sumitmaske1461 7 місяців тому +1

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

    • @CodeWithGopi
      @CodeWithGopi  7 місяців тому +1

      What is the error

    • @sumitmaske1461
      @sumitmaske1461 7 місяців тому

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

  • @aravinthaanswaminaathanraj6030
    @aravinthaanswaminaathanraj6030 7 місяців тому +1

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

    • @CodeWithGopi
      @CodeWithGopi  7 місяців тому +1

      Please try this and let me know if you have any issues ua-cam.com/video/MOldkUAkfcg/v-deo.html

    • @aravinthaanswaminaathanraj6030
      @aravinthaanswaminaathanraj6030 7 місяців тому

      @@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
      @aravinthaanswaminaathanraj6030 7 місяців тому

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

  • @andressierra9260
    @andressierra9260 Рік тому +1

    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

  • @creightonchingarande7542
    @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();

  • @shwetadamakale5427
    @shwetadamakale5427 3 місяці тому

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

  • @NaikIsKing
    @NaikIsKing Рік тому

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

  • @aravinthaanswaminaathanraj6030
    @aravinthaanswaminaathanraj6030 7 місяців тому

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

  • @madhav_drone
    @madhav_drone 7 місяців тому

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

  • @draveshlokhande8506
    @draveshlokhande8506 Рік тому

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

  • @rodrigoklein
    @rodrigoklein Рік тому +1

    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-iz9uz
      @Raj-iz9uz Рік тому +1

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

    • @CodeWithGopi
      @CodeWithGopi  Рік тому +1

      Sp is not available in selected db

  • @tufaneser1053
    @tufaneser1053 8 місяців тому +1

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

    • @CodeWithGopi
      @CodeWithGopi  8 місяців тому

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

    • @CodeWithGopi
      @CodeWithGopi  8 місяців тому +1

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

    • @tufaneser1053
      @tufaneser1053 8 місяців тому

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

    • @tufaneser1053
      @tufaneser1053 8 місяців тому

      ??@@CodeWithGopi

  • @oguzhannejatkarabas7139
    @oguzhannejatkarabas7139 Рік тому +1

    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

  • @VinSetty
    @VinSetty 4 місяці тому

    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
      @VinSetty 4 місяці тому

      previous videos will not be there sir

  • @TheWizardOnTheWeb
    @TheWizardOnTheWeb Рік тому

    Where i can get the query

  • @asitraining7664
    @asitraining7664 Рік тому +1

    Louder!

  • @rabishankargupta6356
    @rabishankargupta6356 2 місяці тому +1

    try to speak a bit loude

    • @CodeWithGopi
      @CodeWithGopi  Місяць тому

      Sure thanks for your valuable feedback and support 👍

  • @shirshantgupta6227
    @shirshantgupta6227 Рік тому

    why i getting Error: unable to save data

  • @alibaba-ez9un
    @alibaba-ez9un Рік тому

    pls give the source code

  • @arghyamallick7357
    @arghyamallick7357 Рік тому +1

    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