C# Discussion Boards - CodeProject

1-Aug-11 4:11

hi to every one
i try to use ozf2 or ozf3 file in my application
is there any way to use this files with C#?
i know the ozf file is indexed image file with it we can load part of image in memory
but how can do that?
i want use this image for GPS map file
if can't do this is there any other way to load GPS map?

David19871-Aug-11 5:10

David1987

1-Aug-11 5:10

mohsen-unique wrote:
is there any way to use this files with C#?

Yes, always. A file is just a bunch of bytes, nothing stops you from using them.
I have no idea what a ozf2 files looks like inside though.

Mohsen Shahindust1-Aug-11 5:17

1-Aug-11 5:17

the ozf2 file is a kind of file for map that used in oziexplorer program.this program in gps tracking
for more information about oziexplorer go to http://www.oziexplorer3.com/[^]

David19871-Aug-11 5:24

David1987

1-Aug-11 5:24

Ok, I can't find any useful information there though - such as the structure of the file.

Mohsen Shahindust1-Aug-11 5:31

1-Aug-11 5:31

i have same problem i can't found any information about structure of the file Cry | :((

Pete O'Hanlon1-Aug-11 5:38

Pete O'Hanlon

1-Aug-11 5:38

So what are you trying to do? Crack open the files so that you can extract the underlying maps?

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Mohsen Shahindust1-Aug-11 5:46

1-Aug-11 5:46

na i want use the ozf file for my application that load map file and show the location of user from GPS device

Pete O'Hanlon1-Aug-11 5:53

Pete O'Hanlon

1-Aug-11 5:53

It looks like this file format was invented by the author for his application. I doubt you'll find it readily available anywhere I'm afraid.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

how run access query with params

David19871-Aug-11 5:53

David1987

1-Aug-11 5:53

See if the file looks like this:
https://svn.osgeo.org/gdal/sandbox/klokan/ozf/ozf-binary-format-description.txt[^]

goldsoft1-Aug-11 4:05

goldsoft

1-Aug-11 4:05

hi i have this code for update datetime fileds in access using params
SQL = "update ConfTbl set D_from = @MyFrom , D_to = @MyTo where Code = " + Convert.ToInt32(TmpCode1) + "";
OleDbCommand Cmd = Conn.CreateCommand();
OleDbParameter dateparam1 = Cmd.Parameters.AddWithValue("@MyFrom", DbType.DateTime);
dateparam1.Value = dt_From.Value;
OleDbParameter dateparam2 = Cmd.Parameters.AddWithValue("@MyTo", DbType.DateTime);
dateparam2.Value = dt_To.Value;
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
how to change this for run query that find between two dates ?
somthing like: `select * from ConfTbl where Tdate >= #MyFrom# and Tdate <= #MyTo#`
thanks in advance

Re: how run access query with params

Not Active1-Aug-11 4:11

Not Active

1-Aug-11 4:11

One, this seems related to what you posted directly below. Edit the original, don't start a new thread.

Two, FORMAT your code snippets!!!

I know the language. I've read a book. - _Madmatt

find data between 2 dates

goldsoft1-Aug-11 2:25

goldsoft

1-Aug-11 2:25

hi
i have in my access datetime filed that hold date in short format in this format: `01/08/2011`

i have in my C# program datetimePicker that hold date in this format:

`dt_from_A.Value.ToShortDateString()` and hold `01/08/2011`

i try to run this query :

SELECT * FROM ReturnConfTbl where Tdate >= #01/08/2011# and Tdate <= #01/08/2011#

but i dont receive any records

SomeGuyThatIsMe1-Aug-11 2:45

SomeGuyThatIsMe

1-Aug-11 2:45

in sql server, both of those dates default the time to midnight, not sure bout other db's but i assume its the same. If all you have is the one date you can use a some DATEADD function to add a day to it and just make the query Tdate < date + 1. all the db's i've seen have some form of that function as do most popular languages..even javascript can do it.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

PIEBALDconsult1-Aug-11 2:52

PIEBALDconsult

1-Aug-11 2:52

goldsoft wrote:
filed that hold date in short format in this format: `01/08/2011`

Don't store dates as text/char; use a proper date/datetime datatype.

goldsoft wrote:
and hold `01/08/2011`

No, it holds a proper DateTime value; it simply displays the value in that format (or any other).

goldsoft wrote:
>= #01/08/2011# and Tdate <= #01/08/2011#

Use a parameterized query.
Those two values are the same, so you will only get rows with exactly that value. You could use the AddDays method of the DateTime type to calculate the second value.

OriginalGriff1-Aug-11 8:34

OriginalGriff

1-Aug-11 8:34

As PIEBALDconsult said, store dates and times in a proper DateTime, and hand them through as parameters.

It is also worth noting that Access (like every other database I have seen) uses ISO format for dates anyway: yyyy-MM-dd so the query you tried would not work as the date format would cause an error.

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

#realJSOP1-Aug-11 9:54

#realJSOP

1-Aug-11 9:54

This is a SQL question, not a C# question.

You want to use the BETWEEN keyword in your SQL query:

SQL

select * from table where table1.datecolumn BETWEEN date1 AND date2

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

select query proble

love yadav30-Jul-11 20:13

love yadav

30-Jul-11 20:13

what is the right way to fetch only one record from the table where many records of same types exist there ?

PIEBALDconsult30-Jul-11 20:56

PIEBALDconsult

30-Jul-11 20:56

Because you asked in this forum, rather than the Database forum, I assume you mean a DataTable, not a database table, where an SQL solution would be appropriate, so I will recommend you look at Linq and select and take in particular.

If you are looking for SQL please post in the Database forum. I'll still help you there, although I should be asleep already.

GuyThiebaut31-Jul-11 3:12

GuyThiebaut

31-Jul-11 3:12

The generic answer is to use a cursor.
Specifically it really depends on the database engine - for instance in Oracle PL/SQL you can use a loop command to iterate through a table.

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

Not Active31-Jul-11 5:25

Not Active

31-Jul-11 5:25

There are many other ways besides using a cursor, which have inherent problems depending on the situation.

I know the language. I've read a book. - _Madmatt

jschell1-Aug-11 8:20

jschell

1-Aug-11 8:20

GuyThiebaut wrote:
The generic answer is to use a cursor.

That doesn't sound like a good idea to me.

All major databases provide alternatives to that. Oracle certainly does.

At this point I am not sure that answer isn't just wrong.

GuyThiebaut1-Aug-11 8:25

GuyThiebaut

1-Aug-11 8:25

I think I may be misunderstanding his question - I understood him to be asking how does one iterate through a result that returns multiple rows one row at a time...

Since it does not sound like a good idea, to you, could you provide me with better suggestions please as I always want to learn from my mistakes - thanks.

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)