+ Post New Thread
Results 1 to 5 of 5
Coding Thread, C#/SQL 2005 question in Coding and Web Development; Ok looking for info on how to go about storing the connection to a SQL 2005 server in an XML ...
  1. #1

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,724
    Thank Post
    867
    Thanked 666 Times in 438 Posts
    Rep Power
    501

    C#/SQL 2005 question

    Ok looking for info on how to go about storing the connection to a SQL 2005 server in an XML file

    Idea: (in Pseudocode)
    if not exist xml_file
    prompt for sql server info (dbserver, username, password)
    else run app.

    At present my app has the sql info hard-coded into the app, but that is kinda limiting.

  2. #2

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,863
    Thank Post
    3,384
    Thanked 1,071 Times in 987 Posts
    Rep Power
    368

  3. #3
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    284
    Thank Post
    39
    Thanked 36 Times in 26 Posts
    Rep Power
    25

    Re: C#/SQL 2005 question

    What version of C#? 2005 has a Settings file that you can use for this kind of thing. Have a look at http://msdn2.microsoft.com/en-us/library/aa730869(vs.80).aspx

  4. #4

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,724
    Thank Post
    867
    Thanked 666 Times in 438 Posts
    Rep Power
    501

    Re: C#/SQL 2005 question

    It's 2005 yeah - will have a look cheers.

  5. #5

    Join Date
    Jun 2007
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: C#/SQL 2005 question

    Hi,

    If You are developing a Windows application, use App.config file for storing connection string details. If web application, use Web.Config file.

    Books for programmers
    http://www.vkinfotek.com

SHARE:
+ Post New Thread

Similar Threads

  1. ID Cards with SQL 2005
    By hayjo86 in forum MIS Systems
    Replies: 2
    Last Post: 20th December 2007, 10:34 AM
  2. SQL 2005
    By jcollings in forum MIS Systems
    Replies: 12
    Last Post: 22nd October 2007, 03:00 PM
  3. Question about sql 2005
    By dezt in forum MIS Systems
    Replies: 11
    Last Post: 26th September 2007, 10:40 PM
  4. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •