Adding a filter functionality to my database form. What's wrong withthat code?

[Lothar Behrens]

Hi,

I have a problem to filter my result set to a specific row, or prepare
the result set properly anyhow.

The Form_Load method code was my template for a new filter method.

private void FormMakler_Load(object sender, EventArgs e)
{

this.kostenstelleTableAdapter.Fill(this.provisionsabrechnungDataSet.Kostenstelle);

this.maklerTableAdapter.Fill(this.provisionsabrechnungDataSet.Makler);
}

public void SelectMakler(int MaklerID)
{
ProvisionsabrechnungDataSet.MaklerRow[] foundRows =
(ProvisionsabrechnungDataSet.MaklerRow[])
this.provisionsabrechnungDataSet.Makler.Select(" id = " +
MaklerID.ToString());

this.provisionsabrechnungDataSet.Makler.Clear();

this.provisionsabrechnungDataSet.Makler.AddMaklerRow(foundRows[0]);
int count =
this.provisionsabrechnungDataSet.Makler.Count();


this.maklerTableAdapter.Fill(this.provisionsabrechnungDataSet.Makler);
}

The variable count tells me that the filterproperly works as I get 1
as a value. But my form keeps displaying the first
entry of the resultset with about 4058 entries.

Is there any sample around how to do it better?

Thanks

Lothar

 

[Mr. Arnold]

Is there any sample around how to do it better?

<http://msdn.microsoft.com/en-us/library/bb470363.aspx>