Re: problem with Report Viewer In windows 98 - C# Discussion Boards

Re: Initialization error - how to prevent

Luc Pattyn16-Jul-07 4:18

16-Jul-07 4:18

Hi Frank,

you could make a test setup that creates a new form which selfdestroyes after some time,
put everything in a loop, and make the delay a random number say in the range 100...5000
msec (use a static Random !!) then let this run and watch how long it lives on average
(say 3 minutes).

Now apply my (or other) suggestions to fix, and let the same test run say ten times as
long (hence 30 minutes); if that succeeds, you know you have dramatically improved things.

The whole process would take no more than 1 hour, and need little or no human intervention.
Beats launching it manually 1000 times, and not feeling sure whatsoever... (This is
assuming you manage to make the loop fail sooner or later to begin with).

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Initialization error - how to prevent

fracalifa16-Jul-07 4:51

fracalifa

16-Jul-07 4:51

Hi Luc,

good idea.
My feeling is that this could be a runtime problem (loading the relating lib's on the first start).
Later the lib's are in the file cache and the problem does not occur.

In parallel I will test your suggestion.

Thank's
Frank

Working with multiple monitors

M. J. Jaya Chitra16-Jul-07 1:18

M. J. Jaya Chitra

16-Jul-07 1:18

Hai Everybody,

I want to create an application in which i have to have a single CPU but the results has to be displayed in multiple monitors which are all connected to it. Can any one help me by specifying the requirements.

Best Regards,
M. J. Jaya Chitra

Re: Working with multiple monitors

originSH16-Jul-07 1:56

originSH

16-Jul-07 1:56

M. J. Jaya Chitra wrote:
Can any one help me by specifying the requirements.

Software, hardware, human resourses?

Re: Working with multiple monitors

M. J. Jaya Chitra16-Jul-07 2:03

M. J. Jaya Chitra

16-Jul-07 2:03

Software and hardware resources (For hardware i have posted the same in the hardware discussion board).

Best Regards,
M. J. Jaya Chitra

Re: Working with multiple monitors

originSH16-Jul-07 2:11

originSH

16-Jul-07 2:11

Well on the software side you just need an OS that supports multiple monitors. Which is pretty much all OS's these days. From .Net you can use the 'System.Windows.Forms.Screen' class to deal with what monitors are available and where they are.

For the hardware you just need as many GFX ports as you have monitors. Unless your doing heavy graphics stuff your bog standard graphics card should handle it all. A multicore CPU would probably be handy just to make sure all the windows stay nice and responsive but not a requirement.

problem with Report Viewer In windows 98

michael@cohen16-Jul-07 1:10

michael@cohen

16-Jul-07 1:10

Hello all

at my job i made a Stocks program.
in this stock program there is Reports that show some info from the database.
the report viewer works on windows xp , but on windows 98 im getting this error
An error occurred during local report processing

"The definition of the report 'Main Report' is invalid.
server has encontered a confiuration error.see the report server log files for more information"

Please Help me .

Re: problem with Report Viewer In windows 98

Vikram A Punathambekar16-Jul-07 1:29

Vikram A Punathambekar

16-Jul-07 1:29

What is this built with? VC++? C#? VB? What is Main Report? A component you built? A third party control?

michael@cohen wrote:
"The definition of the report 'Main Report' is invalid.
server has encontered a confiuration error.see the report server log files for more information"

Well, what do the log files say?

Cheers,
Vıkram.

After all is said and done, much is said and little is done.

Re: problem with Report Viewer In windows 98

michael@cohen16-Jul-07 1:37

michael@cohen

16-Jul-07 1:37

the code is c# ,i dont know what is main report...
and i dont know where can i find the log file...

Schedule Auto Update

GermanDM16-Jul-07 1:02

GermanDM

16-Jul-07 1:02

Hi,
Im writing an auto update app in vs2005. I would like
to call an update procedure from a web service automatically
at say 19:00 everyday.
What would be the best way of achieving this?
I dont need any code or anything just wanna know the best easiest or safest way
of doing this and then start googling :P

Thanks

DateTime Problem

Mohammed Elkholy15-Jul-07 23:44

Mohammed Elkholy

15-Jul-07 23:44

Hi

I have problem here

i have a column DateTime in database

i want to insert time only in this column

but after i add the time i find the data in table is date with time

this conflict the data when i rowfilter the dataview by this column

how can i solve it

"comment: this is the code of DataView "

DV_Deatils.RowFilter = "Room_No='" + combo_Rooms.SelectedValue + "' and ExamDate='" + dtp_examdate.Value.ToString("D") + "'"+
" and ExamTime>='" + txt_time.Text + "' and ExamTimeTo<='"+txt_timeto.Text+"'";

MD_NADA

Re: DateTime Problem

Manas Bhardwaj16-Jul-07 0:11

Manas Bhardwaj

16-Jul-07 0:11

md_nada wrote:
but after i add the time i find the data in table is date with time

This is because the fact that SQL doesnt has a datatype called time but DateTime.
What you can do is, in the design mode of your database table set the format as short time( or which ever suitable to you) Rose | [Rose]

Re: DateTime Problem

Colin Angus Mackay16-Jul-07 0:18

Colin Angus Mackay

16-Jul-07 0:18

Manas Bhardwaj wrote:
What you can do is, in the design mode of your database table set the format as short time( or which ever suitable to you)

The database isn't interested in the format of the DateTime. Setting some format only alters the way it is displayed. It will still store something for the date portion.

This means you still have to consider what date you are going to give it so that queries work as expected.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

Ready to Give up - Your help will be much appreciated.

My website

Re: DateTime Problem

Rhys Gravell16-Jul-07 0:12

Rhys Gravell

16-Jul-07 0:12

Assuming this is MS Sql Server, there is no Time datatype, only DateTime. You just need to ignore the Date portion of the DateTime field you're interested in.

Rhys

"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"

They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett

Re: DateTime Problem

Vikram A Punathambekar16-Jul-07 0:30

Vikram A Punathambekar

16-Jul-07 0:30

Simply ignore the date part when you retrieve the value from the database.

Cheers,
Vıkram.

After all is said and done, much is said and little is done.

Re: DateTime Problem

T1TAN16-Jul-07 23:14

T1TAN

16-Jul-07 23:14

Hi,

first of all, I hope you're validating the values of dtp_examdate, txt_time and txt_timeto before filtering your DataView.

There are few things you could try, and I'll be honest, I'm not sure if any of them is good.

1. You can place a hardcoded date value in the database, for example '2007-01-01' will always be the date part of your datetime field. Probably not a good idea, you'd still need to handle insert/update properly (by a trigger perhaps), and parse the time value when selected from the DB. I'd say too much overhead.

2. Perhaps better than 1: store the time value in separate tinyint fields, Hour, Minute, Second. I believe this way you can filter the data easily, you only need to combine the values to display the time properly.

Hope that helps D'Oh! | :doh:

---
http://sprdsoft.cmar-net.org - We Sprd You Softly
Our site features contents and several images. All of this is very weird.

In the end, war is not about who's right, it's about who's left.

Populate a *.sdf database from a dataset

pmartike15-Jul-07 23:25

pmartike

15-Jul-07 23:25

Hi!

In my program i receive a data through TCP socket and i put them into a dataset. How can i insert these values into a .sdf (pocket pc/compact framework) database. Is there a method other than using an INSERT command for every dataset row? Because using INSERT is too slow. Sigh | :sigh:

Thank you!

--------------------------------
visit: http://pmartike.deviantart.com/

Re: Populate a *.sdf database from a dataset

Colin Angus Mackay16-Jul-07 0:15

Colin Angus Mackay

16-Jul-07 0:15

I've found it usually isn't the INSERT that is slow it is the database roundtrips that are slow. If the framework supports it then you should batch a number of INSERTs into one Command and send them together.

Re: Populate a *.sdf database from a dataset

pmartike16-Jul-07 0:44

pmartike

16-Jul-07 0:44

But how can i do this?

--------------------------------
visit: http://pmartike.deviantart.com/

Re: Populate a *.sdf database from a dataset

Mike Dimmick16-Jul-07 0:59

Mike Dimmick

16-Jul-07 0:59

SQL Server CE is in-process so the round-trip problem doesn't apply. The parser only accepts one statement per batch. The parser is appallingly slow and the query execution engine isn't much better. You actually get best performance by simply opening the tables directly (specify the table name for SqlCeCommand.CommandText and set SqlCeCommand.CommandType to CommandType.TableDirect) and not using SQL at all (ironically).

In CF 1.0 you could read tables directly but not update them - you had to use INSERT queries and Prepare the command object to avoid the query compiler overhead. CF 2.0 has a SqlCeResultSet class which is back to the ~~bad~~ good old days of ADO Recordset - you can scroll back and forth with a client-side cursor, seek to specific values, update or delete existing rows and insert new rows.

Stability. What an interesting concept. -- Chris Maunder

Re: Populate a *.sdf database from a dataset

Colin Angus Mackay16-Jul-07 2:29

Colin Angus Mackay

16-Jul-07 2:29

Mike Dimmick wrote:
SQL Server CE is in-process so the round-trip problem doesn't apply. The parser only accepts one statement per batch.

Ah, okay - I've never used it.

Re: Populate a *.sdf database from a dataset

Mike Dimmick16-Jul-07 0:55

Mike Dimmick

16-Jul-07 0:55

For SQL Server 2005 Mobile Edition/SQL Server CE 3.1, with .NET Compact Framework 2.0, you can manipulate the tables directly (as it's an in-process database engine).

Open a SqlCeResultSet directly on the table you want to insert into. Use the CreateRecord method to get a SqlCeUpdatableRecord, which you set the properties of. Then use the resultset's Insert method to update the table. Reportedly, this is much faster than using any SQL INSERT query, even if you Prepare the command object.

In fact SQL Server CE is reportedly much faster if you manipulate tables directly and use the navigation methods on SqlCeResultSet or SqlCeDataReader than using any form of SQL. Only use a SELECT query when you want to do a complicated join.

You can open an updatable resultset directly on a table by doing:

using( SqlCeCommand cmd = new SqlCeCommand( "MyTable", conn ) )
{
   cmd.CommandType = CommandType.TableDirect;
 
   using( SqlCeResultSet rs = 
      cmd.ExecuteResultSet( ResultSetOptions.Updatable ) )
   {
      // code to manipulate the resultset
   }
}

Note that this is unique to SQL Server CE - you cannot open tables directly with the full SQL Server 2000 or 2005.

Stability. What an interesting concept. -- Chris Maunder

Re: Populate a *.sdf database from a dataset

pmartike16-Jul-07 3:08

pmartike

16-Jul-07 3:08

Thank you

I'll try it..

--------------------------------
visit: http://pmartike.deviantart.com/

Re: Populate a *.sdf database from a dataset

Mike Dimmick16-Jul-07 6:04

Mike Dimmick

16-Jul-07 6:04

Knew I'd seen an article on this somewhere:

SQL Compact Edition Insert Performance[^]

Stability. What an interesting concept. -- Chris Maunder

XAML How to get parent property

Juan Pablo G.C.15-Jul-07 23:18

Juan Pablo G.C.

15-Jul-07 23:18

Suppose the next code:

<StackPanel Orientation="Horizontal" Width="120" Height="30">
<Ellipse Fill="#FFBF5757" Stroke="#FF000000" />
</StackPanel>

How do I to make the ellipse the same width of the stackpanel?

<StackPanel Orientation="Horizontal" Width="120" Height="30" <b>x:Name="panel"></b>
<Ellipse Fill="#FFBF5757" Stroke="#FF000000" <b>Width={panel.Width}</b> />
</StackPanel>

I don't know how. Thanks for any help

Juan Pablo G.C.
Overrider Blog

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.