How can solve this problem "Cannot bind to the property or column firstname on the DataSource. Parameter name: dataMember"

Question

0.00/5 (No votes)

See more:

my code give me this error "Cannot bind to the property or column firstname on the DataSource.
Parameter name: dataMember"

my code here :

C#

da.SelectCommand = new SqlCommand("select * from student ",cs);
           ds.Clear();
           da.Fill(ds);
           dataGridView1.DataSource = ds.Tables[0];
         this.textBox1.DataBindings.Add("Text", this.tblnamesbs, "firstname",true);
         this.textBox2.DataBindings.Add("Text",this.tblnamesbs,"lastname",true);

Posted 4-Jan-14 9:17am

mhassan083

Updated 4-Jan-14 9:20am

v2

Add a Solution

Comments

Ron Beyer 4-Jan-14 15:20pm

I believe data binding names are case sensitive, can you verify that your data binding column really is "firstname" and not something like "FirstName".

Karthik_Mahalingam 4-Jan-14 15:32pm

yes Ron, this is the only issue that can occur for this error message., you can post this as answer....

mhassan083 4-Jan-14 15:48pm

No,firstname is firstname and lastname is lastname not FIRSTNAME or LASTNAME or anything else

Karthik_Mahalingam 4-Jan-14 16:04pm

try like this..

this.textBox1.DataBindings.Add(new Binding("Text", this.tblnamesbs, "firstname",true));

mhassan083 5-Jan-14 0:16am

the same error message!

Karthik_Mahalingam 5-Jan-14 0:29am

this.tblnamesbs is a datatable or list ??

mhassan083 5-Jan-14 1:00am

BindingSource tblnamesbs =new BindingSource();

Karthik_Mahalingam 6-Jan-14 19:47pm

post your full code..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2014-01-04T09:30:00

Solution 1

firstname is not present in the datasource this.tblnamesbs.
add first name in the datasource or check the spelling of it . it will resolve ...

i tried this code,its working fine..

C#

DataTable tblnamesbs = new DataTable();

           tblnamesbs.Columns.Add("firstname", typeof(string));
           tblnamesbs.Rows.Add("one");

           BindingSource binding = new BindingSource();
           binding.DataSource = tblnamesbs;

           this.textBox1.DataBindings.Add("Text",binding,"firstname" );

Posted 4-Jan-14 9:30am

Karthik_Mahalingam

Updated 4-Jan-14 19:12pm

v4

Comments

mhassan083 5-Jan-14 0:48am

how can i use this in my code?

Karthik_Mahalingam 5-Jan-14 0:58am

this is just sample..

pls check this.tblnamesbs object..

it is datatable or list?

apply break point and check the column firstname exists ?
if so , please check the case. or any space at end etc..

mhassan083 5-Jan-14 1:02am

is BindingSource tblnamesbs =new BindingSource();

Karthik_Mahalingam 5-Jan-14 1:12am

check my updated solution..

mhassan083 5-Jan-14 5:49am

yes,good

Karthik_Mahalingam 5-Jan-14 5:51am

if u issue is resolved,pls close this post.

mhassan083 5-Jan-14 6:20am

this code is necessary:
tblnamesbs.Rows.Add("one");

mhassan083 5-Jan-14 6:24am

also when click more one time give me this error:
(this causes two binding in the collection to bind to the same property
parameter name:binding)

Karthik_Mahalingam 5-Jan-14 6:27am

whenever u r binding the datasource to the databindig, pls make sure that the property is available in the binding..
keep break point and check it..

mhassan083 6-Jan-14 11:10am

property is available in the binding

Karthik_Mahalingam 5-Jan-14 6:26am

no, i have done for testing purpose..