Results 1 to 6 of 6

Thread: Data through code...

  1. Mar 24th, 2003, 12:56 PM #1
    Anjari
    Anjari is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Dec 2002
    Location
    Canton, GA
    Posts
    487

    Data through code...

    Ok... I am trying to get my database skills going... What I would like to do is connect to my database through code... but here is the catch..

    I have my database on a web server..

    How do I use code to connect to the database on a remote server? Would some kind soul out there give me an example how to connect to the database through code and display data?? Please comment heavily so I can see what each action is for?

    Thanks in advance.

    Anjari
    Reply With Quote Reply With Quote
  2. Mar 24th, 2003, 12:58 PM #2
    Cander
    Cander is offline
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    what kind of database. If it is Access, you cant do that as far as I know.
    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9
    Reply With Quote Reply With Quote
  3. Mar 24th, 2003, 01:54 PM #3
    Anjari
    Anjari is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Dec 2002
    Location
    Canton, GA
    Posts
    487

    yea...

    yea it's an access database... but its not 100% necessary to use access....

    Anjari
    Reply With Quote Reply With Quote
  4. Mar 25th, 2003, 08:37 AM #4
    Negative0
    Negative0 is offline
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367
    Use a server based database such as SQL Server or MySQL.

    MySQL is free and is very similar to SQL server, so I would suggest using that.

    Once you do that it is as simple as setting up a connection string in your database. This link from MySQL.com has all of the information you need to connect to a MySQL database:

    http://www.mysql.com/articles/dotnet/
    Negative 0

    Blog | RegEx | Encrypting UN/PW in Web.Config | Enabling ASP.Net on IIS 6 | Port Numbers | Creating GUIDs | Start->Run | Modifying the default class



    Reply With Quote Reply With Quote
  6. Mar 25th, 2003, 11:02 PM #5
    rudvs2
    rudvs2 is offline
    Fanatic Member rudvs2's Avatar
    Join Date
    Mar 2001
    Location
    NZ
    Posts
    935
    why not build a webservice that sits with the remote database and you just call methods on the webservice which querys the db and returns you dataset

    I have used this approach often its really nice and not too much slower
    Reply With Quote Reply With Quote
  7. Mar 26th, 2003, 11:16 AM #6
    Anjari
    Anjari is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Dec 2002
    Location
    Canton, GA
    Posts
    487

    still new...

    Could you explain a little more?

    Thanks,

    Anjari
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width