Results 1 to 4 of 4

Thread: SQL database questions

Hybrid View

  1. #1
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: SQL database questions

    There is a free management tool - available from MS...

    Here's the link:

    http://msdn.microsoft.com/vstudio/express/sql/

    Third image down is about Management Studio - great utility for building and managing the server and database.

    There are also many code examples available at the MS site - RhinoBull suggested a link recently - search for his name and "code examples" and see what comes up...

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  2. #2

    Thread Starter
    Member
    Join Date
    Sep 2006
    Posts
    63

    Re: SQL database questions

    OK, so now that I'm going to use SQL express, I have created the database from within the VB Express software which has added the database to my application with these 2 files: myTest.mdf & myTestDataSet.xsd.

    How can I access this dataset directly? It should be something like this, but I know this isn't right and it doesn't work:

    intRowCount = myTestDataSet.Tables(0).Rows.Count

    Thanks.

    Greg

Posting Permissions

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



Click Here to Expand Forum to Full Width