Re: How to pass Sql Query as a parameter in Silverlight - WPF Discussion Boards

Re: New WPF Themes on Codeplex

30-Mar-09 0:02

Did you see this Codeplex[^] ?

RugbyLeague30-Mar-09 0:30

RugbyLeague

30-Mar-09 0:30

I did and came to the conclusion that I will get round to using themes when they are ready for non trivial apps.

Thanks.

How to pass Sql Query as a parameter in Silverlight

mohammed irfan jeddah29-Mar-09 2:51

mohammed irfan jeddah

29-Mar-09 2:51

I Have a requirement where i need to pass only sql select statement as a parameter to Service. Instead of writing query in the service i need to accept the query as a parameter.

Any suggestions, samples or links would be appreciated.

Thanks

Re: How to pass Sql Query as a parameter in Silverlight

Mark Salsbery30-Mar-09 6:07

Mark Salsbery

30-Mar-09 6:07

You can't pass it as a string?

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: How to pass Sql Query as a parameter in Silverlight

Braulio Dez1-Apr-09 5:54

Braulio Dez

1-Apr-09 5:54

Well an string would work but... that could be quite dangerous, it's quite easy to make injection attacks with that technique.

I would limit that free querying to the final user.

HTH
Braulio

/// -------------------------
     Braulio Díez

     DBSchemaEditor.com
     Free Silverlight based DB Schema Modeling Tool
/// -------------------------

ItemsPresenter !

Mohammad Dayyan29-Mar-09 2:26

29-Mar-09 2:26

Hi.

What is ItemsPresenter ?
I've already read http://msdn.microsoft.com/en-us/library/system.windows.controls.itemspresenter.aspx[^], but it is too simple !

Would you explain it a little more ?
Thank you.

ABitSmart29-Mar-09 4:14

29-Mar-09 4:14

From the MSDN link,
"Used within the template of an item control to specify the place in the control’s visual tree where the ItemsPanel defined by the ItemsControl is to be added."
(stress on the underlined words)

One way to look at it is, it gives you a starting point to start looking out for your Items in the Visual tree. You know, they surely will be in the ItemsPresenter (i.e. if you follow the use of ItemsPresenter in your ControlTemplates)

Mohammad Dayyan29-Mar-09 4:21

29-Mar-09 4:21

So we ought to use ItemsPresenter just in a visual tree !
Sorry if I couldn't realize it well Blush | :O

ABitSmart29-Mar-09 4:26

29-Mar-09 4:26

It's one of the ways I see it. It would come handy if you need to parse the visual tree. With DataTemplating and the styling flexibility of WPF traversing the tree might turn daunting, but ItemsPresenter might rescue you.

Mohammad Dayyan29-Mar-09 4:54

29-Mar-09 4:54

Thank you ABitSmart.
As far as I know , we should use ItemsPresenter in DataTemplating !
Isn't it ?

ABitSmart29-Mar-09 5:07

29-Mar-09 5:07

ItemsPresenter is more of ControlTemplate thingy. Now, if I have confused you more, read here Link[^]

See this also Link[^]

Mohammad Dayyan29-Mar-09 5:11

29-Mar-09 5:11

Thank you for the responses Thumbs Up | :thumbsup:

ABitSmart29-Mar-09 5:13

Minimizing a WPF window ?

29-Mar-09 5:13

Have fun

Mohammad Dayyan28-Mar-09 4:55

Re: Minimizing a WPF window ?

28-Mar-09 4:55

Hello guys.

How can we minimize a WPF window with C# ?

Thank you

ABitSmart28-Mar-09 5:20

Re: Minimizing a WPF window ?

28-Mar-09 5:20

Like this,

this.WindowState = WindowState.Minimized;

where this is my Window object.

Mohammad Dayyan28-Mar-09 6:02

Re: Minimizing a WPF window ?

28-Mar-09 6:02

Thank you ABitSmart

ABitSmart28-Mar-09 6:03

WPF application with listview hangs and threads keep increasing

28-Mar-09 6:03

Appreciate the reply. Glad to be of help.

Pankaj Chamria27-Mar-09 21:02

Pankaj Chamria

27-Mar-09 21:02

Hi,
There is a weird problem for which I will have to do some explanation on background.

I am working on a WPF client application which has about 3-4 usercontrols loaded, each having a listview displaying records using a observable collection. This observable collection is a collection of class instances that follow the INotifyPropertyChanged model. Upon each change in the collection the change reflects onto the listview column. Updates to existing rows in the collection keep streming in from the server using WCF TCP/IP at about 100-200 updates per second.

The issue is that once in a while the UI just freezes and then the no of threads attached to the process (seen in the task manager) keep on increasing exponentially.. I have no clue why this happens.. when i debug the updates are still coming in and observable collection is still getting updated.. but the UI hangs.. This does not happen always or on a particular action.

I am using Dispatcher.BeginInvoke when adding items to the listview but not when updating the properies of instances within the collection as observable collection automatically takes care of such updates. I am also using Virtualization in listview which is anyways enabled by default.

Any clues what could be causing this..

Pankaj Chamria,
Software Programmer.

Re: WPF application with listview hangs and threads keep increasing

ABitSmart28-Mar-09 1:13

Re: WPF application with listview hangs and threads keep increasing

28-Mar-09 1:13

Suggestions,
- The only thing striking from your description is, your object implements INotifyPropertyChanged. ObservableCollection inherently implement the change notification. You might want to try disabling the property change mechanism of the objects and just rely on the ObservableCollection.
- What DispatcherPriority do you set for BeginInvoke ? Did you try setting it to a lower priority e.g. Background ?
- Don't update the main Observable collection. Work on a different one and periodically replace the main one with the updated one. I don't feel good about this one though :>

Pankaj Chamria3-Apr-09 6:03

Pankaj Chamria

3-Apr-09 6:03

Thanks for your reply.

I am using two collections. Collection A is a list of objects which implement INotifyPropertyChanged. It gets updated continuosly using a worker thread. Collection B is my observable collection hosted in the UI thread, which observes on Collection A elements. I used Normal priority. Using Background too causes this issue, although it occurs less frequently.

The issue seems to be with the wpf framework, although i am not sure. I found the solution to my problem on the following thread, which makes for a good reading.
http://social.expression.microsoft.com/Forums/en-US/wpf/thread/e55530dc-a358-4c6b-81b6-25a11c173a22/[^]

Now i let the background thread do the updations as fast as it wants to without raising the property changed events at that time, but i raise all the property changed events for all objects in collection from the UI thread on every 100 frames using the CompositionTarget.Rendering event. Now the hang problem is thankfully put to rest!

PS: You mentioned that even without raising the property changed events, my listview should get updated as I am using the observable collection. But I tested it out. It does not work without raising the PropertyChanged event, for my design of using 2 collections.

Pankaj Chamria,
Software Programmer.

Re: WPF application with listview hangs and threads keep increasing

ABitSmart3-Apr-09 6:31