public void bindIncomeGrid()
{
IncomeDetailManager cl = new IncomeDetailManager();
DataSet ds = cl.ListIncomeDetails();
if (ds.Tables[0].Rows.Count > 0)
{
IncomeDetailGrid.AutoGenerateColumns = false;
IncomeDetailGrid.DataSource = null;
//Set Columns Count
IncomeDetailGrid.ColumnCount = 6;
//Add Columns
IncomeDetailGrid.Columns[0].Name = "TransactionID";
IncomeDetailGrid.Columns[0].HeaderText = "Transaction ID";
IncomeDetailGrid.Columns[0].DataPropertyName = "TransactionID";
IncomeDetailGrid.Columns[1].HeaderText = "Name";
IncomeDetailGrid.Columns[1].Name = "Name";
IncomeDetailGrid.Columns[1].DataPropertyName = "Name";
IncomeDetailGrid.Columns[2].Name = "LocationID";
IncomeDetailGrid.Columns[2].HeaderText = "Location";
IncomeDetailGrid.Columns[2].DataPropertyName = "LocationID";
IncomeDetailGrid.Columns[3].Name = "Date";
IncomeDetailGrid.Columns[3].HeaderText = "Date";
IncomeDetailGrid.Columns[3].DataPropertyName = "Date";
IncomeDetailGrid.Columns[4].Name = "Amount";
IncomeDetailGrid.Columns[4].HeaderText = "Amount";
IncomeDetailGrid.Columns[4].DataPropertyName = "Amount";
IncomeDetailGrid.Columns[5].Name = "Note";
IncomeDetailGrid.Columns[5].HeaderText = "Note";
IncomeDetailGrid.Columns[5].DataPropertyName = "Note";
IncomeDetailGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
IncomeDetailGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
IncomeDetailGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//IncomeDetailGrid.Columns.Insert(6, (DataGridViewColumn)db);
}
}
public void bindIncomeGrid()
{
IncomeDetailManager cl = new IncomeDetailManager();
DataSet ds = cl.ListIncomeDetails();
if (ds.Tables[0].Rows.Count > 0)
{
IncomeDetailGrid.AutoGenerateColumns = false;
IncomeDetailGrid.DataSource = null;
//Set Columns Count
IncomeDetailGrid.ColumnCount = 6;
//Add Columns
IncomeDetailGrid.Columns[0].Name = "TransactionID";
IncomeDetailGrid.Columns[0].HeaderText = "Transaction ID";
IncomeDetailGrid.Columns[0].DataPropertyName = "TransactionID";
IncomeDetailGrid.Columns[1].HeaderText = "Name";
IncomeDetailGrid.Columns[1].Name = "Name";
IncomeDetailGrid.Columns[1].DataPropertyName = "Name";
IncomeDetailGrid.Columns[2].Name = "LocationID";
IncomeDetailGrid.Columns[2].HeaderText = "Location";
IncomeDetailGrid.Columns[2].DataPropertyName = "LocationID";
IncomeDetailGrid.Columns[3].Name = "Date";
IncomeDetailGrid.Columns[3].HeaderText = "Date";
IncomeDetailGrid.Columns[3].DataPropertyName = "Date";
IncomeDetailGrid.Columns[4].Name = "Amount";
IncomeDetailGrid.Columns[4].HeaderText = "Amount";
IncomeDetailGrid.Columns[4].DataPropertyName = "Amount";
IncomeDetailGrid.Columns[5].Name = "Note";
IncomeDetailGrid.Columns[5].HeaderText = "Note";
IncomeDetailGrid.Columns[5].DataPropertyName = "Note";
IncomeDetailGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
IncomeDetailGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
IncomeDetailGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//IncomeDetailGrid.Columns.Insert(6, (DataGridViewColumn)db);
}
}
