Binding datatable to textboxes in winforms c#

Question

0.00/5 (No votes)

See more:

I need to bind fields of datatable to textboxes in winfrom here's the code i'm using:

C#

string currenciesQuery = "SELECT * FROM Currencies";
           currencyDataSet1 = new DataSets.CurrencyDataSet();
           DataTable dataTable = currencyDataSet1.Tables.Add("Currencies");
           string connectionString = System.Configuration.ConfigurationSettings.AppSettings["SQLConnectionString"].ToString();

           using (SqlConnection connection = new SqlConnection(connectionString))
           {
               SqlDataAdapter dataAdapter = new SqlDataAdapter(currenciesQuery, connection);

               dataAdapter.Fill(currencyDataSet1, "Currencies");
           }

           txtId.DataBindings.Add("Int", dataTable, "CurrencyId");
           txtCode.DataBindings.Add("Text", dataTable, "CurrencyCode");
           txtName.DataBindings.Add("Text", dataTable, "CurrencyName");
           txtRate.DataBindings.Add("Decimal", dataTable, "CurrencyRate");

It's generating an exception:

"Cannot bind to the property 'Int' on the target control.
Parameter name: PropertyName"

Posted 23-Nov-13 8:40am

AR1988

Updated 13-Dec-16 22:25pm

Add a Solution

2 solutions

Solution 2

//txtId.DataBindings.Add("Int", dataTable, "CurrencyId");
txtId.DataBindings.Add("Text", dataTable, "CurrencyId");
//txtRate.DataBindings.Add("Decimal", dataTable, "CurrencyRate");
txtRate.DataBindings.Add("Text", dataTable, "CurrencyRate");

Posted 13-Dec-16 22:25pm

Member 12704333

Comments

CHill60 14-Dec-16 20:34pm

Your "solution" is unclear... in what way is it any different to Solution 1 from 3 years ago? Erm, in no way

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)

Peter Leow · Accepted Answer · 2013-11-23T09:16:00

Solution 1

Two mistakes:

C#

//txtId.DataBindings.Add("Int", dataTable, "CurrencyId");
txtId.DataBindings.Add("Text", dataTable, "CurrencyId");
//txtRate.DataBindings.Add("Decimal", dataTable, "CurrencyRate");
txtRate.DataBindings.Add("Text", dataTable, "CurrencyRate");

Posted 23-Nov-13 9:16am

Peter Leow

Comments

AR1988 23-Nov-13 15:18pm

Cannot bind to the property or column CurrencyCode on the DataSource.
Parameter name: dataMember

Peter Leow 23-Nov-13 16:05pm

Let's solved one thing at a time. Was the first exception '"Cannot bind to the property 'Int' on the target control. Parameter name: PropertyName" solved by my first solution?

The second exception is saying that there is no 'CurrencyCode' on the DataSource, please check that it exists in the Currencies table, or is it typo?

satheeshk787 21-Sep-14 10:51am

Thanks.....