how to insert data in database using asp net

Step By Step Select, Insert, Update and Delete using ASP.NET C# and ADO.NET

Jun 11, This article shows how to insert data into a database using datmelove.com C# and a Stored Procedure. I used several textboxes and a button. When the user clicks on the Insert button the data is saved into the database. Open your Visual Studio and create an Empty Website, provide a suitable name (insert_demo). Jan 25, The application uses datmelove.com with C# as the programming language. The database which I am using is SQL Server. The HTML Code Insert Into Database.

This tutorial shows you how to create an entry form and then enter the data that you get from the form into a database table when you use ASP. NET Web Pages. In the tutorial earlier that showed you how to create a database, you entered database data by editing the database directly in WebMatrix, working in the Database workspace.

In most apps, that's not a practical way to put data into the database, though. So in this tutorial, you'll create a web-based interface ksing lets you or anyone enter data and save it to the database. You'll create a page where you can enter new movies. The page will contain an entry form that has fields text boxes where you can enter a movie title, genre, and year.

The page will look like this page:. Replace what's in the file with the following markup. Overwrite everything; you'll add a code block at the top shortly. This example shows typical HTML for creating a form. In the previous tutorial, you created a form that used the get method. That was correct, because although the form submitted values to the server, the inseert did not make any changes. All it did was fetch data in different ways.

However, in this page you will make changesyou're going to add new database records. Therefore, this form should use the post method. Note that each text box has a name element titlegenreyear. As you saw in the previous tutorial, these names are important because you must have those names so you can get the user's input later.

You can use any names. It's helpful to use meaningful names that help you remember what data you're working with. You learned a version of this trick in the previous tutorial to preserve the value entered into the text box if any after the form has been submitted. The first few lines create variables titlegenreand year to hold the values from the text boxes. The line if IsPost makes sure that the variables are hoq only when users click the Add Movie button that is, when the form has been posted.

As you saw in an earlier tutorial, you get the value of a text box by using an expression like Request. The names of the variables title how to insert data in database using asp net, genreand year are arbitrary.

When you write code, consistent names make it easier for you to remember what data you're working with.

This example is similar to the code you used in a previous tutorial to fetch and display data. The following inserg shows the general syntax of the Insert Into statement:.

In other words, you specify the table to insert into, then list the columns to insert into, how to use a whatman filter then list the values to insert. As noted before, SQL is not case sensitive but some people capitalize the keywords to make it easier to read the command.

The columns that inset inserting into are already listed in the command Title, Genre, Year. Instead of actual values, you see 01and 2which daa of course placeholders. When you run the databaxe on how to insert data in database using asp net db.

Execute lineyou pass the values that you got from the text boxes. NET Web Pages the previous tutorial. Still inside the if block, add the following line how to change installation location to memory card the db. Execute line:. After the new movie has been inserted into the database, this line jumps you redirects to the Movies page so you can see the movie you just entered.

In the tree view of files in WebMatrix, right-click the AddMovie. Did you get an error page? If so, read it carefully and make sure that the code looks exactly what was listed earlier. Enter a movie in the form for example, use "Citizen Kane", "Drama", and "".

Or whatever. Then click Add Movie. If all goes well, you're redirected to the Movies page. Make sure that your new movie is listed. Go back to the AddMovie page, or run it again. Enter another movie, but this time, enter only the title for example, enter "Singin' in the Rain". You're redirected to the Movies page again. You can find the new movie, but it's incomplete. When you created the Movies table, you explicitly said that none of the fields could be null.

Here you have an entry form for new ney, and you're leaving fields blank. That's an error. In this case, the database didn't actually raise or throw an error. You didn't supply a genre or year, so the code in the AddMovie page treated those values as so-called empty strings. When the SQL Insert Into command ran, the genre and year fields didn't have useful data in them, but they weren't datta.

Obviously, you ho want to let users enter half-empty movie information into ih database. The solution is to validate the user's input. Initially, the validation will simply make sure that the user has entered a value for all of the fields that is, that none of them contains an empty string. In programming, there's a distinction between different notions of "no value. In contrast, a variable that expects character data strings can be set to an empty string.

In that case, dwtabase value is not null; it's just been explicitly set to a string of characters whose length is zero. These two statements show the difference:. It's a little more complicated than ibsert, but the important point is that what do aquarians look like represents a sort of undetermined state.

Now and then ineert important to understand exactly when a value how to add gmail shortcut to desktop null and when it's just an empty string. In the code for the AddMovie page, you get the values of the text boxes by using Request. Form["title"] and so on.

When the page first runs before you click the buttonthe value of Request. Form["title"] is null. But when you submit the form, Request. Form["title"] gets the value of the title text box. It's not obvious, but an empty text box is not null; it just has an empty string in it. So when the code runs in response to the button click, Request. Form["title"] has an empty string in it. Why is databasf distinction important?

But here you have an entry form for new movies, and you're leaving fields blank. You inesrt reasonably databas the database to complain when you tried to save new movies that didn't have values for genre or year. But that's the point even if you leave those text boxes blank, the values aren't null; they're empty strings. As a result, you're able to save new movies to the database with these columns empty but not null! Therefore, you have to make sure that users don't submit an empty string, which you can do by validating the user's input.

Dtaabase Web Pages includes a helper inssrt Validation helper fatabase you can use to make sure that users enter data that meets dztabase requirements. The Validation helper is one of the helpers that's built in to ASP.

NET Web Pages, so you don't have to install it as a package by using NuGet, the way you installed the Gravatar helper in lnsert earlier tutorial. In the code block in the AddMovie page, right dta at the top before the variable declarations, add the following code:.

You call Validation. You can also add a custom error message for each call, like you see here. We varied the messages just to show that you can put anything you like there. If there's a problem, you want to prevent the new movie information from being inserted into the database. When you're done, the whole if IsPost block looks like this code:. If there's a validation error with any of the fields datavase you registered by using the Validation helper, daga Validation.

IsValid method returns false. And in what age do babies start sitting up case, none of the code in that block will hsing, so no invalid movie entries will be inserted into the database. And of course you're not redirected to the Movies page. The daat step is to display any error messages.

You can display individual messages for each validation error, or insegt can display a summary, or both. For this tutorial, you'll do both so that you can see how it works. You put the Html. ValidationMessage method right where you want the error message to appear.

When the page runs, the Html.

ASP.NET Core Tutorials

Insert the valid data into the form and press the Save button then after saving the details the following message will be shown: Now let us confirm the details in the database table. Jul 26, This View will be used to add new employee data into the database. Open datmelove.com and put following code into it. @model AspNetCoreCURDMVC_datmelove.comeeEntities. Jun 09, how to insert data into database in datmelove.com using stored procedure in c#, datmelove.com or insert / update / delete data into database using stored procedure in datmelove.com or get data from database and show it in gridview using stored procedure in c#, datmelove.com with example.

Insert, Select, Update and Delete Statements Insert, Select, Update and Delete statements these are basics of a programming because these are common coding practice which applies in development of application or a website associated with the database. Insert, Select, Update and Delete altogether also known as DML Data Manipulation Language statements which helps in managing the data with the database within schema objects. We will not get into more detailed explanation about the database but just a breif for undertsanding.

Database is a collection of data stored in a computer disc space or server space. In simple words it is a space where your data is been stored. In a single database we can create any number of data tables. It's like a school with many classrooms and each classroom will have different school students.

In a single data table we create any number of columns For eg. Like to store student's records you can have students data table, For school accounts you can have accounts data table, For school results you can have results data table. Now in further we will try to understand about data manipulation statements i. Insert, Select, Update and Delete. For ex : In simple words if you want to pick up single student record, multiple student records or all students records from the table database you just need to use "Select" statement.

Insert statement lets you to insert new record or new data into the database table. For ex : In simple words if you want to add new student record then you need to use "Insert" Statement. Note: For numeric data we dont use " " inverted comma and for string data we use " " inverted comma.

Update Statement lets you to update existing one or more records in the database table depending on condition. Delete statement helps to delete one or more records from the database table depending on condition. When we have a website or an application associated with database Sql, Oracle, Mysql and so on then to do manipulation i. Insert, Select, Update and Delete Statements.

Now that you have understoond about data manipulation language, now let's do step by step insert, update, delete and select using asp.

To demonstrate step by step insert update delete and select, we will be using a simple web application, you can choose anything web or windows depending on your requirement the coding part will remain the same. After creating a new website, create a new database from server explorer of visual studio or SQL server. We have shown you an example through visual studio After creating a new database, let's add new data tables with colums like as shown in below image file.

Note : To create tables just click on your database name go to tables folder, when you choose to create a table it will ask you add columns. You can add your custom name column names along with data type.

Data Type : For string data choose - varchar 50 or above, for integer data choose - int. Once you have copied the connection string go to your asp. Find the web.

Add - Edit Delete buttons from the command field and check on the auto generate fields. Edit link is for to choose which record to edit and delete link is for to delete the selected record.

Create a form to update and insert records into database from website as shown above i. Name, Address and Salary then add one hidden field and two submit buttons, name it.

We will be display the records on grid view. After opening up the sql connection, Let's write the Select statement in the sql command and the execute the sql query using sql command execute reader and append it to grid view data source as shown below.

To add new record to the database we will use the following form that we have created in our default. We will write insert statement in the button click event. So double click on a button, a button click event opens up. First we need to open up the sql connection as same as previously we did it for select statement then in a sql command write the following insert statement as shown below.

Then by using the command object call the ExecuteNonQuery method to execute query. We normally use this method while updating, deleting and inserting.

Text, txtAddress. Text and txtSal. Text are the form input name to take form input data. What we did here, we have displayed the records in the grid view screen and there itself we have provided an option for edit and delete as a link as shown below. So for now we will assume that user clicks on the edit link and following details displayed on the screen as shown below. So we have just clicked on 10 th record and the same data appears on the screen and we have recorded the employee ID i.

If you see our form there we have a hiddenfield of employee ID. HiddenFields: It helps us to store the important values which we can use it in the later part of coding. This hidden field value or employee ID, I'm going to use it in an update statement for an updating purpose. So next step when a user clicks on update button on the form, we have to fire an update statement, so fire an update statement. Procedure is same, first we need to open up sql connection, then on sql command we to just need to write an update statement with the "Where" condition.

What we did here, we have displayed all the records in the grid view screen and there itself for each record we have provided an option for edit and delete as a link as shown below. So when a user clicks on the delete link of selected row, on delete link event args we have fired delete statement with following delete code as shown below. Delete Procedure is same as did it for update and insert, first we need to open up sql connection, then on sql command we to just need to write a delete statement with the "Where" condition.

So my technical friend I hope that you have understood about insert, update, select and delete using asp. If you have any doubts regarding this topic you can add your valuable comments. If you like this article kindly share it with your friends. Happy Coding. Gurunatha Dogi is a software engineer by profession and founder of Onlinebuff.

Onlinebuff DOT. NET Sep 17th, Gurunatha Dogi Gurunatha Dogi is a software engineer by profession and founder of Onlinebuff. By Nyan Win Luck on I've some error! Only content control are allowed directly in a contrnt page that contains content controls! This error I'm writing sqldatasource to appear dropdownlist. By Nawab on i am looking for a event handling. By Rahul on owesum teaching keep going u r bestway explaination.

By Safuvan on tanx alot By Waqas khan on Thank you brother its very helpful By Sagar on thanks By Rudra on This article is really useful to me.. By Dataset does not exist in current context on please help me out and send me the solution i have am performing this project but it shows error on dataset. By Vidyashree on i m new to asp. By Prajakta on It was of a great help..

By Sagar on great job dude helped a lot. By Sanket on Thanks it is very usefull for me. By Aditi Patel on Such a helpful info using very easy and understandable language. Really very nice. By Rahul on Thanxxxxx Plz reply me. By Swathy mohanan on good.

By Nikhhil on hello nice. By Andy Weil on The article you submitted are really very useful for and i want to step by step article like How to create Trigger and many more.

So, i request to you please provide that type information and is it possible to find your article in a pdf form. By Jayaprasad on thank u.

By Kaushik on than x lots. By Narasingh on sir,,,u really superbb,,,i m beginner By Alok on nic By Keshawa on Very much Helpful. Can you please describe the code of clicking "Edit". By Viral Khunt on Thanks lot of U help me??? By Sachin Kumar on Please hep me to store bulk excel data in database in asp. By Sethsaren on thank. By Nuux ali ibraahim on so thankz for softerware engineer. By Bs on thnks sir. By Roshni pashine on nice coding.

By Srinivas on nice coding.