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