How to delete data into SQL Server in ADO.net using Connected class Part-06

In this I have shown how to delete data into SQL Server in C# ADO.net using connected class

We have to follow the steps mentioned below:

1. Create database : See part 01 (If Required)
2. Design an user interface : : See part 01 (If Required) , you can do it in your own way
3. Add connection to Database in Visual Studio for more privilege like – connection string creation , visualization of SQL Server database field structure
4. Add required namespace like System.Data and System.Data.SqlClient
5. Create SQL Connection
For delete
6. Build SQL Command for delete
7. Search the data with a=one parameter like Id or name
8. Connection open and then Executenonquery method with cmd
9. Connection close
10. Show message in level
11. Call Showalldata method again to show updated data list

We all know Ado.net uses for connecting database and application, but there is two type of classes that can be used to connect with database

1. Connected class
2. Disconnected class

From connected classes we are mainly use:

Sqlcommand : It is used to buid the SQL command
SqlDataReader : It used to read all the data from database table
ExecuteScaler : It is used to one singular value from database
ExecuteReader: It is used to read at data and return as a DataReader object
ExecuteNonquery: It is used to do insert update delete data in SQL Server table
DataAdapater: It is used to connect class and disconnected class

From disconnected classes we are mainly use:
Datatable:Datatable is the collection of DataColumn, Datarow and various Relation and their constraint
DataColumn: It is the component of Datatable, create column object structure for data
DataRow: It another the component of Datatable, create row object structure for data
Dataset: Dataset is the conllection of DataTable

There are some common classes from System.data namespace classes for acces data sources
SqlConnection : SQL connection is used to build the physical connection to application and SQL Server
Connection.Open(); It is used for opening connection
Connection.Close(); It is used for closing connection
DataSource(); It is used to define dataSource
Databind();


To find the code I have written in this video, join to our facebook group by clicking following link:

https://www.facebook.com/groups/ITSolution365/permalink/2723847894324097/

You can also like to our facebook Page to get all video code clicking on following link:

https://www.facebook.com/permalink.php?story_fbid=572464476555524&id=562632724205366

You can follow us on twitter clicking on following link:

https://twitter.com/ITSolut62078624

We will create thousands of video related with information technology from our practical experience and those are used in our daily work and development. Stay with us.

Do like, share and comments and subscribe to my channel and click on bell button to get notification when new video uploaded. You may suggest me to make new video with new topic.
My Channel Subscription link:

https://www.youtube.com/channel/UCoARYODbMPNO26wMpPE0R6g?sub_confirmation=1

Thanks again