Dapper CRUD – Insert Update Delete View Search With C# And Sql Server DataBase

31
29



Dapper CRUD Application With Insert Update Delete View and Search

Dapper is a lightweight micro ORM from Stack Overflow for .Net technology. Video shows how you can implement crud operations like Insert, Update, Delete, View and Search Using ms SQL server wit help of a sample project

? Best C# Book from Amazon (Affiliate)

Download Project From :

☕ Buy me a Coffee (Channel Support through Donation)

Subscribe to this channel Link to this video
➤ ➤

________________ ? Related Videos __________________
: Similar Mvc Tutorials
: Similar C# Video Tutorials

________________ ? About this Channel ______________
CodAffection – [ New videos every Monday at 12:30 PM UTC. ].
This channel is all about teaching and motivating software developers to build applications/ websites in various technologies/ programming languages like Angular, NodeJS, Asp.Net, C#, JavaScript, SQL, Python, etc.

________________ ? Social Media Links ______________
Blog :
Facebook :
Twitter :
Youtube :

________________ ? Most Recommended Books _______
Code Complete(2nd Edition) :
The Art of Computer Programming :
Clean Code :
Design Patterns :
The Pragmatic Programmer :

________________ ? Purchase for Developers _________
? Laptops
MacBook Air :
Dell XPS 9570 :
ASUS ZenBook 13 :
Lenovo Ideapad :
⌨️ Keyboard : Das 4 Professional :
?️ Mouse : VicTsing :
? Headphone : Mpow 059 Bluetooth :

________________ ? All Playlist _______________________
: Angular
: Asp.Net Core
: Node JS
: Asp.Net MVC
: Web API
: MEAN Stack
: C# Tutorial
: Asp.Net WebForm
: C# WinForm
: MS SQL
: Crystal Report
: Common C# Excercises
: CG Exercises in C Program

#CSharpTutorial #CodAffection #CodAffectionCSharpTutorial

Nguồn:https://wijstaanvooronzegrondrechten.org/

31 COMMENTS

  1. https://goo.gl/RFY5C2 : Subscribe to CodAffection
    https://goo.gl/3enre2 : How to Connect Sql Server Using C#
    https://goo.gl/3kyhnM : Dapper in Asp.Net MVC
    https://goo.gl/h7XY9G : Asp.Net MVC CRUD With jQuery

  2. Very easy to understand tutorial Sir. I am getting a great help from your videos. Thank you so very much. God bless you.

  3. System.TypeLoadException was unhandled

    HResult=-2146233054

    Message=Could not load type 'Dapper.DynamicParameters' from assembly 'dapper, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.

    Source=dapper

    TypeName=Dapper.DynamicParameters

    StackTrace:

    at dapper.Form1.btnsave_Click(Object sender, EventArgs e)

    at System.Windows.Forms.Control.OnClick(EventArgs e)

    at System.Windows.Forms.Button.OnClick(EventArgs e)

    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

    at System.Windows.Forms.Control.WndProc(Message& m)

    at System.Windows.Forms.ButtonBase.WndProc(Message& m)

    at System.Windows.Forms.Button.WndProc(Message& m)

    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

    at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

    at System.Windows.Forms.Application.Run(Form mainForm)

    at dapper.Program.Main() in c:Usersrafay khan zadadocumentsvisual studio 2015ProjectsdapperdapperProgram.cs:line 19

    at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)

    at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)

    at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()

    at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

    at System.Threading.ThreadHelper.ThreadStart()

    InnerException:

  4. This is shortest and clearest example of CRUD in C# that I saw till now. Excellent job! I'll look at your other tutorials too.

  5. I see you're using Dapper, and hence probably like the ideas of abstracting away the hard problems. You might benefit from checking out my channel, which describes Phosphorus Five, which (among other things) contains a CRUD app generator, with a MySQL database backend, allowing developers to simply "declare" their CRUD apps, in seconds, and have all the code for their CRUD apps automatically "generated" – At which point they can afterwards modify it, according to their own needs … 🙂

  6. Can you help me with this error?

    System.Data.SqlClient.SqlException: 'Error converting data type nvarchar to decimal.'

    do I need to use varchar datatype for my collumns?

  7. When I do a search it only searches one column in the gridview.  It does not search any text in any other column.  Is there a way to search for text in multiple columns?  I have four columns, Position, Name, Ext, Status in that order.  The search only searches the Name column.

  8. Great video and it works great.  Can you point me to how I would learn to auto refresh the gridview.  If one user make an entry a second user does not see that entry until they make an entry and save that entry.  I need the ability to auto refresh the gridview when multiple people are using the program at the same time and make an entry so that everyone see that new entry at the same time.

  9. In the solution explorer I have no "Solution 'DapperCRUD' (1 project)". so I cannot Right Click on it to install the Dapper. 🙁
    could you give me the solution for this problem ?
    how if i skip that step?

  10. So this might sound stupid but I have everything working but how does the end user launch the application?  I can run it through visual studio but don't know how to get the end users to launch it without using visual studio.

  11. Thanks for making this video, I have a question.  When you are creating the save button function you are typing in SqlConnection and restore the name space you are hitting ctrl+. but when I do this I do not get the dropdown of possible name spaces to select Using System.Data.SqlClient; what am I doing wrong?

LEAVE A REPLY

Please enter your comment!
Please enter your name here