static public List <string> GetData()
{
List <string> data = 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 BatchNumber FROM ItemBarcode";
ReprintBarcode rb = new ReprintBarcode();
try
{
conn.Open();
using (SqlDataReader read = cmd.ExecuteReader())
{
for (int i = 0; i < rb.BatchNumberQuantity(); i++)
{
read.Read();
data.Add(read["BatchNumber"].ToString());
}
}
}
catch
{
//MessageBox.Show("Search Failed");
}
finally
{
conn.Close();
}
}
return(data);
}
}
private void btn_Reprint_Click(object sender, RoutedEventArgs e)
{
var ReprintBarcode = new ReprintBarcode();
ReprintBarcode.Show();
}