public DataTable GetBarcodeData()
{
DataTable table = new DataTable();
SqlConnection connection = new SqlConnection(_query.GetSourceConnectionString());
connection.Open();
SqlCommand cmd = new SqlCommand("Select SeqID,UsageCode,char(9)+BarcodeNo as BarcodeNo from Garments", connection);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
adapt.Fill(table);
connection.Close();
return(table);
}