C# Adding more methods to Database Helper Class | SQL Connection | Optimize Code | C# WinForm

DB Helper Class part 2: C# Adding more methods to Database Helper Class | SQL Connection | Optimize Code | C# WinForm in Urdu / Hindi by Aakash Asswani

Part 1: C# SQL Connection using Database Helper Class | Shorten Database Code | Optimize Code | C# WinForm:

Complete source code of class:

Reference video: SQL injection in C#

In this C# SQL tutorial we have explained How to sanitize DB Helper class methods for SQL injection attack and add new methods. We have continued our previous lecture "How to Connect SQL Server Database to C# app using Database Helper Class using an step by step and easy approach". Visual studio to SQL database connectivity code is shorten.We have extended our previously created SQL helper class with following functionalities:
-Sanitize Execute() & Select() methods for SQL Injection-Return number of rows affected on calling Execute() method-Adding method SelectSingle(), SelectList() and SelectDataTable()

This video is divided

Chapters:0:00 Introduction1:25 Sanitize Execute() & Select() methods for SQL Injection
7:51 Add method SelectSingle()
8:58 Add method SelectList()
10:10 Add method SelectDataTable()

Just create SQL connection in c# and save data in Microsoft SQL server using visual studio & management studio and optimize code using db helper class.We have created a complete playlist on C# & SQL Server database. You can find it on Aakash Asswani youtube channel:

This step by step tutorial covers following points:
1. How to create a simple database helper class in C#2. Database Helper for C# Asp.NET and WPF Database Operations3. Database Helper for C# WinForm Database Operations4. Creating a Data class for SQL helper functions5. .Net Sql Helper Class6. SQL Connection using a Class in C#7. DBHelper - SQLServer - C# (Winform)8. How to connect SQL Server with C# using class9. How to Connect SQL Server Database to C# app (Step by Step & Easy Way) | Visual Studio C# with SQL10. db helper class11. sql server helper class c#13. c# database helper class14. database helper class in c#15. optimize database connection code16. shorten database code c#

#DBHelperClass #CSharp #SqlServer #VisualStudio #AakashAsswani

[mashhood]

Bhlaa ho bhai apka♥️ these videos are helping me a lot.

[bkm]

Hello Aakash Ji,

I have one quick question, I am using tableapdater, dataset, bindingsource with my gridview and on click event I am showing the record in a form to edit it and id is a char field not autoincreament. The Edit, Add, Update works fine with buttons. Now I have one requirement that since my table has more than 100 columns/fields and I want to copy/clone the same record
with new id, since I have more than 100 columns in a form I don't want to re-enter the same again. So I need both the records old with old id and new with new id. I tried to update it via edit button click event but it overwrites it with new id.

Can you help me with this one.

Thanks.

[raviinaniya]

Your Video is very helpful .
I have problems, i can't use Validation Controls in visual studio 2013 can u tell me what to do . Or should i shift to another version, if yes then which