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();
               }
           }
       }
   }