public void RetrieveTables() // public for testing
{
using (SqlConnection serverConnection = new SqlConnection(conString))
{
string query = "select * from Project";
using (SqlCommand cmd = new SqlCommand(query, serverConnection))
{
ProjectTable.Clear();
// create data adapter to read table into DataTable object
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
da.Fill(ProjectTable);
}
query = "select * from [User]";
using (SqlCommand cmd = new SqlCommand(query, serverConnection))
{
UserTable.Clear();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
da.Fill(UserTable);
}
query = "select * from Task";
using (SqlCommand cmd = new SqlCommand(query, serverConnection))
{
TaskTable.Clear();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
da.Fill(TaskTable);
}
}
}
