SqlConnection con = new SqlConnection();
con.ConnectionString=ConfigurationManager.ConnectionString["Name Of Connection String"].toString();
SqlCommand cmd=new SqlCommand("Name of the stored procedure",con);
cmd.Parameters.Add("@Name", txtName.Text.toString());
cmd.Parameters.Add("@Description", txtDesc.Text.toString());
cmd.Parameters.Add("@Image",txtImage.Text.toString());
cmd.Parameters.Add("@Active",txtActive.Text.toString());
cmd.Parameters.Add("@CreatedBy",txtCreatedBy.Text.toString());
cmd.Parameters.Add("@CreatedDate", convert.toDateTime(txtCreDate.Text));
cmd.CommandType=CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
cmd.close();
con.close();