troubleshooting Question

Visual Studio Visual Basic Code Error

Avatar of fsuedu
fsuedu asked on
.NET ProgrammingVisual Basic.NET
2 Comments1 Solution188 ViewsLast Modified:
Hello,
Getting error
         Error      2      Type 'SqlCommand' is not defined
from previous help on statment

Private Sub Testbutton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Testbutton.Click
        Dim colCmd As New SqlCommand
        Dim objConn As New SqlConnection("")
        Dim locTab As New DataTable

        Try
            objConn.Open()
            With colCmd
                .CommandType = CommandType.Text
                .CommandText = "INSERT INTO Settlement VALUES(" & PreviouAdvDepositstxtTextBox.Text & ", " & TransferGuestLedgertxt.Text & "," & Activityadvdeposittxt.Text & "," & transferfromadvdeposittxt.Text & ", " & transfromguesttoadvtxt.Text & "," & Advchangefrominctxt.Text & ")"
                .Connection = objConn
                .ExecuteNonQuery()
            End With
            objConn.Close()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
    End Sub

Where should I put the   Imports System.Data.SqlClient  statment?

Thanks JK
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros