Insert, Update,Delete

Question

How to insert How to update How to delete with microsoft visual studio asp.net application with microsoft sql server. Thanks a lot for your help

Tom Mohan · Answer

Hey Soe, Are you using asp.net mvc or asp.net ? Search for CURD(Create Update Read Delete) operation in google. You will get lot of nice articles there :) CURD with asp.net mvc and EF http://www.asp.net/mvc/overview/older-versions/getting-started-with-ef-5-using-mvc-4/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-application

Vincent Maverick Durano · Answer

There are many ways to do that in ASPNET depending if you are in MVC or WebForms Using WebForms: Here's a basic example how to insert data to database using ADO.NET: Creating a Simple Registration Form Here's one example that uses LINQ to SQL: Inserting Data to Database using LINQ to SQL Here's an example using Entity Framework: Inserting Data to Database using EF Finally here's an example using a StoredProcedure with ADO.NET: private void InsertInfo(){ using(SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE")){ connection.Open(); using(SqlCommand sqlCmd = new SqlCommand("YourStoredProcedureName", connection)){ sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@Param1", "What ever value here"); sqlCmd.Parameters.AddWithValue("@Param2", TextBox1.Text); sqlCmd.Parameters.AddWithValue("@Param3", TextBox2.Text); sqlCmd.Parameters.AddWithValue("@Param4", TheUserIDValueThatYouWantToPassHere); sqlCmd.ExecuteNonQuery(); } } } protected void Button1_Click(object sender, EventArgs e){ //you may have to do some input validations here before calling the method insert InsertInfo(); } Edit,Update Delete: http://geekswithblogs.net/dotNETvinz/archive/2010/05/05/editing-updating-and-deleting-data-in-the-form-using-linq.aspx http://geekswithblogs.net/dotNETvinz/archive/2011/04/04/entity-framework---fetching-and-populating-the-data-in-the.aspx Using MVC: http://geekswithblogs.net/dotNETvinz/archive/2011/06/03/asp.net-mvc-3-creating-a-simple-sign-up-form.aspx http://geekswithblogs.net/dotNETvinz/archive/2011/12/30/asp.net-mvc-3---creating-a-simple-log-in-form.aspx http://geekswithblogs.net/dotNETvinz/archive/2012/01/09/asp.net-mvc-3---editing-and-updating-the-form.aspx

Insert, Update,Delete

Answers (2)