How to Filter a grdiview in windows App from a TextBox

Question

0.00/5 (No votes)

See more:

Hi all , how can I filter my grdiview by date from a textbox?
I know there are tons of tutorials in here for that but I have only come across
Web application example how can I do that given I have gridview, textbox where I enter the "date" and it should filters as required.
Thanks for any advice
Julie.

Posted 2-Apr-15 8:18am

Julia Fraveau

Updated 2-Apr-15 8:37am

v3

Add a Solution

Comments

sudevsu 2-Apr-15 16:20pm

Did you Datagridview from toolbox in Windows Forms application?

sudevsu 2-Apr-15 16:25pm

Also share what you have tried.

murkalkiran 3-Apr-15 5:11am

why your using textbox instead you can use datetimepicker in windows application

Julia Fraveau 3-Apr-15 5:34am

Hi@ murkalkiran please how can i implement that?

sudevsu 3-Apr-15 8:57am

Julia, In the toolbox, instead of Textbox use DateTimepicker. If you drag and drop the datetimepicker and change the ID dtStart.
Then if you change the date from the form, it can stored in a string or Date variables like "dtStart.Value"

Julia Fraveau 3-Apr-15 10:26am

@Sudevsu, I have done that this my method private void dateTimePicker1_ValueChanged(object sender, Event Args e){Dataview view=new Dataview;dataGridView1.DataSource=view;view.RowFilter=("EndTime=#{0}#,datTimePicker1.Value.TolongDateString()); thats what I have ,but errors erros

sudevsu 3-Apr-15 10:34am

Ok wait let me try on my end.

Julia Fraveau 3-Apr-15 10:42am

ok thanks

sudevsu 3-Apr-15 11:13am

I don't understand what's wrong with your code. But for me it works absolutely fine.
me.dataview.rowfilter = "dbDate = '" + dt.ToString() + "'"

sudevsu 3-Apr-15 11:15am

view.RowFilter = "Shipdate= '" + Date.Today() + "'"
also works good in my code.

sudevsu 3-Apr-15 11:16am

Just add a watch to the date value in the View and the value from Datetimepicker. This should know you understand why you are having problems/ errors

Julia Fraveau 3-Apr-15 11:27am

May the reason is because I am pulling from an access DB and the way dates field was designed is in MM:dd:yyyy:mm:ss is that an isue?

Julia Fraveau 3-Apr-15 11:19am

Thanks for your time Sudevsu, i GET "The Expression contains an invalid string constant

sudevsu 3-Apr-15 11:22am

I knew it. No problem. Take care

sudevsu 3-Apr-15 11:23am

using rowfilter with string values is quite easy. When you don't mess them up with Date time types. Just have value of date in one format throughout the project and continue filtering the same way. Hope you got it.

Julia Fraveau 3-Apr-15 11:29am

Thanks Sudevsu, am only working on fixing a solution that has been there I did not designed such DB ,just so you know, but thanks again for your time

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ekona_Pikin · Accepted Answer · 2015-04-04T04:57:00

Solution 1

Hey Julia,I just solved this problem my self with the help of "@George Jonsson" here on this site, so go to this link and see how I did mine using dateTimePicker and just follow suit ,you should be fin Ok:))
ow to filter DataGridView by dateTimePicker[^]>

Posted 4-Apr-15 4:57am

Ekona_Pikin

Comments

Julia Fraveau 4-Apr-15 11:00am

Thanks @Ekona_Pikin let me get on it.

Julia Fraveau 4-Apr-15 11:05am

Hey Ekona_Pikin on your method to select did you put the code in a button_click or where?

Ekona_Pikin 4-Apr-15 11:10am

Yea goto to toolbox and grab dateTimePicker1, click on it and paste the method you would be using to connect to your database and what ever you want to do including your select statement as seen in mine,Note if you are using access DB instead of '{0:}'<== use #{0}# and you should be set.

Julia Fraveau 4-Apr-15 11:19am

Yay!!! works thanks I guess I will say thanksboth @George Jonsson and Ekona_Pikin works perfect actually I used the of "MM/dd/yy HH:mm" since my date field in my DB was in a military Time format so works great:))))

Ekona_Pikin 4-Apr-15 11:26am

Great, glad is working for you too.