DataSource error: "Cannot Bind to property or Column"

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

You will also run into this error if you bind to a NULL object.

Tags:

C#

Dataset