Re: Moving Data from Silverlight to ASp.net via SQl server - WPF Discussion Boards

Re: Moving Data from Silverlight to ASp.net via SQl server

9-Jun-11 9:20

Good Evening All

I want to create a unique value for my User in Silverlight and access this value on the asp.net page that is part of the silverlight website. So i cant use cookies because they wont work and i cant do the client site cookie thing because it does not work for my design, its complicated.

This is my current implementation, i created a temp table that i store a value on t he SQL and retrieve it on the SQL immediately, because the created or the value and the access of the value happens between 1 nanosecond. so i don't want to depend on that because on a multi user system that will be a problem.

So basically i need to store any unique value that i can retrieve from the database even in a multi user environment.

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Mark Salsbery9-Jun-11 10:33

Mark Salsbery

9-Jun-11 10:33

What about a GUID (uniqueidentifier in SQL server)?

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

Re: Moving Data from Silverlight to ASp.net via SQl server

Vimalsoft(Pty) Ltd9-Jun-11 19:06

Re: Moving Data from Silverlight to ASp.net via SQl server

9-Jun-11 19:06

The main problem here is that the aspx page that i want to interact with is not the one that host the silverlight plugin, so in my project i have my xaml project and when that gets compile you know it will create a xap file that will be used by the hosting aspx page. but ow the page i want to interact with its not the same page that host it, i would have used the InitParam's. So the catch is that if i create a GUID on the SIlverlight and store it in the Db , how will asp.net select the correct GUID in a multiuser environment.

Thanks

Mark Salsbery9-Jun-11 19:10

Mark Salsbery

9-Jun-11 19:10

Silverlight code runs on the client and ASP.NET code runs on the server....so do you really need Silverlight to interact with the page HTML on the client? Sounds more like you need sessions and/or a way to communicate between Silverlight and the server code - a simple web service, WCF, or whatever.

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

Re: Moving Data from Silverlight to ASp.net via SQl server

Vimalsoft(Pty) Ltd9-Jun-11 19:14

Re: Moving Data from Silverlight to ASp.net via SQl server

9-Jun-11 19:14

i have exhausted the javascript solutions or client side solution, i have never thought of carrying the session in a webservice. can you please elaborate on what you mean some post a link that shows what you are suggesting?

thanks

Mark Salsbery10-Jun-11 6:10

Mark Salsbery

10-Jun-11 6:10

If you search on "Silverlight ASP.NET Sessions" you'll find info, for example here's one article:

Access Sessions from Silverlight and ASP.NET[^]

Not sure how you're going to get at the page in the embedded telerik control....you should consult the TElerik documentation for that.

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

Re: Moving Data from Silverlight to ASp.net via SQl server

Mycroft Holmes9-Jun-11 14:15

Mycroft Holmes

9-Jun-11 14:15

Does ASPX have access to SL protected data storage on the client(I have no idea)?

When you start your SL app pass in a guid from the ASPX shell app and use that in SQL servers temp table. Bloody horrible solution.

I'm passing report criteria from an SL app to a popup via the url, maybe a work around there, maybe a hidden window using the options!

private void DoReport(object sender, RoutedEventArgs e)
{

    string sRepName = (sender as Button).Tag.ToString();
    string sRepCrit = string.Empty;
    switch (sRepName)
    {
        case "lineset":
            sRepCrit = VM.SelectedRoom.RoomID.ToString();
            break;
        case "equipmentlist":
            sRepCrit = GetCriteriaEQ();
            break;
    }

    string sURL =  VM.GetReportsAddress( sRepName, sRepCrit);
    HtmlPopupWindowOptions options = new HtmlPopupWindowOptions();

    options.Left = 0;
    options.Top = 0;
    options.Width = 810;
    options.Height = 600;

    if (true == HtmlPage.IsPopupWindowAllowed)
        HtmlPage.PopupWindow(new Uri(sURL), "new", options);
}

Never underestimate the power of human stupidity
RAH

Re: Moving Data from Silverlight to ASp.net via SQl server

Vimalsoft(Pty) Ltd9-Jun-11 19:11

WPF Code Creation of input Binding

9-Jun-11 19:11

hi Mycroft

You see my problem here is that i have an Silverlight Child Window that is hosting a htmlContainer(Telerik) it is like an iframe object , so this html container is hosting an aspx page, and when that childwindow loads , i store the value to the database and immediately, when the htmlcontainer loaded event gets fired, i have a constructor on the aspx page, that immediately gets the values from the db. This happens so fast that the possibility of a conflict in a multi user environment is less, but i don't trust the approach , i want to retrieve the value and know who's value is for.

thanks

Ed Hill _5_9-Jun-11 0:32

Re: WPF Code Creation of input Binding

9-Jun-11 0:32

I would like to know how to implement the following xaml in code, specifically the input binding to a command.

<Controls:TextBox Text="{Binding Path=SearchText, UpdateSourceTrigger=PropertyChanged}">
    <Controls:TextBox.InputBindings>
        <KeyBinding Key="Return" Command="{Binding Path=SearchCommand}"/>
    </Controls:TextBox.InputBindings>
</Controls:TextBox>

The reason for the question is i am looking to inherit from some of the default windows controls, and have some standard behaviour for my inherited control. I wish for the return and escape keys to execute a commands in my ViewModel which will be the DataContext for the Inherited Control. The return key would trigger a search to be performed, and the escape key would clear the control to its default value, any help would be greatly appreciated.

SledgeHammer019-Jun-11 6:49

SledgeHammer01

9-Jun-11 6:49

Sounds like the perfect use for attached behaviors! Big Grin | :-D

Re: WPF Code Creation of input Binding

Ed Hill _5_9-Jun-11 22:17

Re: WPF Code Creation of input Binding

9-Jun-11 22:17

The following appears to impelemtn what you suggested, to be honest i'm not sure that i understand the need/benifit to use an attached behaviour insted of inheriting from a control.

public static class LookupBehaviour
{
    public static Boolean? GetEscapeToClear(ComboBox comboBox)
    {
        return (Boolean?) comboBox.GetValue(EscapeToClearProperty);
    }
    public static void SetEscapeToClear(ComboBox comboBox, Boolean? value)
    {
        comboBox.SetValue(EscapeToClearProperty, value);
    }

    public static readonly DependencyProperty EscapeToClearProperty = DependencyProperty.Register("EascapeToClear",
                                                                                                  typeof (Boolean?),
                                                                                                  typeof (LookupBehaviour),
                                                                                                  new UIPropertyMetadata(null, OnEscapeToCearChanged));

    private static void OnEscapeToCearChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
    {
        if (!(d is ComboBox)) return;
        var cmb = d as ComboBox;
        if ((e.NewValue is Boolean?) && (e.NewValue as Boolean?).HasValue)
        {
            var escapeBindingCommand = new KeyBinding(ApplicationCommands.NotACommand, new KeyGesture(Key.Escape));
            var escapeBidning = new Binding("EscapeCommand");
            BindingOperations.SetBinding(escapeBindingCommand, InputBinding.CommandProperty, escapeBidning);
            cmb.InputBindings.Add(escapeBindingCommand);
        }
    }
}

One thing that i didn't like was when creating the key binding that you have to specify a tempory command, ApplicationCommands.NotACommand, and then bind over the top of it, if there is any way to avoid that please let me know. Thanks for the origional reply.

SledgeHammer0110-Jun-11 5:05

SledgeHammer01

10-Jun-11 5:05

From your original post, it sounded like you wanted to add the same exact functionality to several different controls. If that was/is the case, then think about it: Its easier to write ONE attached behavior vs a bunch of MyComboBox, a MyButton, a MyCheckBox, etc controls and C&P the code.

The behavior you wrote is hard coded to the ComboBox, but it doesn't have to be hard coded to any specific control type, it can be much more generic. Then you can simply attach it to any control you like. Think of something like a tooltip control. By using attached behaviors, you could attach the tooltip to any control you like.

In addition, attached behaviors allow you to modify a controls' behavior without re-templating an entire parent control just to change an embedded control type. I.e. say you had a data grid and wanted to change the behavior on a ComboBox deep down in the visual tree. You'd have to re-template the entire data grid just to change a <ComboBox /> to a <MyComboBox />.

In regards to your last question, there is no need to create a temporary command and use InputBindings. Just subscribe to the KeyDown message and trap the ESC key.

textbox value

arkiboys8-Jun-11 1:36

arkiboys

8-Jun-11 1:36

In my wpf application, there is a listbox a several textboxes.
On clicking an item in the listbox, the textboxes are populated accordingly.
Do you know why the following happens?
select an item in the listbox.
textboxes are populated with other fields for the selected item. Let's say textbox1 has an empty value.
Type "hello" in the textbox.
select another item from the listbox.
Now in the listbox, select the original item you selected. the textbox has the value "hello".
If application is closed and re-opened then obviously the word "hello" is not there.
Do you see why the value is retained eventhough the data is not saved into the database?
Thanks

Pete O'Hanlon8-Jun-11 1:45

8-Jun-11 1:45

It sounds like you have an underlying data item that you are updating in the view model using two way binding. I can't quite decide from your description what your architecture is, but I do think that you aren't raising a change notification when you should be. If you remember, as we've discussed many, many times, WPF uses the INotifyChanged.PropertyChangedEventHandler to manage the update of bound items, so your code must call the PropertyChangedEventHandler at the appropriate point (and you should tell it which property has changed).

Make sure that the class in the DataContext implements INotifyChanged, and then call the event handler as appropriate. Without seeing any of your code, this is pure guesswork and speculation.

Forgive your enemies - it messes with their heads

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

arkiboys8-Jun-11 2:04

arkiboys

8-Jun-11 2:04

Yes, I think I understand or may be not...
May be I did not explain properly the issue.
I have read your comment several times but I still do not see the solution.
To re-cap:
listbox is populated by fullnames from the database.
on selection of each fullname the textboxes are populated i.e. txtaddress, etc...
If a value is changed in the textbox and submit is pressed then the data gets saved into the database BUT if the save button is not clicked and only you click on another fullname, then when you go back to the first fullname, then the textbox value you entered (which you did not save) will be present.
Surely, the value of the textbox should be as same as what is in the database, right?
Thanks

Pete O'Hanlon8-Jun-11 2:09

8-Jun-11 2:09

arkiboys wrote:
Surely, the value of the textbox should be as same as what is in the database,
right?

Not if you've updated it with 2 way binding.

Forgive your enemies - it messes with their heads

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

arkiboys8-Jun-11 2:26

arkiboys

8-Jun-11 2:26

I think I figured it out because although I have not placed any mode in textbox xaml, by default it is using twoway mode.
Thanks for pointing that out.

Sparkling_ouc8-Jun-11 22:16

Sparkling_ouc

8-Jun-11 22:16

Common property(Not dependency property) will not be bound with the "TwoWay" Mode(Actually, only special dependency property would, when register dependency property there is an option ).If you want bind it "TwoWay",please implement the interface INotifyPropertyChanged in you "Model" Layer.

Pete O'Hanlon8-Jun-11 2:25

8-Jun-11 2:25

You may need to take a look at IEditableObject and IEditableCollectionView. If you'd like to read the blog and download the code sample here[^], you'll get some idea as to how the transaction support in WPF can help you.

Forgive your enemies - it messes with their heads

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

Ed Hill _5_9-Jun-11 0:44

9-Jun-11 0:44

To me this sounds like the correct behaviour, by changing the text you have changed the property in your data context, and although you have not commited this to the database you are not refreshing the data from the database when re selecting the item. If you wish for any changed to be undone if you do not press the save button you may wish to consider calling

ObjectContext.Refresh(RefreshMode.StoreWins, WhatToRefresh);

The WhatToRefresh could be ObjectContext.NamesSourceTable, or to be more graceful you could just pass the previously slected item, i would guess that you call this when you change the slected item on the list. If you need a more full solution post a you code and i'll try to edit it for you.

Pete O'Hanlon9-Jun-11 0:48

9-Jun-11 0:48

Why have you posted this to me? The OP doesn't get notified on replies to other people's comments, and I am more than fully aware of how binding works in WPF/SL.

Forgive your enemies - it messes with their heads

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

Ed Hill _5_9-Jun-11 0:50

9-Jun-11 0:50

clicked the wrong reply link by mistake i guess, was simply trying to offer a solution to the OP.

Pete O'Hanlon9-Jun-11 1:04

9-Jun-11 1:04

No problems. Simply add a reply to one of his posts and link to the answer you gave there.

Forgive your enemies - it messes with their heads

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

Ed Hill _5_9-Jun-11 5:59