private void delete(object sender, RoutedEventArgs e)
{
long iiid = (DateTable2.SelectedItem as TickSizeTable).id;
demoEntities10 de = new demoEntities10();
TickSizeTable del = de.TickSizeTables.Find(iiid);
de.Entry(del).State = EntityState.Deleted;
de.SaveChanges();
// var value = DateTable2.SelectedItem as DataRowView;
// if (null == value) return;
// id = value.Row[0].ToString();
// System.Data.SqlClient.SqlConnection sqlConnection1 =
//new System.Data.SqlClient.SqlConnection(connectionString);
// System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = "DELETE demo.dbo.TickSizeTable WHERE id='" + id + "'";
// cmd.Connection = sqlConnection1;
// sqlConnection1.Open();
// cmd.ExecuteNonQuery();
// sqlConnection1.Close();
FillDataGrid();
}
