You are here:   Forum
Register   |  Login

 

Forum Notice

This Forum is ARCHIVE only
For LightSwitch questions,
please use the official forums at:

http://social.msdn.microsoft.com/forums/en-US/lightswitch/threads


Forums

Need to filter database content for user on login
Last Post 21 May 2012 06:10 AM by admin. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
olisherr424User is Offline
New Member
New Member
Send Private Message
Posts:1
Avatar

--
21 May 2012 05:51 AM

    Hello, 

    Basically.. I am wanting a way to:

    When a user logs in, automatically his company (a field in the database) is found and only people from the same company are shown to that user.

    Example of what i am looking for.. "if a users companyID is 'Wizards', i want data on the database to be filtered automatically so that he can only see people with a companyID =="

    Please any help with this would be much appreciated. Also please not i am doing this using C# and Forms Authentication.

    Thanks
    Oli  

    Michael WashingtonUser is Offline
    Send Private Message
    Posts:1251
    Avatar

    --
    21 May 2012 06:10 AM
    -----------
    Michael Washington
    http://LightSwitchHelpWebsite.com
    You are not authorized to post a reply.


    Latest Microsoft Visual Studio LightSwitch Forum Threads That Have Answers

    Hey, I'm building a LightSwitch 2013 HTML application. when i'm adding an html element to the DOM after timeout, it doesn't get all lightswitch classes that should be added if there wasn't a timout. For example: settimeout(function( $ul = $("<ul></ul>"); $ul.attr("data-role", "listview"); $ul.attr("data-filter", "true"); $(element).append($ul); ),100); The ul will not get all the classes that lightswitch would give if there was no timeout. Any ideas? Thanks.
    Read more...

    I have yet to get Lightswitch 2015 to work in Visual Studio 2015, either community or enterprise. I continue to get an error that the lsxtproj type is not supported when I try to create a new project??  Any suggestions?? mike mike d
    Read more...

    I am in a SQL queries class and I am thinking about how all of the parts of LightSwitch work. I like that we are doing all of these queries in code using SQL Management Studion and setting up exports to excel so I see how to manually edit them. I was wondering how to add them to a client solution manually. We Use queries in LightSwitch to create screens and filters and have buttons that export to excel. As well I use as excels ability to use Power Pivot to directly load data from a database based on what the pivot table does. Can view the queries in code if I dig into the text files built using the Visual Studio IDE and the GUI provided by LightSwitch. I need to learn how to manually place these lines of code within classes in a project solution so I can start work on making the same queries embedded in WPF. LightSwitch embeds them in solution parts for Silverlight I assume. I guess I just want to learn the basics of how to embed SQL statements and
    Read more...

    I have some code that runs under _Inserting on the Jobs table on the server. I also have a System table with a single record and a property of the LastCode (Last JobCode used in a record). DataWorkspace dw = this.Application.CreateDataWorkspace(); Job result = (from j in dw.Data.Jobs.OrderByDescending(Job => Job.JobCode) select j).FirstOrDefault(); System system = dw.Data.System.FirstOrDefault(); Int32 LastCode = int.Parse(result.JobCode); Int32 NewLastCode = LastCode + 1; system.LastCode = NewLastCode.ToString(); dw.Data.SaveChanges(); Which was created out of this post. If I place it in the _Inserted table it fails locally and when published, however running from _Inserting in debug mode locally on the machine works perfectly fine. When I publish this to Azure (V11 DB currently) everything else seems to work however when I try and add a Job I get "Object reference not set to
    Read more...

    Hello, I have a SQL table called 'DeviceType'. I have an 'AddEditDeviceType' screen that is shown in dialogue. There are required properties in this table, 'IntDeviceTypeID' is one of them, and it is the PK (primary key). SQL is set to auto-increment the next row when a new row is completed, but it does not create a new key until the current row has all of its required properties. The last PK in my table has a value of 473. If I enter '474' in the 'IntDeviceTypeID' property on the AddEditDeviceType screen, the new row saves in SQL and all is good. However, I will have no way for users to determine which PK value is up next. Is it possible to a screen, perhaps oncreate(?), to always enter the next value, from a starting value, like 474? I navigate to the 'AddEditDeviceType' screen via a button on the 'AddEditDevice' screen. Could I, in that Buttons execute method, write something like this? Any advice is much appreciated. Thank you in advance.
    Read more...

    1234
    Microsoft Visual Studio is a registered trademark of Microsoft Corporation / LightSwitch is a registered trademark of Microsoft Corporation