DataSource error: "Cannot Bind to property or Column"

Question

I'm working on a database in C# when I hit the display button I get an error: Error: Cannot bind to the property or column LastName on the DataSource. Parameter name: dataMember Code: ``` private void Display_Click(object sender, EventArgs e) { Program.da2.SelectCommand = new SqlCommand("Select * From Customer", Program.cs); Program.ds2.Clear(); Program.da2.Fill(Program.ds2); customerDG.DataSource = Program.ds2.Tables[0]; Program.tblNamesBS2.DataSource = Program.ds.Tables[0]; customerfirstname.DataBindings.Add(new Binding("Text", Program.tblNamesBS2, "FirstName")); customerlastname.DataBindings.Add(new Binding("Text", Program.tblNamesBS2, "LastName")); //Line Error occurs on. } ``` Not sure what it means can anyone help, if I comment out the last two lines it will display properly.

Accepted Answer

it means your datatable is not finding column name LastName which is in your database..

in your case you filling your dataset with ds2..

```
 Program.da2.Fill(Program.ds2); 
```

and then you are binding your datasource to 'program' like this..

```
Program.tblNamesBS2.DataSource = Program.ds.Tables[0];  
```

it should like this..

```
Program.tblNamesBS2.DataSource = Program.ds2.Tables[0];  
```

because below line you are looking value from Program.tblNamesBS2 which is binded to 'ds' and that's why column are not ther in 'ds'.

```
 customerfirstname.DataBindings.Add(new Binding("Text", Program.tblNamesBS2, "FirstName"));    
  customerlastname.DataBindings.Add(new Binding("Text", Program.tblNamesBS2, "LastName"));
```

DataSource error: "Cannot Bind to property or Column"

Solution

Problem