Results 1 to 2 of 2

Thread: [RESOLVED] Database table

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2007
    Location
    Singapore
    Posts
    118

    Resolved [RESOLVED] Database table

    how do i check whether the table in my database have any information or not?????
    Last edited by bczm8703; Mar 7th, 2007 at 10:48 PM.

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: SchemaAdapter

    What's a schemaAdapter or a schemaTable? I've never heard of of either. Regardless, from the names they deal with schema, which has nothing to do with data. If you want to know whether or not a table contains data the most likely way would be to execute a query to get the record count:
    Code:
    SELECT COUNT(*) FROM MyTable
    You can then compare the result to zero to see whether there are any records.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

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