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