Hi,
I'm not sure where to post my question, i think it should be posted here.
 In Visual Webdeveloper, ive made a webapplication for displaying orders from an access database and ive replaced the original SQL server with an Access database, since our company had another SQL server. Ive done this according to Imars excellent article (http://www.spaanjaars.com/QuickDocId.aspx?quickdoc=404). Plus I got another Access database from which orders can be made. I can update orders (using the gridview + update statement).
I can retrieve wich user is logged in
code: Protected Sub Page_Load(ByVal sender As Object, _
         ByVal e As System.EventArgs) Handles Me.Load

        Dim result As String = _
                "Hello {0}. Member of Admin role: {1}"

        Label1.Text = String.Format(result, _
                User.Identity.Name, User.IsInRole("Administrators"))
    End Sub

Everything is working as it should be, but my question is: We dont want company A to see what orders company B has made. I've tried to add an SQL query to the datasource (e.g. select company where session = ??). I really dont have a clue where to start and all my searches on Google, forums came out empty. Ive started .NET web development 3 weeks ago.
Programs used:
- Visual Web Developer Express
- Visual C# Express
- Microsoft Access (2 databases, 1 holding user information, 1 holding the orders)

I apologize if I made a doublepost.
Cheers

no one knows or at least knows where i made a mistake? Or did i post my question in the wrong forum?

well.. you are in the right forum.. but I think you are asking for an architectural problem rather than a programming one...

Since you have 2 companies and already know who is loggin in, the easy thing to do is add a column to the orders tables that handles the company info and add this column to every sql you do to that table...

this may be not the best solution.. but at least is an easy one...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

I've tried that before, i could see what user is logged in.
As you can see in my first post, i configured a label for holding and retrieving the user info. But with a sql directly pointing to that label, it didnt seem to work.
I just found out there was a [space] which didnt suppose to be there. Removing the space and my personilized page works!
Thanx to gbianchi for replying :)

greets