C#

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

private void dataGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e) {
     /*check Changing cell is "not" in the "Total" Column,
      *would keep calling cell changed event, when the "Total" cell value changes*/
     if ((e.RowIndex >= 0) && e.ColumnIndex != DataGrid.Columns["Total"].Index) {
          //r = row of the changed Cell.
          int r = e.RowIndex;

          //get values from cells in the same row
          int Qty = 0;
          int.TryParse((string)DataGrid["Quantity", r].Value, out Qty);

          double Price = 0D;
          double.TryParse((string)DataGrid["UnitPrice", r].Value, out Price);

          //Calculate Total, Change cell value in "Total"
          DataGrid["Total", r].Value = Price * Qty;
     }
}