|
In your select statement include a where clause the would be a built string based on the input the user entered. For example:
"WHERE mydate < CONVERT(DATETIME, '" + "07/01/2009" + "00:00:00', 103)"
Replace 07/01/2009 with logic that would build that part of the string based on the user inputs.
|
|
|
|
|
Hi,
Take the input from the user which would be in the form of '=, >, >=, <, <=' and the string with this try to make a filter condition and apply it to the rowFilter of the dataview.You will surely get..
Regards
Anju
|
|
|
|
|
Hi,
I can't see what's wrong with this code. I am getting "1/2/2009 9:00:00 AM" displayed in the textBox when I'm expecting "1/2/2009 9:00:00 PM". Can anyone tell me what I'm doing wrong here, please?
DateTime dateTime;
DateTime.TryParseExact("1/2/2009 9:00 PM", "d/M/yyyy H:m tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime);
textBox1.Text = dateTime.ToString();
I'm using VS2008 and targeting .NET 3.5 and have "en-AU" as the default Windows culture.
Thanks, Henk.
|
|
|
|
|
|
Thanks stancrm, I was reading up on the "g" you used and that led me to Custom Format Strings at http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^] where I realised I should be using h instead of H if I'm wanting to parse the AM/PM part. Thanks for assisting. Regards, Henk.
|
|
|
|
|
Hi,
Please let me know how to add a filter for DataGridView so that the user can enter the filter condition in the corresponding column header to filter the rows that match the condition.
I am new to C#. Requirement is simillar to how it is in Mercury Quality center or TestDirector tools.
Hope the question is clear..
Thanks & Regards,
Dhana
modified on Tuesday, August 11, 2009 8:29 AM
|
|
|
|
|
Hi,
Since the DataTable source is assigned to DataGridView, you can filter the DataTable by using
DataTable.DefaultView.RowFilter="ColName=" + ColValue
It will automatically apply to the DataGridView
Sreedhar
|
|
|
|
|
Thanks very much..i am now using the simillar code for implementing the filter.
Thanks & Regards,
Dhana
|
|
|
|
|
If this is a bound DataGridView, you are not allowed to add rows. Hence you will need to extend the DataGridView if you need a filter like Quality center.
A quick and dirty (and may be "not recommended") way is:
1. Provide padding the headercell.
2. Add a textbox to the DataGridView at the location right above the first row.(You will need to play with the location of the textbox)
3. Handle its TextChanged event and set the RowFilter property of the datatable you have.
A better solution IMO will be to have a button and display a modal window where in user can apply filter.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Thanks very much..I have followed the steps that you have given and created it..as you said it is ugly..it seems the same to me..I am trying to make it more clean.
Thanks & Regards,
Dhana
|
|
|
|
|
Does DataGridView Filter Popup[^] help?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I think this is wanted i actually wanted..thanks very much..I trying to incorporate this framework. Thanks very much..it has really helped me ..
Thanks & Regards,
Dhana
|
|
|
|
|
Hi All,
I am having problems adding a new row to a datagridview control in my form. I have a simple form
a datagridview. When the user types in an item number at columen one , the system will populate the datagridview with the relevant data from the database.
|
|
|
|
|
how far have you tried... can you send the code ....
|
|
|
|
|
mohammad alnoed wrote: a new row to a datagridview control in my form
Try out the following code -
dataGridView1.AlloUserToAddRows = True;
Keep me posted if this resolves your problem.
|
|
|
|
|
Take a look at this[^] thread. Although it is about a ComboBox in a DGV the same principle can be applied to hooking an event for a DataGridViewTextBox (or whatever you are using). All you have to do is decide which event is most appropriate for your needs.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi,
Can anyone tell , how can I get duration of audio file with c#
|
|
|
|
|
This google search[^] yeilds plenty of results
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
is there a location in the hard drive where one can find windows toolStrip icons?
|
|
|
|
|
IIRC they are in a subfolder of the common folder in the Visual Studio install. If you did a custom install, you may not have selected them so you will have to run set up and modify.
If you are running an express version, then they do not exist for you.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
I'm using express ):
i'll printScreen them... thanks!
|
|
|
|
|
Hi all.
I wanna convert a string ( eg : "0110101" ) to equal of it in Binary ( 0110101 )
Could you please guide me ?
Thanks.
|
|
|
|
|
You can use:
int i = Convert.ToInt32 (binaryString, 2); If you are doing a lot of this in your application you may find my article[^] useful.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Beat me to it. I had half a mind to post a home-made binary conversion function - I've been thinking about it for weeks
Between the idea
And the reality
Between the motion
And the act
Falls the Shadow
|
|
|
|
|
I really need to revisit that article. It served the requirements that I had at the time so that's as far as I went with it, but it could be more useful with a little work. I was resonably new to C# then too so there are probably a few things that could do with refactoring.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|