Results 1 to 38 of 38

Thread: [RESOLVED] 'System.Data.SqlClient.SqlException'

Threaded View

  1. #1

    Thread Starter
    Addicted Member Golfreak's Avatar
    Join Date
    Oct 2005
    Location
    stuck in a cube
    Posts
    147

    Resolved [RESOLVED] 'System.Data.SqlClient.SqlException'

    hey guys

    just wondering if anyone can help. I'm getting this error:

    VB Code:
    1. An unhandled exception of type [B]System.Data.SqlClient.SqlException [/B] occurred in system.data.dll
    2.  
    3. Additional information: System error.

    and it occurs in this Sub: (in red)

    VB Code:
    1. Public Sub UpdateCombo()
    2.  
    3.         Dim RSAllCategories As SqlClient.SqlDataReader
    4.  
    5.         SqlUpdateCommand1.CommandText = "Exec ProblemCategoryList"
    6.         [COLOR=Red]RSAllCategories = SqlUpdateCommand1.ExecuteReader()[/COLOR]
    7.        
    8.         Do Until RSAllCategories.IsClosed
    9.  
    10.             cmbSelect.Items.Add(RSAllCategories.GetValue("ProblemCategory").Value)
    11.             RSAllCategories.NextResult()
    12.  
    13.         Loop
    14.  
    15.     End Sub

    whats wrong with the code?
    Last edited by Golfreak; Oct 20th, 2005 at 09:13 AM.

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