how to perform a search in dgview by date range

Question

how to perform a search in dgview by date range

Navigation

#1 by (1 votes)

0

As I can perform a mediating search a date range with two datetimepicker and a button it is worth noting that I filled my datagridview in this way:

    adapter = new MySqlDataAdapter("Mostrar_ClientesExamen", C.conect);
    adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
    table = new DataTable();
    adapter.Fill(table);
    gridControl1.DataSource = table;
    C.CerrarConexion();

mysql c# windows-forms

asked by Greyner Caceres Blandon 12.02.2017 в 06:26

source

1 answer

pdo date format Hide div except image with jquery

score 1 · Accepted Answer

You could help with linq to perform the search within the grid

var result = from row in gridControl1.Rows.Cast<DataGridViewRow>()    
                where Convert.ToDateTime(row.Cells["nombrecolfecha"].Value) > dtpFechaDesde.Value
                   && Convert.ToDateTime(row.Cells["nombrecolfecha"].Value) > dtpFechaHasta.Value
            select row;

with this linq you get a list of rows that meet the condition, then you can go through them or maybe in the linq define a select and get a class, this will depend on what you want to do with the data obtained