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