SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Enthusiast welcome_alexray's Avatar
    Join Date
    Mar 2011
    Posts
    76
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    VB.Net Database connectivity

    I currently working on VB.Net project. I would like ti know to SQL server 2005 is better or SQL 2000 for better connectivity. Also I want to know which of this can provide easy connectivity.

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,638
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    I'd go with 2005 for alot of reasons, but ease of connectivity is not one of them.

  3. #3
    SitePoint Guru Jason__C's Avatar
    Join Date
    Oct 2009
    Location
    Racoon City
    Posts
    660
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Possible to go to MSSQL 2008? That way, you can skip 2005 altogether. Their is a free Express 2008 available if you are interested.

  4. #4
    SitePoint Member
    Join Date
    Apr 2011
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL server 2005 is better for connectivity the code is

    SqlConnection con = new SqlConnection("Server=You server name or comp name;Database=Yourdatabasename;Trusted_Connectopn=True");
    SqlCommand cmd = new SqlCommand("Write your sql query here eg. select * from Table name");
    con.Open();
    DataSet ds = new DataSet(cmd,con);
    SqlDataAdapter da = new SqlDataAdapter();
    da.Fill(ds);
    con.Close();

    i hope this should work

  5. #5
    SitePoint Zealot chieftain's Avatar
    Join Date
    Feb 2005
    Location
    Michigan
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ^ How does that make SQL server 2005 better for connectivity?

  6. #6
    SitePoint Evangelist praetor's Avatar
    Join Date
    Aug 2005
    Posts
    479
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by chieftain View Post
    ^ How does that make SQL server 2005 better for connectivity?
    Using DataSets nevertheless... For the OP, accessing any DB from .Net is the same, assuming you have the connector for that rdbms.


Bookmarks

Posting Permissions

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