static public List <string> GetData() { List <string> stringCollection = new List <string>(); using (SqlConnection conn = new SqlConnection("Data Source=DESKTOP-Q1K44I8\\SA;Initial Catalog=Item2;Integrated Security=True")) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT distinct Item_Code from ItemMaster"; DeleteItemMaster dM = new DeleteItemMaster(); try { conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { for (int i = 0; i < dM.CodeQuantity(); i++) { reader.Read(); stringCollection.Add(reader["Item_Code"].ToString()); } } } catch { //System.Windows.MessageBox.Show("Search Failed"); } finally { conn.Close(); } } return(stringCollection); } }
private void btn_DeleteItem_Click(object sender, RoutedEventArgs e) { var DeleteItemMaster = new DeleteItemMaster(); DeleteItemMaster.Show(); }