Somewhere i have read that if i use this code it automatically distinct all replied rows but when i use it i doesn't do that. What's problem? thanx in advance

private void comboBox1_Click(object sender, EventArgs e) {

        PersonTableCollection persontable = new PersonTableCollection();
        comboBox1.DataSource = persontable;
        comboBox1.DisplayMember = "Title";
        persontable.GetMulti(null);
    }

You have a PK on your table, don't you? GetMulti() returns all the records of a table, and they should be distinct.

no very pity that i don't have pk for this field. There are many same reecords in this table ,i must choose only distinct fields. if there has no solution of this product then i must change my table configuration

It's better to have a PK.

Also you may do the following: Use a dynamic list or a typed list and specify when you fetch it that allowduplicates should be false. See in the documentation: Using the generated code -> Selfservicing/adapter -> Using views and lists -> Using dynamic lists (or usign the typedlist classes).

You can set the PK fields in the designer: open the entity in the editor, then select the field which should be the PK, and check the checkbox to make it part of the PK. Save, regenerate.

all the options here is passive(may be it allows to change this options when the table is empty.in my case it's not empty)

ironcross wrote:

all the options here is passive(may be it allows to change this options when the table is empty.in my case it's not empty)

What exactly do you mean with 'all options here is passive' ?