Re: Consume huge excel sheets by WCF Services - WPF Discussion Boards

15-Jun-09 5:01

WPF controls are known as lookless controls. This means that you can edit the individual parts of a control. Take a look here[^] to get some ideas.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Re: WPF listbox scroolbar width

#realJSOP17-Jun-09 5:41

#realJSOP

17-Jun-09 5:41

Pete O'Hanlon wrote:
WPF controls are known as lookless controls.

I think they came up with this description because the designer is crap and nobody uses it.

Smile | :)

"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
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Consume huge excel sheets by WCF Services

Vipul Mehta15-Jun-09 4:26

Vipul Mehta

15-Jun-09 4:26

Hi,

I need to write a WCF service to consume a large excel sheet (having in excess of 70,000 records). Bascially the client (a WPF Desktop application) needs to read the excel spreadsheet in a Data Set and perform validation against a schema. Once validated the client needs to send the data to the WCF service.

The service then needs to insert the data in the database (simple inserts - one excel row becomes a row in the database table).

What options (transport type and bindings) do I have for consuming the "huge" excel files EFFICIENTLY within the WCF Service?

Regards,
Vipul Mehta

Re: Consume huge excel sheets by WCF Services

RugbyLeague15-Jun-09 10:22

RugbyLeague

15-Jun-09 10:22

I use DataStreams

http://www.csvreader.com/[^]

It has to read the whole excel spreadsheet into memory first though but once done it is very simple and fast to read each row and do what you will with it.

Gray focus comes on treeview

Ravi Mori15-Jun-09 3:02

Ravi Mori

15-Jun-09 3:02

hi..
i have two treeviews in my wpf application. and my both treeview contains hierarchical datatemplate.
The Item template has one stack panel in which i have one image and a textblock displaying data..

Now my problem is,
when i select particular node in one treeview and after that when i select select particular node in another treeview then the selected node on first treeview's background become gray..

Any idea?? Sigh | :sigh:

Re: Gray focus comes on treeview

ABitSmart15-Jun-09 3:35

ABitSmart

15-Jun-09 3:35

It becomes gray to indicate it is the SelectedItem of the TreeView but the particular TreeView is not currently in focus.

Re: Gray focus comes on treeview

Ravi Mori15-Jun-09 3:52

Ravi Mori

15-Jun-09 3:52

So is there anyway to remove it or replace gray color with some another color?

Re: Gray focus comes on treeview

ABitSmart15-Jun-09 4:07

ABitSmart

15-Jun-09 4:07

Take a look here[^]

Capture mouse event on slider track [modified]

Christian Graus15-Jun-09 0:19

Re: Capture mouse event on slider track

15-Jun-09 0:19

So, I have a custom slider.   The body of the slider is all buttons, and these are at the top of the Z order.   However, my tracker hangs below the slider, so it has a main tracking area, which is not on top of these buttons, in the sense of z, it's below them, in the sense of y.

This is my template:

                                                <Track.Thumb>
                                                      <Thumb >
                                                            <Thumb.Template>
                                                                  <ControlTemplate>
                                                                        <Grid Margin="0,0,0,0">
                                                                              <Grid.RowDefinitions>
                                                                                    <RowDefinition Height="*" />
                                                                              </Grid.RowDefinitions>
                                                                              <Image Grid.Row="0" Width="30" Margin="-8,0,-8,-25">

Where-ever in this tree I place an event for mouse up, it fires only for the right button, not the left.   How do I catch the left button ? What I am doing is, I have a slider which moves smoothly, but when the user stops scrolling, I want to animate to one of a number of fixed positions.   I am also animating a slide up when the user clicks one of the buttons ( this part works fine ).

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

modified on Monday, June 15, 2009 6:28 AM

Pete O'Hanlon15-Jun-09 0:21

15-Jun-09 0:21

Christian Graus wrote:
This is my template:

<Image Grid.Row="0" Width="30" Margin="-8,0,-8,-25">

And it's invisible, I see.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Re: Capture mouse event on slider track

Christian Graus15-Jun-09 0:30

Re: Capture mouse event on slider track

15-Jun-09 0:30

Just spotted it. I hate when people do that....

Pete O'Hanlon15-Jun-09 1:33

15-Jun-09 1:33

Have you tried handling the PreviewMouseButtonUp event instead?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

BitmapImage Constructor Overloads

#realJSOP15-Jun-09 0:11

#realJSOP

15-Jun-09 0:11

I'm observing some pretty bizarre behavior here. When I do this, it's okay:

BitmapImage img = new BitmapImage(new Uri(System.IO.Path.Combine(this.ImagePath, this.Images[0]), UriKind.Absolute));

However, when I change it to one of these two, the available constructor overloads CHANGE and the one I was using is no longer acceptable by the compiler:

// this doesn't work
string nextFileName = System.IO.Path.Combine(ImagePath, Images[index]);
BitmapImage img = new BitmapImage(new Uri(nextFileName), UriKind.Absolute);

// this doesn't work either
Uri imageUri = new Uri(System.IO.Path.Combine(ImagePath, Images[index]);
BitmapImage img = new BitmapImage(imageUri, UriKind.Absolute);

Why is this?

Christian Graus15-Jun-09 0:16

15-Jun-09 0:16

If you replace index with 0, does it work ? Because I see that as an obvious difference in your code ? What if you make sure index is zero ?

Pete O'Hanlon15-Jun-09 0:19

15-Jun-09 0:19

The problem's with the way he declares the Uri.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Christian Graus15-Jun-09 0:45

15-Jun-09 0:45

Ah - of course. It's late, and I'm going cross eyed. I looked for an obvious difference, although I didn't see how that would just not work, instead of giving an error.

Pete O'Hanlon15-Jun-09 0:16

15-Jun-09 0:16

It's different because you assign the Uri in your first version with UriKind.Absolute as one of the parameters. In other words, it's a parameter of the Uri, not the BitmapImage. Here's an example of the second version:

string nextFileName = System.IO.Path.Combine(ImagePath, Images[index]);
BitmapImage img = new BitmapImage(new Uri(nextFileName, UriKind.Absolute));

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Silverlight 3, WPF will be thrown away then??

#realJSOP15-Jun-09 1:04

#realJSOP

15-Jun-09 1:04

GAk! You're right! Blush | :O

(my face is red)

Seraph_summer15-Jun-09 0:03

Seraph_summer

15-Jun-09 0:03

I read the following from one news:http://infoworld.com/print/79216

Silverlight 3 applications can run in or out of the browser, online or offline.

If so, WPF will be thrown away? It seems not, but if Silverlight 3 can be run in or out of the browser,
why WPF will be chosen?

thanks

Cross post. Please ignore.

Pete O'Hanlon15-Jun-09 0:13

15-Jun-09 0:13

Already answered in the C# forum.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.