Click here to Skip to main content
15,885,874 members
Please Sign up or sign in to vote.
3.33/5 (2 votes)
See more:
I am looking for a mvc tutorial which does not use the entity framework.
I want to use the older ado.net, string sql below:



C#
SqlConnection sqlConn = new SqlConnection("Data Source=dev01;Initial Catalog=Test_Lin;Integrated Security=True");
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlConn;
sqlCmd.CommandText = "INSERT INTO Staff ( FirstName, Surname, Resaddress, CellNumber) VALUES (@FirstName, @Surname, @Resaddress, @CellNumber)";
sqlCmd.Parameters.AddWithValue("@FirstName", txtName.Text);
sqlCmd.Parameters.AddWithValue("@Surname", txtSurname.Text);
sqlCmd.Parameters.AddWithValue("@Resaddress", txtAddress.Text);
sqlCmd.Parameters.AddWithValue("@CellNumber", txtCell.Text);
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
sqlConn.Dispose();
Posted
Updated 3-Jan-14 1:49am
v4

1 solution

Here is the Article where you're looking for.

ASP.NET MVC is not all about Linq to SQL
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900