Results 1 to 3 of 3

Thread: [2005] SQL Count to Integer in VB.Net

  1. Apr 2nd, 2007, 02:15 PM #1
    Genom
    Genom is offline

    Thread Starter
    Addicted Member Genom's Avatar
    Join Date
    May 2006
    Posts
    186

    [2005] SQL Count to Integer in VB.Net

    Hi;
    How can I get the rows count in a table with Count function in SQL and take it's value as integer??
    Dim Me As Coder
    Reply With Quote Reply With Quote
  2. Apr 2nd, 2007, 02:37 PM #2
    bmahler
    bmahler is offline
    Frenzied Member bmahler's Avatar
    Join Date
    Oct 2005
    Location
    Somewhere just west of the Atlantic
    Posts
    1,568

    Re: [2005] SQL Count to Integer in VB.Net

    SELECT Count(*) FROM TableName
    Boooya
    • Visual Studio 2008 Professional
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • Don't forget to rate helpful posts!
    • If you're question was answered please mark your thread [Resolved]


    Code Contributions:
    PHP
    PHP Image Gallery v1.0 • PHP Image Gallery v2.0
    VB 2005
    Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer

    Useful Links: (more to come)
    MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds
    Reply With Quote Reply With Quote
  3. Apr 2nd, 2007, 08:51 PM #3
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: [2005] SQL Count to Integer in VB.Net

    Create an SqlCommand with that query and call it's ExecuteScalar method. The Integer value will be returned via an Object reference so you'll have to cast the result.
    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
    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