public void bindExpenseGrid()
{
ExpenseDetailManager cl = new ExpenseDetailManager();
DataSet ds = cl.ListExpenseDetails();
if (ds.Tables[0].Rows.Count > 0)
{
ExpenseGrid.AutoGenerateColumns = false;
ExpenseGrid.DataSource = null;
//Set Columns Count
ExpenseGrid.ColumnCount = 8;
//Add Columns
ExpenseGrid.Columns[0].Name = "TransactionID";
ExpenseGrid.Columns[0].HeaderText = "Transaction ID";
ExpenseGrid.Columns[0].DataPropertyName = "TransactionID";
ExpenseGrid.Columns[1].HeaderText = "Location ID";
ExpenseGrid.Columns[1].Name = "LocationID";
ExpenseGrid.Columns[1].DataPropertyName = "LocationID";
ExpenseGrid.Columns[2].Name = "ClientID";
ExpenseGrid.Columns[2].HeaderText = "Client ID";
ExpenseGrid.Columns[2].DataPropertyName = "ClientID";
ExpenseGrid.Columns[3].Name = "CategoryID";
ExpenseGrid.Columns[3].HeaderText = "Category ID";
ExpenseGrid.Columns[3].DataPropertyName = "CategoryID";
ExpenseGrid.Columns[4].Name = "PayTo";
ExpenseGrid.Columns[4].HeaderText = "Pay To";
ExpenseGrid.Columns[4].DataPropertyName = "PayTo";
ExpenseGrid.Columns[5].Name = "Date";
ExpenseGrid.Columns[5].HeaderText = "Date";
ExpenseGrid.Columns[5].DataPropertyName = "Date";
ExpenseGrid.Columns[6].Name = "Amount";
ExpenseGrid.Columns[6].HeaderText = "Amount";
ExpenseGrid.Columns[6].DataPropertyName = "Amount";
ExpenseGrid.Columns[7].Name = "Note";
ExpenseGrid.Columns[7].HeaderText = "Note";
ExpenseGrid.Columns[7].DataPropertyName = "Note";
ExpenseGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
ExpenseGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
ExpenseGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//ExpenseGrid.Columns.Insert(8, (DataGridViewColumn)db);
}
}
public void bindExpenseGrid()
{
ExpenseDetailManager cl = new ExpenseDetailManager();
DataSet ds = cl.ListExpenseDetails();
if (ds.Tables[0].Rows.Count > 0)
{
ExpenseGrid.AutoGenerateColumns = false;
ExpenseGrid.DataSource = null;
//Set Columns Count
ExpenseGrid.ColumnCount = 8;
//Add Columns
ExpenseGrid.Columns[0].Name = "TransactionID";
ExpenseGrid.Columns[0].HeaderText = "Transaction ID";
ExpenseGrid.Columns[0].DataPropertyName = "TransactionID";
ExpenseGrid.Columns[1].HeaderText = "Location ID";
ExpenseGrid.Columns[1].Name = "LocationID";
ExpenseGrid.Columns[1].DataPropertyName = "LocationID";
ExpenseGrid.Columns[2].Name = "ClientID";
ExpenseGrid.Columns[2].HeaderText = "Client ID";
ExpenseGrid.Columns[2].DataPropertyName = "ClientID";
ExpenseGrid.Columns[3].Name = "CategoryID";
ExpenseGrid.Columns[3].HeaderText = "Category ID";
ExpenseGrid.Columns[3].DataPropertyName = "CategoryID";
ExpenseGrid.Columns[4].Name = "PayTo";
ExpenseGrid.Columns[4].HeaderText = "Pay To";
ExpenseGrid.Columns[4].DataPropertyName = "PayTo";
ExpenseGrid.Columns[5].Name = "Date";
ExpenseGrid.Columns[5].HeaderText = "Date";
ExpenseGrid.Columns[5].DataPropertyName = "Date";
ExpenseGrid.Columns[6].Name = "Amount";
ExpenseGrid.Columns[6].HeaderText = "Amount";
ExpenseGrid.Columns[6].DataPropertyName = "Amount";
ExpenseGrid.Columns[7].Name = "Note";
ExpenseGrid.Columns[7].HeaderText = "Note";
ExpenseGrid.Columns[7].DataPropertyName = "Note";
ExpenseGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
ExpenseGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
ExpenseGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//ExpenseGrid.Columns.Insert(8, (DataGridViewColumn)db);
}
}
