I need to write code in souce for insert in asp.net using C#

Question

Hi .i need to write code in souce for insert in asp.net using c#

Senthilkumar · Answer

string connString = ConfigurationManager.ConnectionStrings[yourconnstringInWebConfig].ConnectionString; SqlConnection conn = null; try { conn = new SqlConnection(connString); conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Conn = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = INSERT INTO dummyTable(name) Values (@var); cmd.Parameters.AddWithValue(@var name); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected == 1) { //Success notification } else { //Error notification } } } catch (Exception ex) { //log error //display friendly error to user } finally { if (conn != null) { //cleanup connection i.e close } }