Re: display records between a date range - C# Discussion Boards

display records between a date range

28-Jul-08 6:47

netJP12L wrote:
I played around with all the properties

That is insufficient; you must either try all combinations of all settings, or read the documentation.

The minimize and maximize buttons have a bool property controlling them. You don't have to select
a special border style for that reason.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Reality Strikes28-Jul-08 6:09

28-Jul-08 6:09

Now since I have got the report working and displaying properly, I'm struck @ this thing and I've got lots of confusion revolving this.

I've got a table with 5 fields in which date was splitted in 4 columns as DD, MM, YY1 and YY2. Using dataset (C#.Net), I've added a new column and concatenated these 4 fields into one and made it look like a date field (mm-dd-yyyy) and this field is a String field. Now the actual problem is that I want to display report based on a Date Range Selection from my Form (i.e 2 Textboxes for Start Date and End Date). I've not much clear idea as how to proceed validating the records as it can't be done at the database level since my database doesn't have anything like a Date Field.

Any suggestions would be highly appreciated.

Luc Pattyn28-Jul-08 6:26

28-Jul-08 6:26

Hi,

I can see only two clean ways to do date ranges:

1. use a real Date or DateTime field in the database, then SQL Server will be able to do real
date checking.

2. use an integer field in the yyyyMMdd format (as I suggested before), so numeric and chronological
order are the same, hence you can do numeric comparison.

A field that "look like a date field (mm-dd-yyyy)" is of no use to SQL server!

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Reality Strikes28-Jul-08 7:12

28-Jul-08 7:12

Luc, there is nothing much I can do on the database coz it resides on the AS400 IBM iSeries server and that's the way how dates are stored in mainframe systems.

Then regarding the "looking like date field", its infact the the date itself which is stored in a string field and if I'm not wrong that can be converted into integer or date field..........that's wht i think...........am i right............???

and moreover, i need help on the logical part of how to proceed on it.........

Luc Pattyn28-Jul-08 7:29

28-Jul-08 7:29

if that is the way dates are kept all the time (I do find that hard to believe), then they are bound
to have a way to do date comparisons and date range checks based on that format too...

I am afraid I can't help you any further, I am no database expert, and never addressed an AS400.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Reality Strikes28-Jul-08 7:45

Re: display records between a date range [modified]

28-Jul-08 7:45

Luc, that's the way they do it in mainframe server. But the thing is that I'm looking for something which could actually help me in doing the date range comparison at the code level. Normally we do it at the database level but since my database doesn't have a date field, I've to do it at the code level. I'm saying so, coz my code concatenates the 4 different fields into one field and display it as date field on crystal report. So if there are chances of any comparison for date range then it has to be done at code level only coz that's the place where its actually shown up as date field.

Did i confused you...........????

To be more clear, I want the date range comparison to be done exactly after the code where its concatenating the fields.............and the code for the same is as given below:

for(Int32 i = 0; i < newPDS.Tables[0].Rows.Count; i++)
{
	DataRow row = newPDS.Tables[0].Rows[i];

	row["ADM_DATE"] = row["CADMMM"].ToString() + "/" + row["CADMDD"].ToString() + "/" + row["CADMHH"].ToString() + row["CADMYY"].ToString();            
}

Luc Pattyn28-Jul-08 8:03

28-Jul-08 8:03

Hi,

if you have numeric values for year, month and day, you can create a new DateTime() instance
with the corresponding value DateTime dt=new DateTime(year, month, day);

[ADDED] If all you have is a datelike string, then you can try and extract a DateTime from it
using DateTime.Parse(), DateTime.ParseExact() or DateTime.TryParse().[/ADDED]

And when you have two DateTime instances you can compare them with the comparison operators
such as < and == and >

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

modified on Monday, July 28, 2008 2:21 PM

User 665828-Jul-08 8:44

User 6658

28-Jul-08 8:44

I wouldn't fetch all records and do it on client side, because it would unnecessarily create high load on the database server and fetch more records than actually needed. Can't you do something like this on server side?

SELECT ... 
FROM table 
WHERE YY >= startyear 
AND MM >= startmonth 
AND DD >= startday 
AND YY <= endyear
AND MM <= endmonth
AND DD <= endday

regards

modified 12-Sep-18 21:01pm.

Luc Pattyn28-Jul-08 8:55

28-Jul-08 8:55

The principle is OK, but the implementation is wrong.

There is a huge difference between date1<date2
and
year1<year2 AND month1<month2 AND day1<day2

The correct way would be something like this:
year1<year2 OR (year1==year2 AND (month1<month2 OR (..etc..))

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Reality Strikes29-Jul-08 4:03

Best way to use Dispose / IDisposable - no unmanaged code

29-Jul-08 4:03

I totally agree with what you guys are saying, but please let me know whether I can use the SELECT statement on DataSet the same way as we use on Database tables coz I don't have the datefield in database table, its only the newly created DataSet which is holding the DateField.

Let's say, the code goes like this :

DataColumn dCol = new DataColumn(newPDS.Tables[0].Columns.Add("ADM_DATE", typeof(String)).ToString());
for(Int32 i = 0; i < newPDS.Tables[0].Rows.Count; i++)
{
	DataRow row = newPDS.Tables[0].Rows[i];

	row["ADM_DATE"] = row["CADMMM"].ToString() + "/" + row["CADMDD"].ToString() + "/" + row["CADMHH"].ToString() + row["CADMYY"].ToString();
}

Now its the newPDS DataSet, which is having the DateField. So, now please tell me a way to apply the date range thing within this piece of code. (Date range from Form is entered in 2 Textboxes as START_DATE and END_DATE in the format of DD/MM/YYYY.

THANKS

DaveyM6928-Jul-08 4:56

DaveyM69

28-Jul-08 4:56

I have a simple class that inherits from TextBox and has a member variable
ErrorProvider m_ErrorProvider

ErrorProvider has a dispose method so I've implemented IDisposable and my Dispose method is simply

void IDisposable.Dispose()
{
    m_ErrorProvider.Dispose();
    base.Dispose();
}

Is this sufficient?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Best way to use Dispose / IDisposable - no unmanaged code

Simon P Stevens28-Jul-08 5:01

Simon P Stevens

28-Jul-08 5:01

No.

You should override the bases Dispose(bool disposing) method.

Follow the dispose pattern[^] for a derived class.

Simon

Re: Best way to use Dispose / IDisposable - no unmanaged code

DaveyM6928-Jul-08 5:06

DaveyM69

28-Jul-08 5:06

I had just been on that page but missed the derived class bit!

Thanks.

So this should be OK?

void IDisposable.Dispose()
{
    Dispose(true);
}

protected override void Dispose(bool disposing)
{
    if (disposing)
    {
        m_ErrorProvider.Dispose();
    }
    base.Dispose(disposing);
}

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Best way to use Dispose / IDisposable - no unmanaged code

Simon P Stevens28-Jul-08 5:13

Simon P Stevens

28-Jul-08 5:13

DaveyM69 wrote:
I had just been on that page but missed the derived class bit!

Considering that the dispose pattern is one of the most used in .net, that page is really rather poorly laid out. It's pretty easy to miss.

DaveyM69 wrote:
So this should be OK?

You don't need the unparamaterised dispose method. That is naturally inherited from the base.

void IDisposable.Dispose()
{
    Dispose(true);
}

protected override void Dispose(bool disposing)
{
    if (disposing)
    {
        m_ErrorProvider.Dispose();
    }
    base.Dispose(disposing);
}

Simon

Re: Best way to use Dispose / IDisposable - no unmanaged code : Solved

DaveyM6928-Jul-08 5:19

DaveyM69

28-Jul-08 5:19

Cheers Simon Big Grin | :-D

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Best way to use Dispose / IDisposable - no unmanaged code : Solved

Simon P Stevens28-Jul-08 5:28

Simon P Stevens

28-Jul-08 5:28

Pleasure.

Simon

Re: Best way to use Dispose / IDisposable - no unmanaged code

Paul Conrad28-Jul-08 5:37

Paul Conrad

28-Jul-08 5:37

DaveyM69 wrote:
Is this sufficient?

~~I believe so.~~ Correct me if I'm wrong, but don't the destructors automatically call base.Dispose?

----modified

Saw Simon's reply. Learned something new this morning.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Connecting to word without ROT.

Green Fuze28-Jul-08 3:54

Green Fuze

28-Jul-08 3:54

Hey everybody

I wondered if there is a way to connect to word application without the running object table.
Meaning, instead of getting the COM object from the ROT, ask from running instance of word (queryInterface or something like that...).

Thanks a lot!

Re: Connecting to word without ROT.

Green Fuze28-Jul-08 5:35

Green Fuze

28-Jul-08 5:35

what I found out until now:

Using the following code we're creating in C# a word application.
This application creates a new process of "winword.exe" because we're not checking the ROT for already running instances of word.

Type T = Type.GetTypeFromCLSID(new Guid("{000209FF-0000-0000-C000-000000000046}"));
Word.Application app = (Word.Application)Activator.CreateInstance(T);
app.visible = true;

What I still couldn't find is a way to connect to the running word (without ROT).
all I have is the Process ID.

I want to connect Word without waiting until it registers the ROT (in word's focus out event).
Thanks again!

Lock a file for reading when uploading it to FTP

thoru28-Jul-08 3:31

thoru

28-Jul-08 3:31

Hello all,
I am having a bit o problem and i need a simple, elegant fix.
The problem: I am uploading a file to a ftp using FtpWebResponse and the Write method from a ftpRequest. I need this file locked for reading until all content has been uploaded to the Ftp and the write method has stopped.
Another app. (actually the same, but on a different machine) will download this file, and i need to read it only when the write method has stopped.
So far, my solutions do not work fully or are very very ... ugly Big Grin | :-D

Thx

Re: Lock a file for reading when uploading it to FTP

Wendelius28-Jul-08 3:37

Wendelius

28-Jul-08 3:37

Hi,

If you're using Open-method on File class use FileShare.None for share parameter. This should prevent opening the file elsewhere.

Mika

Re: Lock a file for reading when uploading it to FTP

Luc Pattyn28-Jul-08 3:45