public void bindFlatGrid()
{
FlatManager f = new FlatManager();
DataSet ds = f.ListFlats(BuildingID);
if (ds.Tables[0].Rows.Count > 0)
{
FlatGrid.AutoGenerateColumns = false;
FlatGrid.DataSource = null;
//Set Columns Count
FlatGrid.ColumnCount = 3;
//Add Columns
FlatGrid.Columns[0].Name = "Id";
FlatGrid.Columns[0].HeaderText = "Id";
FlatGrid.Columns[0].DataPropertyName = "FlatID";
FlatGrid.Columns[1].HeaderText = "FlatNo";
FlatGrid.Columns[1].Name = "FlatNo";
FlatGrid.Columns[1].DataPropertyName = "FlatNo";
FlatGrid.Columns[2].Name = "Price";
FlatGrid.Columns[2].HeaderText = "Price";
FlatGrid.Columns[2].DataPropertyName = "Price";
FlatGrid.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";
FlatGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
FlatGrid.Columns.Add(Deletelink);
DataGridViewLinkColumn AddBuilding = new DataGridViewLinkColumn();
AddBuilding.UseColumnTextForLinkValue = true;
AddBuilding.HeaderText = "Sell";
AddBuilding.DataPropertyName = "lnkForSellColumn";
AddBuilding.LinkBehavior = LinkBehavior.SystemDefault;
AddBuilding.Text = "Sell";
FlatGrid.Columns.Add(AddBuilding);
}
}
