Complete CRUD Operations in ASP.Net

Tejas Bhatt

11y477.7k18100Article

CRUD OperationsCRUD Operations in ASP.NETASP.NET CRUD

18 Comments

Join the conversation! Your thoughts help the community grow.

Hardik Erda3y ago
You write "Complete CRUD Operations" in title but you only demonstrate insert operation.
Chetan Garude6y ago
The screenshots are decent, but what a horrible butchering of coding best practices! Please DO NOT store connection information in the code (anyone heard of web.config)? Also, best practice is to used stored procedures to perform CRUD.
Ahsan Khan6y ago
Explanation is good for the Beginner
shakib patel6y ago
Well Explained Thanks
Hitanshi Mehta7y ago
Amazing article!!!!
Nitin Shakya8y ago
Function FilterListEvoucher() { alert('ok'); $.ajax({ type: "POST", url: "getData.asmx/bindactivelist", data: "{}", contentType: "application/json; charset=utf-8", dataType: "json", success: BindListVoucher1, error: function (xhr, status, error) { } }); } function BindListVoucher1(msg) { alert(msg.d); debugger; var table = ''; var jsonData = msg.d; for (var iCount = 0; iCount < jsonData.length; iCount++) { var row = '<tr>'; row += '<td>' + (iCount + 1) + '</td>'; row += '<td>' + jsonData[iCount].Sponame + '</td>'; row += '<td class="hidden-phone">' + jsonData[iCount].Username + '</td>'; row += '<td class="hidden-phone">' + jsonData[iCount].Name + '</td>'; row += '<td class="hidden-phone">' + jsonData[iCount].active + '</td>'; row += '<td class="hidden-phone">' + jsonData[iCount].package + '</td>'; row += '<td class="hidden-phone"><a href="#">Active</a></td>'; row += '</tr>'; table += row; } $('#repMsg').html(table); $('#example').dataTable().val(table); }
YEISON FERNÁNDEZ8y ago
Please, i need the crud completed, where can find it...
Abucheri Derrick8y ago
Nice tutorial to get me started!!!!
Air Planet8y ago
I am getting error how can i show you that error screenshot?
Air Planet8y ago
I am getting error
Akash Srivastav8y ago
Thanks For The Help..
Sagar Pandurang Kap8y ago
Well Explained.....
Rizky Maulana8y ago
Thx Tejas Bhatt, i hope you keep on creating articles about asp.net for beginners like me ^_^
Vincent Ruiz9y ago
Where is the continuation of this tutorial sir Tejas Bhatt??
Ghanshyam Jaiswal10y ago
Very nice
ROHAN PANDEY11y ago
Ok
Tejas Bhatt11y ago
well the title was CRUD_Operations_In_AspDotNet_CSharp_Part_1 , But u kno this editor , i dont kno where did dey see complete CRUD operation , they hv changed it to it , not my fault , and select , update things are there in part - 2 friend , these editors made mistk , they shoudn't have changed the name of article , it must hv been kept [part-1] not [complete]
ROHAN PANDEY11y ago
Update delete select not fully crud operation

Step 1

Open SQL Server (enter the Server Name, Id and Password then click on Connect).

Step 2

Create a new database (right-click on Database then select New Database).

Step 3

Enter "CRUD" for the database name then click OK.

Step 4

Create a new table (explore the CRUD database then right-click on Tables then select New Table).

Step 5

Design the table (name the columns and set the data types as shown in the following figure).

Step 6

Set the Primary Key (right-click on Column(u_id) then set the Primary Key).

Step 7

Make the u-id column Auto-Increment (select the u_id column then go to the Column Properties then select Identity Specification then (Is Identity) = Yes ). Press Ctrl + S to save the table. A window will open for entering the name of the database. Provide "tbl_user" for it and click OK.

Step 8

Create a New Web Application (open Visual Studio then select File -> New -> Web Site).

Step 9

Select Visual C# from left then select .Net Framework 3.5.

Step 10

Select ASP.NET Empty Web Site then click on Browse.

Step 11

Select the folder in which you would like to store the application then click open then provide a website name after the folder name, for example in the following case (../project/CRUD) then click OK.

Step 12

An Empty Web Application has been created.

Step 13

Create a new web page (right-click on the web App then select Add -> Add New Item).

Step 14

Select "Web Form" then provide the name "Add.aspx" then click Add.

Step 15

In the same way add another three web forms (Delete.aspx, Retrieve.aspx and Update.aspx).

Step 16

Add a HTML table dynamically (open Add.aspx then select Design View from the bottom left then select Table from the menubar then select Insert Table).

Step 17

Set the table properties as in the following and remember to uncheck specify width (it's important for a good UI).

Step 18

Select the table then right-click on it then go to properties (in the right side corner you will get properties as shown in the following figure).

Step 19

This step is important for a good UI.

Select the first cell of the first row then set the width = 100 (in the properties window)
Select the second cell of the first row then set the width = 20 (in the properties window)
Select the fourth cell of the first row then set the width = 20 (in the properties window)
Add a TextBox (from the Toolbox select TextBox then drag and drop it to the third cell of the first row)
Select that TextBox then Ctrl + C (copy) then select the third cell of the second row then Ctrl + V (Paste) (do this for the third and fourth row as well)
Type the text as shown in the following figure in first cell of every row (First Name, Last Name, Contact and Email)
Select all the second cells of each row then go to properties then select align then select center, then put ":" in each of these cells
Select the third cell from the fifth row and set align then right from the properties window

Step 20

Add a button (select the button from the toolbox then drag and drop it to the third cell of the fifth row).

Step 21

Assign an Id value to each ASP component. (Select the first TextBox then go to properties then set the (ID) = txtFname.)

Do the same thing for the other TextBoxes and provide the names (txtLname, txtContact and txtEmail).

Step 22

As in the Step 21, set the id and text for the button also (go to the properties then select (ID)= btnCreate, Text = Create).

Step 23

Open the C# code for the page (right-click on the page then select go to View Code).

Step 24

Add two assemblies on top as shown in the following figure (using System.Data and using System.Data.SqlClient).

Step 25

Double-click on the button Create and add the following code as shown in the following figure.

string con = "Data Source=.;Initial Catalog =CRUD;User Id=sa;Password=sql@123";
SqlConnection db = new SqlConnection(con);
db.Open();
string insert = "insert into tbl_user (u_fname,u_lname,u_contact,u_email) values ('"+txtFname.Text+"','"+txtLname.Text+"','"+txtContact.Text+"','"+txtEmail.Text+"')";
SqlCommand cmd = new SqlCommand(insert,db);
int m = cmd.ExecuteNonQuery();
if(m != 0)
{
Response.Write("
<script>alert('Data Inserted !!')</script>
");
}
else
{
Response.Write("
<script>alert('Data Inserted !!')</script>
");
}
db.Close();

Step 26

Run the Project as in the following:

Save the project (press Ctrl + S (Save) for both Add.aspx and Add.aspx.cs).
Run the project (right-click on the Add.aspx then set the As Start Page then select Fn + F5 (Run)). You will get the following output.
Enter the details of the user. Click the button Create.

Step 27

A message will shown saying "Data Inserted !!".

Step 28

Confirmation (open SQL Server then select explore database "CRUD" then select explore tables then right-click on tbl_user then select Open Table).

Step 29

You will see that the data has been successfully inserted into the database.