Bounding gridview columns.

I have a gridview at design time , which has 6 columns, 4 are bounded to a table in my database and the other 2 are unbounded, At run time I save the data entered the the unbounded columns and save it with the bounded into another table in my database . When I wahm to show the data in my gridview form the new tabel the unbounded columns are left empty. How do I solve this.

if have to dynamically add a column(unbound) into DataGridView then follow the below steps

public partial class Form1: Form {
public Form1() {
InitializeComponent();
}
private List < Employee > BindGrid() // Bound from Database , for demo i have taken static data
{
List < Employee > EmpList = new List < Employee > () {
new Employee() {
Id = 1,
Name = "Michael"
},
new Employee() {
Id = 2,
Name = "Sohan"
},
new Employee() {
Id = 3,
Name = "Jordan"
},
};
return EmpList;
}
private void Form1_Load(object sender, EventArgs e) {
dataGridView1.DataSource = BindGrid();
LoadUnBoundedData();
}
private void LoadUnBoundedData() {
DataGridViewButtonColumn buttonColumn = new DataGridViewButtonColumn();
buttonColumn.Name = "Details";
buttonColumn.HeaderText = "Details";
buttonColumn.Text = "View Details";
// Use the Text property for the button text for all cells rather
// than using each cell's value as the text for its own button.
buttonColumn.UseColumnTextForButtonValue = true;
// Add the button column to the control.
dataGridView1.Columns.Insert(0, buttonColumn);
}
}

If you have to bind with two tables then write a Join query and bind your dataGridview.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
if have to dynamically add a column(unbound) into DataGridView then follow the below steps
public partial class Form1: Form {
  public Form1() {
    InitializeComponent();
  }

  private List < Employee > BindGrid() // Bound from Database , for demo i have taken static data
  {
    List < Employee > EmpList = new List < Employee > () {
      new Employee() {
        Id = 1,
        Name = "Michael"
      },
      new Employee() {
        Id = 2,
        Name = "Sohan"
      },
      new Employee() {
        Id = 3,
        Name = "Jordan"
      },
    };
    return EmpList;
  }

  private void Form1_Load(object sender, EventArgs e) {
    dataGridView1.DataSource = BindGrid();
    LoadUnBoundedData();
  }

  private void LoadUnBoundedData() {

    DataGridViewButtonColumn buttonColumn = new DataGridViewButtonColumn();
    buttonColumn.Name = "Details";
    buttonColumn.HeaderText = "Details";
    buttonColumn.Text = "View Details";

    // Use the Text property for the button text for all cells rather
    // than using each cell's value as the text for its own button.
    buttonColumn.UseColumnTextForButtonValue = true;

    // Add the button column to the control.
    dataGridView1.Columns.Insert(0, buttonColumn);

  }
}
If you have to bind with two tables then write a Join query and bind your dataGridview.
Weeman Osekre5y ago
Winform
Sachin Singh5y ago
webform or winform?