C#

// newRow is a newly created Row
// Employees is a List<string> of Employee Names
// i is the index of the for-loop in which Rows are added
newRow[2] = Employees[i].Substring(0, 2) + i.ToString();

<connectionStrings>
    <add name="myConnection" providerName="System.Data.SqlClient" connectionString="server=.\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=True"/>
  </connectionStrings>

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           string connProvider = ConfigurationManager.ConnectionStrings["myConnection"].ToString();
           using (SqlConnection cnn = new SqlConnection(connProvider))
           {
               cnn.Open();
               string userid = "1";
               string query = "Delete Users Where UserID = '" + userid + "'";
               using (SqlCommand cmd = new SqlCommand(query, cnn))
               {
                   cmd.ExecuteNonQuery();
               }
           }
       }
   }

Ade.Ruyani.Z wrote:

this is just a simple code

int RowsAffected = 0;
using(SqlConnection cn = new SqlConnection(ConnectionStringHere))
{
  cn.Open();

  using(SqlCommand cmd = new SqlCommand())
  {
    cmd.Connection = cn;
    cmd.CommandType = CommandType.Text;

    //This shows how to delete with a simple where clause
    cmd.CommandText = "Delete from tablename where id = @id";
    cmd.Parameters.AddWithValue("@id",id);
    RowsAffected = cmd.ExecuteNonQuery();
  }
}