VB.net SQL Table Drop - table will not drop

I'm having trouble getting a SQL 2008 R2 Express table to drop using VB. Here is my code:

Private Sub Form10_AssyWIP_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

    Dim sqConQC As New SqlClient.SqlConnection("Server=QCG11\SQLEXPRESS;Database=QCGMAIN; Trusted_Connection=True;")
    Dim sqCmdQC As New SqlClient.SqlCommand

    sqCmdQC.Connection = sqConQC            'create the DB connection 
    sqConQC.Open()                        'open the connection
    Dim ds As New DataSet
    Dim Adapter As New SqlDataAdapter
    Dim pivot As String
    Dim sql As String
    Dim drop As String
    'Read the data

    drop = "DROP TABLE AssyWIP"
    Adapter.SelectCommand = New SqlCommand(drop, sqConQC)
    sqConQC.Close()
    End Sub

Answers


I'd use a SqlCommand for this:

    drop = "DROP TABLE AssyWIP"
    Dim command As New SqlCommand(drop, sqConQC)
    command.ExecuteNonQuery()
    sqConQC.Close()

Need Your Help

How To Achieve Python3.4 Virtualenv For Precise64 VirtualBox

django virtual-machine ubuntu-12.04 ansible python-3.4

I'm trying to create virtualbox using precise64, Vagrant, and Ansible. I am able to get python2.7 virtualenv setup, but would like to use python3.4 instead. I cloned the ansible-django-stack repo...

What are good values for u and d in Silva and Almeida's backpropagation algorithm?

artificial-intelligence machine-learning neural-network backpropagation

Silva and Almeida's algorithm improves on the existing backpropagation algorithm by introducing individual, adaptive learning-rates for each weight. The value for the new learning rate is computed as

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.