Results 1 to 38 of 38

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

Hybrid View

  1. #1

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

    Re: 'System.Data.SqlClient.SqlException'

    Thanks Techgnome

    That solved a ton of my problems.

    I have more but I think I can get it from here.

    If not then I'll be back.

  2. #2

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

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

    Oooooooh NOOOOOOO!!!!

    I spoke too soon! Now I'm getting the error in a different sub on the same form.

    The error:

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

    is back.

    The Code:

    VB Code:
    1. Public Sub cmdAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click
    2.  
    3.         If txtNew.Text <> "" Then
    4.  
    5.            SqlInsertCommand1.CommandText = "ProblemCategoryAdd '" & txtNew.Text & "'"
    6.             SqlInsertCommand1.CommandType = CommandType.StoredProcedure
    7.             SqlInsertCommand1.Parameters.Clear()
    8.             [B]SqlInsertCommand1.ExecuteReader()[/B]
    9.             txtNew.Text = ""
    10.             txtNew.Select()
    11.         End If
    12.  
    13.         UpdateCombo()
    14.  
    15. End Sub

    is different.

    What did I screw up now???

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