how to do select, insert, update, delete from database using ADO.NET

This below link give you a correct path to start with :

http://stackoverflow.com/questions/6694098/using-asp-net-mvc-with-classic-ado-net

[Youtube Video]

Hope you will be helpful with this link.

If you don't want to use Entity Framework there are many other (ADO-base) options. Most of them introduce just as much overhead as EF, if that's your concern, but if you want just plain SQL access you can use the System.Data.SqlClient namespace. Use the SqlConnection and SqlCommand to manually make database calls and changes.

Of course this will result in tightly coupled code and you'll lose the default model binders. You'll need to either rebuild those or hand-jam in your controllers. Effectively you'll take the M and just be left with VC.

string conn = "";
conn = ConfigurationManager.ConnectionStrings["Conn"].ToString();
SqlConnection objsqlconn = new SqlConnection(conn);
objsqlconn.Open();
SqlCommand objcmd = new SqlCommand("Delete from Employee Where Employee_ID='" + _empID + "'", objsqlconn);
objcmd.ExecuteNonQuery();


string conn = "";
conn = ConfigurationManager.ConnectionStrings["Conn"].ToString();
SqlConnection objsqlconn = new SqlConnection(conn);
objsqlconn.Open();
SqlCommand objcmd = new SqlCommand("Insert into Employee(Employee_Name,Employee_Address,Employee_Salary) Values('" + txtName.Text + "','" + txtAddress.Text + "','" + txtSal.Text + "')", objsqlconn);
objcmd.ExecuteNonQuery();