datagridview with datetimepicker code

[vijaycare]

Hi, I am a new one to vb 2005. I dont know how to filter the datagridview with the 2 datetimepicker control one for start date and another one for end date. I want to search the dates based on the datevalue of the data in one coloumn.

Any one can help me?
Thanks in advance.

[y2_sub]

Is the DataGridView Bound or Unbound , could you please be more specific , and if you can post the code to fill your datagridview

[kvprajapati]

>I dont know how to filter the datagridview with the 2 datetimepicker control

You can filter the datasource easily using DataView.

Create an instance of System.Data.DataView

Dim dt as new  DataTable
// You have to populate the datatable instance

 Dim dv as DataView =new DataView(dt)

 DataGridView1.DataSource=dv

Filter your data,

dv.RowFilter="StartDate>='" + dateTimepicker1.value + "' and EndDate<='" + dateTimepicker2.value + "'"

[vijaycare]

Yes Its databound control which I have used. Kindly let me know how can i filter the date value in my data with datetimepickers.

Thanks in advance

[y2_sub]

please reread adatapost's reply

[vijaycare]

Hi,
I think it is working. but it will takes the database month as date.
Can U tell me where I made a mistake?

[pedrohas2000]

appear a problem when i use this code :

dv.RowFilter="StartDate>='" + dateTimepicker1.value + "' and EndDate<='" + dateTimepicker2.value + "'"

the message :
cannot find Collum StartDate, and cannot find Collum EndDate

Somebody knows what is happening?

[adam_k]

as the error suggests your datagridview doesn't have a column named startdate and a column named enddate.

You should change the filter to match the columns you want to filter:

dv.RowFilter="your_column_here>='" + dateTimepicker1.value + "' and your_column_here<='" + dateTimepicker2.value + "'"

You can use 2 columns like adatapost's sample or filter the same one.

[M.Waqas Aslam]

hi !
if u r using sql db to populate ur grid then use this code

dim mycon as new sqlconnection("ur connection string ")
dim ds as new dataset()
dim da as new sqldataadapter("select * from table1 where fielddate >=" & datetimepicker_from.value.date & "and fielddate<="&datetimepicker_to.value.date,mycon)
ds.table("mytable").clear()
da.fill(ds,"mytable")
datagridview.datasource = ds.table("mytable")

this code only shows the record between from and to date , given by the user ,
hope this will helpful for u,
Regards
M.Waqas Aslam