CRUD Operation Related to SQL

Ifraz Imanudeen

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews8y ago
Accepted 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 Ranwa8y ago
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 Thakkar8y ago
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 Kumar8y ago
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