Filter Gridview by date as parameter in ASP.Net

Hi

How can i filter dates by Parameters and  see only  3

Columns from the datatable.

Thank You.

frmDados.TBORDENSTRAB.SQL.Text := 'SELECT * FROM ORDEMTRABALH '+
                        'WHERE (CLIENTENINC like :D3 and (INCROTA like :D2) and (PROG_PROXI BETWEEN :dataIni AND :dataFim) and MAQ_ATIVA LIKE ''%' + 'S' +  '%'' and OT_ESTADO not like ''%' + 'FECHADA'+ '%'' ) '+
                       'ORDER BY MAQ_LOCAL,ROTA_COD,MAQ_NOME ASC';
frmDados.TBORDENSTRAB.Params.ParamByName('dataIni').AsDate:= datainic.Date;
frmDados.TBORDENSTRAB.Params.ParamByName('dataFim').AsDate := datafinal.Date;
string query = @"select  * from ORDEMTRABALH  where PROG_PROXI  BETWEEN @startDate AND @endDate";
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DBMANUTEN"].ConnectionString))
{
    using (MySqlCommand cmd = new MySqlCommand())
    {
        cmd.Connection = conn;
        cmd.CommandText = query;
        cmd.Parameters.AddWithValue("@startDate", "00-00-0000");
        cmd.Parameters.AddWithValue("@endDate", "00-00-2016");
        try
        {
            conn.Open();
            MySqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())

            // other codes
            // to fetch the record
            GridViewOrdenst.DataSource = dr;
            GridViewOrdenst.DataBind();
        }
    }
}