C# Discussion Boards - CodeProject

Re: Populate a *.sdf database from a dataset

Colin Angus Mackay16-Jul-07 2:29

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.

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: 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

Re: XAML How to get parent property

snorkie16-Jul-07 3:10

snorkie

16-Jul-07 3:10

If Ellipse is always supposed to be the same width as the StackPanel, get a handle on the Elipse node and use node.Parent to get at StackPanel.

Hogan

java script

kalyan_241615-Jul-07 23:08

kalyan_2416

15-Jul-07 23:08

hi all
i just want to know
if i want a similar kind of calendar tool as asp.net has (in java script)
what should i do for that calendar ... few validations have to be done...
i saw in net what i found was tools are available saying calendar.js..
is tat only way or so ..
i found even ajax tool kit also...
but i am struggling ot add up to my project
if someone has got articles please do help me ...

Re: java script

Nouman Bhatti15-Jul-07 23:20

Nouman Bhatti

15-Jul-07 23:20

for ajax controls see this
http://www.asp.net/

Custom stored procedure in netTiers

thuannguyen15-Jul-07 22:15

thuannguyen

15-Jul-07 22:15

Hi Guys,

i am using codeSmith to develope website and have a problem:
I know that all the stored are generated automatic when using netTiers to generate. but i have a function search user stored like this:
Alter Procedure SearchUser
@searchKey varchar(500)
As
select u.*
from users u
where u.userID in
(
select fmem.userID
from dbo.FamilyMembers fmem
where fmem.famID in
(
select f.famID
from dbo.Families f
where f.famName like '%'+@searchKey+'%'
)
)
GO
Please help me how to assgin UserService execute this store without re-generate source code

Thuan

Re: Custom stored procedure in netTiers

Vasudevan Deepak Kumar15-Jul-07 22:39

Vasudevan Deepak Kumar

15-Jul-07 22:39

Weren't there any vendor KBs on this issue?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

how to set the number of rows in listview in c#

monuSaini15-Jul-07 22:10

monuSaini

15-Jul-07 22:10

Hello EveryBody,

I am new in windows application,

I am not able to set the number of rows in listview.

I want to display only ten records at time.

Regards,

rahul saini

Re: how to set the number of rows in listview in c#

Eduard Keilholz15-Jul-07 22:48

Eduard Keilholz

15-Jul-07 22:48

You need to do list yourself... There's no paging-like functionality in a listview....

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: how to set the number of rows in listview in c#

mav.northwind16-Jul-07 3:34

mav.northwind

16-Jul-07 3:34

Hi!

The number of rows in a ListView depends on the value of its VirtualMode property.

If you don't run the ListView in virtual mode (the default) then the number of rows is equal to the number of ListViewItems inside the Items collection.

If you're running in virtual mode, there's a special property VirtualListSize to hold the number of items in the ListView. Using the ListView in virtual mode is an advanced topic, though.

Regards,
mav

--
Black holes are the places where God divided by 0...

Accessing the program folder

AlexZieg7115-Jul-07 22:01

AlexZieg71

15-Jul-07 22:01

Hi,

my application has an update feature: after the user clicks an update-button, my program checks wheather there is a newer version on the server. If yes, it is downloaded with a temporary filename into the program-folder. Then a separate update-exe is started, which replaces the old program.exe with the newer one by deleting the old and renaming the new file.

The problem is, that in Vista (but also in older systems) the write access to the program-folder is restricted.

Do you have an idea how I could work around this restriction or what I could do to keep this fast update feature available to my customers? E.g. my ZoneAlarm also has such an update-feature although I don´t know how this works...

Thanks in advance
Alex

Re: Accessing the program folder

Vasudevan Deepak Kumar15-Jul-07 22:41

Vasudevan Deepak Kumar

15-Jul-07 22:41

Would BITS API help you?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Accessing the program folder

AlexZieg7115-Jul-07 23:22

AlexZieg71

15-Jul-07 23:22

Thanks for that hint! This seems to be very interesting...

Re: Accessing the program folder

AlexZieg7116-Jul-07 0:09

AlexZieg71

16-Jul-07 0:09

OK, now I´ve read the article http://msdn.microsoft.com/msdnmag/issues/03/02/bits/ about that, but as far as I understand, the problem I mentioned is not explicitely addressed there. One thing is the download-process done by the BITS API, but another thing is how to replace the application-files, but in that article it is presumed that files can be renamed/deleted inside the program folder.

Do you agree with that? Then I have the same problem as before, that under Vista I will not be able to manipulate the files in the program directory. Or can I?

Re: Accessing the program folder

mav.northwind16-Jul-07 10:04

mav.northwind

16-Jul-07 10:04

Hi!
If you try to modify files in the program directory, all changes will be virtualized to a directory in the user profile.
This does not happen if your program is running with elevated rights. You can achieve this by embedding a manifest into the application telling Vista that your updater application requires elevated rights to perform correctly.

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: Accessing the program folder

AlexZieg7116-Jul-07 10:09

AlexZieg71

16-Jul-07 10:09

Thank you! But what is a manifest? How does it look like? I could not find anything specific about that thing...

Re: Accessing the program folder

mav.northwind16-Jul-07 19:10

mav.northwind

16-Jul-07 19:10

How to embed a manifest can be found here[^], the contents of the manifest file can be easily found here using google[^].

Regards,
mav

--
Black holes are the places where God divided by 0...

Get CPU,Memory & Disk utilization

kaushal65415-Jul-07 21:50

kaushal654

15-Jul-07 21:50

I want to ger CPU,Memory & Disk utilization of Windows machine using C# application.
If you have any idea about that pls reply me via email.

email : kaushal654@yahoo.com

Re: Get CPU,Memory & Disk utilization

Malcolm Smart15-Jul-07 22:06

Malcolm Smart

15-Jul-07 22:06

Hi
Read up on System.Diagnostics.PerformanceCounter .

For a general question like this it is best to google first [^]. Generally, people post specific problems here.

Just curious - do you find you get a lot of spam?

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

Assigning DataView to DataTable

meeram39515-Jul-07 21:46

meeram395

15-Jul-07 21:46

Hi,

I have a dataview called 'dvUniv' which contains the sorted data. I want to reassign this sorted data to another DataTable, say dt1. Is it possible to do that? If so, how is it done? Any help in this regard is great.

Thanks,

Meeram395

Re: Assigning DataView to DataTable

andreumv15-Jul-07 22:35

andreumv

15-Jul-07 22:35

DataTable dt1 = dvUniv.ToTable();

Re: Assigning DataView to DataTable

meeram39515-Jul-07 22:51

meeram395

15-Jul-07 22:51

Hi,

Thanks for your reply. But there is no function called DataView.ToTable(). I'm using .Net Version 1.1. Is there any other way?

Thanks

Meeram395

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