private void GenerateID()
{
int id;
DataTable dt = con.GetTable("SELECT EmployeeID FROM MSEMPLOYEE ORDER BY EmployeeID DESC");
if (dt.Rows.Count > 1)
{
Int32.TryParse(((String)dt.Rows[0][0]).Substring(4), out id);
string res = "EM" + (id + 1).ToString("000");
Console.WriteLine("Generated " + res);
txtID.Text = res;
}
}
/// <summary>
/// Refreshes DataGridView with SQL query.
/// </summary>
private void RefreshTable()
{
string query = "SELECT * FROM MsBookType";
dataGridView1.DataSource = con.GetTable(query);
}
