public void bindLocation() { LocationManager ls = new LocationManager(); DataSet ds = ls.ListLocations(); if (ds.Tables[0].Rows.Count > 0) { LocationGrid.AutoGenerateColumns = false; LocationGrid.DataSource = null; //Set Columns Count LocationGrid.ColumnCount = 3; //Add Columns LocationGrid.Columns[0].Name = "Id"; LocationGrid.Columns[0].HeaderText = "Id"; LocationGrid.Columns[0].DataPropertyName = "id"; LocationGrid.Columns[1].HeaderText = "Location Name"; LocationGrid.Columns[1].Name = "LocationName"; LocationGrid.Columns[1].DataPropertyName = "LocationName"; LocationGrid.Columns[2].Name = "Address"; LocationGrid.Columns[2].HeaderText = "Location Address"; LocationGrid.Columns[2].DataPropertyName = "LocationAddress"; LocationGrid.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"; LocationGrid.Columns.Add(Editlink); DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn(); Deletelink.UseColumnTextForLinkValue = true; Deletelink.HeaderText = "delete"; Deletelink.DataPropertyName = "lnkForDeleteColumn"; Deletelink.LinkBehavior = LinkBehavior.SystemDefault; Deletelink.Text = "Delete"; LocationGrid.Columns.Add(Deletelink); //DataGridViewButtonColumn db = new DataGridViewButtonColumn(); //db.Text = "Delete"; //LocationGrid.Columns.Insert(3, (DataGridViewColumn)db); } }
public void bindLocationDropDown() { LocationManager ls = new LocationManager(); DataSet ds = ls.ListLocations(); if (ds.Tables[0].Rows.Count > 0) { drpLocationList.DisplayMember = "LocationName"; drpLocationList.ValueMember = "id"; drpLocationList.DataSource = ds.Tables[0]; } else { //drpLocation.Items.Add() } }