public void bindBuildingGrid()
{
BuildingManager b = new BuildingManager();
DataSet ds = b.listBuildingbyLocation(LocationID);
if (ds.Tables[0].Rows.Count > 0)
{
BuildingGrid.AutoGenerateColumns = false;
BuildingGrid.DataSource = null;
//Set Columns Count
BuildingGrid.ColumnCount = 3;
//Add Columns
BuildingGrid.Columns[0].Name = "BuildingID";
BuildingGrid.Columns[0].HeaderText = "BuildingID";
BuildingGrid.Columns[0].DataPropertyName = "BuildingID";
BuildingGrid.Columns[1].HeaderText = "Building Name";
BuildingGrid.Columns[1].Name = "BuildingName";
BuildingGrid.Columns[1].DataPropertyName = "BuildingName";
BuildingGrid.Columns[2].Name = "BuildingDescription";
BuildingGrid.Columns[2].HeaderText = "Building Description";
BuildingGrid.Columns[2].DataPropertyName = "BuildingDescription";
BuildingGrid.DataSource = ds.Tables[0];
//Buttons
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
BuildingGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
BuildingGrid.Columns.Add(Deletelink);
DataGridViewLinkColumn AddBuilding = new DataGridViewLinkColumn();
AddBuilding.UseColumnTextForLinkValue = true;
AddBuilding.HeaderText = "Add Flats";
AddBuilding.DataPropertyName = "lnkForFlatsColumn";
AddBuilding.LinkBehavior = LinkBehavior.SystemDefault;
AddBuilding.Text = "Add Flats";
BuildingGrid.Columns.Add(AddBuilding);
}
}
