inserting records in sqlserver from front end using asp.net with out using stored procedures

add this following code under your button click event:

using(SqlConnection conn = new SqlConnection(your connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand ("INSERT INTO YourTableName (Column1) VALUES ('"+MyTexbox.Text+"'), conn);

cmd.ExecuteNonQuery();
}


if you won't working using stored procedure, why don't you use and ORM tools.

one of the easiest ORM is LINQ To SQL, an ORM built in from Microsoft.