CRUD Operation Related to SQL

Question

Hi to everyone, I New to C# programming, and finding very difficult to understand connectivity to database and specially CRUD Operation. there are so many SQL components Like SqlCommand SqlDataAdapter SqlDataReader Dataset DataTable Just to get the Select Statment to work. Does anyone advice me where to use what or where i can learn about this clearly Thanks

Jaish Mathews · Answer

You got enough links to Ref. as members are generously shared in this loop. I am just putting some texts against the terminologies you mentioned by adding "SqlConnection" too. They arranged in a sequence from establishing a connection to get the data SqlConnection - Mandatory where you give your target database details e.g. through connectionstring SqlCommand - Mandatory, you give command to execute here. e.g. SELECT statement SqlDataAdapter - Provide disconnected access and it fill Dataset/DataTable e.g. After SqlConnection close, you can fill Dataset/DataTable with data DataTable - You get data in your C# code as this type. Dataset - Collection of DataTables and can define relation also. e.g. If 2 grids to display with different data, each grid data can make available in a single DataSet with 2 DataTables in it. SqlDataReader - Another type to store data in your C# code. DataTable and DataSet are disconnected from database once they have data and SqlDataAdapter is helping for this disconnected behavior. But SqlDataReader is connected to target database once it has data. It's very fast, forward only and readonly data. e.g. If you just to produce a members report data which is merely for display purpose, you use SqlDataReader

Sanwar Ranwa · Answer

Hello Ifraz Imanudeen First i suggest you learn Ado.netb concepts https://www.youtube.com/playlist?list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7 https://www.c-sharpcorner.com/UploadFile/18fc30/understanding-the-basics-of-ado-net/ For Database connectivity https://www.codeproject.com/Tips/1038536/Day-Database-Connectivity-ASP-NET-Csharp-with-SQL https://www.c-sharpcorner.com/article/how-to-connect-sql-database-in-asp-net-using-c-sharp-and-insert-and-view-the-data-usi/ For more Detials https://www.c-sharpcorner.com/UploadFile/4aae29/complete-crud-operations-in-Asp-Net/ https://www.c-sharpcorner.com/UploadFile/009464/make-edit-update-and-delete-operation-in-gridview-in-Asp-Net/ https://www.aspsnippets.com/Articles/Simple-CRUD-operations-in-ASPNet-Web-Forms-using-C-and-VBNet.aspx https://www.codeproject.com/Articles/438259/Insert-Update-Search-and-Delete-CRUD-operation-usi

Jenith Thakkar · Answer

For Understand Sql Components you have to learn Ado.Net There are two approches 1)Code First 2)Model First Please refer this link for Ado.Net http://www.dotnet-stuff.com/tutorials/adonet/crud-operations-using-ado-net-and-C-sharp-in-asp-net

Suraj Kumar · Answer

Hello, Please read the below article and you can also follow the steps to create the CRUD application as suggested in the below articles https://www.c-sharpcorner.com/UploadFile/009464/make-edit-update-and-delete-operation-in-gridview-in-Asp-Net/ https://www.c-sharpcorner.com/article/crud-using-stored-procedure-in-asp-net-gridview-real-time/ https://www.c-sharpcorner.com/UploadFile/4aae29/complete-crud-operations-in-Asp-Net/ You can download the code also for your reference. If stuck at any place you can post your query to that article's comment section as well as on the forum here. Thanks Suraj

CRUD Operation Related to SQL

Answers (4)