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); } }