/// <summary>
/// Method for populating the DataDridView
/// </summary>
public void populateDataGridView(int projectId)
{
this.projectId = projectId;
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
ModuleDataAccess module = new ModuleDataAccess();
dgvModule.AutoGenerateColumns = false; // To only show the columns needed
dgvModule.DataSource = module.GetAllModules(projectId);
ProjectDataAccess project = new ProjectDataAccess();
projectName = project.FindProject(projectId).ProjectName;
for (int i = 0; i < dgvModule.RowCount; i++)
{
dgvModule.Rows[i].Cells[2].Value = projectName;
}
txtSearchModules.Text = "";
Modules_Tab_Child.getInstance().clearModuleText();
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DbConnector.CloseSQLConnection(); // Close connection to the database
}
