Re: asp.net connection to sql server?

It is a good idea to separate the connectionstring from the program code by
putting it into a config file, yes. Then, your program can extract the
info. from that file as needed. I haven't used the login control, but I'm
sure you can add code to the page_load event handler to programmatically set
this up.

Good luck.


"J" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:OyISMRAPHHA.4244@xxxxxxxxxxxxxxxxxxxxxxx
So would one make this adjustment in the web.config file? Also would this
still be able to use and work with dragging and dropping the Login control
objects onto the web form?

Thanks a bunch Scott for your info and quick reply. I appreciate it.

J

"Scott M." <s-mar@xxxxxxxxxxxxx> wrote in message
news:eaJLNo$OHHA.3872@xxxxxxxxxxxxxxxxxxxxxxx
http://www.connectionstrings.com/?carrier=sqlserver





"J" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:u%23n0hO$OHHA.4372@xxxxxxxxxxxxxxxxxxxxxxx
Hello. Sorry if this is a novice question but can anyone show or point
me to some code in having windows authentication to sql server for an
asp.net application where it's not using just one generic windows
account? I need to assign individual windows logins to our users (basic
authentication in conjunction with https since not everyone is on the
same domain). I notice in pretty much all the examples/samples I see on
the net they have the asp.net apps use 1 generic or surrogate windows
connection to sql server that's on the same domain but how does one
configure the asp.net app to allow individual windows authentication for
users to access the asp.net app from anywhere on the web? The reason
I'm asking is because I need to use SQL Profiler in seeing who did what
to the data at what time, etc...

Thanks in advance.

J







.

Relevant Pages

  • Re: App.config question. Me is stuck good :-(
    ... Windows Forms App and the other three class librarires. ... class libraries will be loaded into this process. ... > require access to a config file. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: App.config question. Me is stuck good :-(
    ... Windows Forms App and the other three class librarires. ... class libraries will be loaded into this process. ... > require access to a config file. ...
    (microsoft.public.dotnet.general)
  • Re: asp.net connection to sql server?
    ... by putting it into a config file, ... Thanks a bunch Scott for your info and quick reply. ... asp.net application where it's not using just one generic windows ... authentication for users to access the asp.net app from anywhere on the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Impersonation in ASP.NET 2.0 (works from XP, not 2003)
    ... We need to access remote fileshares from our app, ... it is required on Windows XP for the app to function ... having this line in the config file gives an ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows.. its like coming home!
    ... gradual transition, especially in going from OS 9 to OS X. ... They needed something that could compete with Windows, ... mean by the "2 of every app" comment before - Apple took whatever apps ... I've found that because the Dock shows applications rather than windows, ...
    (comp.sys.mac.advocacy)