one dataGrid with 3 search option
<p>My scenario is : I have one dataGrid with 5-6 columns. i have 3 filters which use 3 SQL queries methods in codeBehind :SearchByName(), SearchByValue() , SearchByDate().I have fourth method show DefaultShow() which display all data without any filters.
Basicly I want when Page is loaded DefaultShow() method to load and then user can choose option for search with RadioButtonList</p>

<p>DefaultShow() code is : </p>

<pre><code> public void DefaultShow()
        {
            string connectionString = cs.getConnection();
            string query = "select Id ,name,value,Description,DateCreate from AllCostView where  IdUser = '" + cui.getCurrentId() + "'";
            using (SqlConnection myConnection = new SqlConnection(connectionString))
            {
                myConnection.Open();

                SqlCommand command = new SqlCommand(query, myConnection);

                SqlDataAdapter mySqlAdapter = new SqlDataAdapter(command);
                using (DataTable myDataTable = new DataTable())
                {
                    mySqlAdapter.Fill(myDataTable);
                    GridViewCost.DataSource = myDataTable;
                    GridViewCost.DataBind();
                }

            }
        }



protected void Page_Load(object sender, EventArgs e)
        {

                DefaultShow();

        }
</code></pre>

<p><strong>But this not work what am I miss?</strong></p>

<p>My gridViewCode is this : </p>

<pre><code>&lt;div class ="gridView"&gt;
    &lt;asp:GridView ID="GridViewCost" runat="server" AutoGenerateColumns="False" CaptionAlign="Top" 
        ShowFooter="True" ShowHeaderWhenEmpty="True" Font-Overline="False" 
        Font-Strikeout="False" Font-Underline="False" 
         AllowPaging="true"
        PageSize="5"
        CssClass="mGrid"  
    PagerStyle-CssClass="pgr"  
    AlternatingRowStyle-CssClass="alt" OnPageIndexChanging="GridViewCost_PageIndexChanging" OnSelectedIndexChanged="RadioButtonList1_SelectedIndexChanged" &gt;
        &lt;AlternatingRowStyle CssClass="alt"&gt;&lt;/AlternatingRowStyle&gt;
        &lt;Columns&gt;

            &lt;asp:BoundField DataField="Id" HeaderText="Номер" /&gt;
            &lt;asp:TemplateField HeaderText="Име"&gt;
                &lt;EditItemTemplate&gt;
                    &lt;asp:TextBox ID="TextBox1" runat="server" Text='&lt;%# Bind("Name") %&gt;'&gt;&lt;/asp:TextBox&gt;
                &lt;/EditItemTemplate&gt;
                &lt;ItemTemplate&gt;
                    &lt;asp:Label ID="Label1" runat="server" Text='&lt;%# Bind("Name") %&gt;'&gt;&lt;/asp:Label&gt;
                &lt;/ItemTemplate&gt;
                &lt;ControlStyle Width="100px" /&gt;
            &lt;/asp:TemplateField&gt;
            &lt;asp:BoundField DataField="Value" HeaderText="Стойност" /&gt;
            &lt;asp:BoundField DataField="Description" HeaderText="Описание" /&gt;
            &lt;asp:BoundField DataField="DateCreate" HeaderText="Дата"   /&gt;

        &lt;/Columns&gt;
        &lt;AlternatingRowStyle /&gt;
        &lt;HeaderStyle  HorizontalAlign="Right"/&gt;
        &lt;PagerStyle /&gt;
        &lt;RowStyle BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" HorizontalAlign="Center" /&gt;

    &lt;/asp:GridView&gt;
</code></pre>

<p>If it's needed i will post more code . Thanks.</p>
