How to populate Combobox through WCF Service

Question

0.00/5 (No votes)

See more:

Hi Freinds,

I am having an item Master with 200000 records. when I populate the combobox through WCF service, gets the follwoing error, however I have passed the maximum message size in the app.config.

The maximum message size quota for incoming messages (2147483647) has been exceeded.

could you please guide me how to fill a huge data through WCF service in client application .

here is the sample Code.

WCF service

public class ItemMaster
{
int ItemId;
string ItemName;
...
}

 List< itemmaster >  GetItemMaster()
{
....
}

Client application.

Combobox1.DataSource = cmbService.GetItemMaster();
combobox1.DisplayMember ="ItemName";
combobox1.ValueMember ="ItemId";

Thanks

Posted 28-Jun-10 20:24pm

rajeshswami27

Updated 28-Jun-10 20:26pm

v3

Add a Solution

2 solutions

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)

*dan!sh* · Answer 1 · 2010-06-29T04:57:00

Read this[^] article. It should help.

You can also increase the message size in the binding configuration and it will work.

BTW, why are you binding Combobox with that huge set of values? A normal human being cannot process that many records in one go. I think you need a bit of re-designing of your application.

amjad islam amjad · Answer 2 · 2013-08-15T20:26:00

//In wcf services
[OperationContract]
public List GetCountry()
{
List listcountry = new List();
using (SqlConnection con=new SqlConnection(connection))
{
using (SqlCommand cmd=new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "select * from Country";
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Country country = new Country();
country.Id = Convert.ToInt32(reader["Id"].ToString());
country.CountryName = reader["CountryName"].ToString();
listcountry.Add(country);
}
}
}
return listcountry.ToList();
}

// In you xaml CS file

private void ComboBoxTest_Loaded(object sender, RoutedEventArgs e)
{
ServiceReference1.Service1Client connection1 = new ServiceReference1.Service1Client();
connection1.GetCountryCompleted += new EventHandler(GetCountry);
connection1.GetCountryAsync();
}

private void GetCountry(Object sender, ServiceReference1.GetCountryCompletedEventArgs e)
{
if (e.Error != null)
{
MessageBox.Show("Fail To Get Country" + e.Error.Message);
return;
}
else
{
ComboBoxTest.ItemsSource = e.Result.ToList();
ComboBoxTest.DisplayMemberPath = "CountryName";
ComboBoxTest.SelectedValuePath = "Id";
}
}

How to populate Combobox through WCF Service

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0