Using a stored procedure parameters to update a datagridview

[EDN Admin]

I have a stored procedure which uses a dynamic query to filter data using any combinations of 8 textbox controls. I know the sp works correctly because when I query the data and I enter any value, it returns the correct data but when I populate any
of the 8 textbox controls with values, it does not update my datagridview unless I fill in ALL 8 textboxes.
I am using a typed dataset and I have the fill method using my stored procedure. As far as I know, I just need to set the 8 arguments of the fill method to the textbox controls right? What am I missing?
Please help, Im new to c# and I know Im missing something so simple.
My code is:

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; private <span style="color:Blue; void btnSearch_Click(<span style="color:Blue; object sender, EventArgs e)
{

<span style="color:Blue; try
{
<span style="color:Blue; this.proc_selectCustomerTableAdapter.FillbyFiltered(<span style="color:Blue; this.ManagerDataSet.proc_selectCustomerFiltered,
txtSearchName.Text,
txtSearchLastName.Text,
txtSearchCC.Text,
txtSearchSpec.Text,
txtSearchDo.Text,
txtSearchBDType.Text,
txtSearchFLType.Text,
txtSearchTrans.Text);

}
<span style="color:Blue; catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
[/code]

<br/>
It does not return any data unless I populate all 8 textbox controls.
Thanks

View the full article