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

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

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.