"fill select command code has not been initialized" run time error on executable only

Question

Dim myconn As New SqlConnection("Data Source = localhost\\SQLEXPRESS; 

Initial Catalog = test2Forms; Integrated Security = SSPI;")

    Dim myTable As New DataTable()

    Dim myCmd As New SqlCommand()

    WithActivityLog3TableAdapter.Fill(_dbo_withActivityLog3DataSet.withActivityLog3)

    myCmd.CommandText = "SELECT * FROM dbo.withActivityLog3 WHERE ID = @ID"

    myCmd.Connection = myconn



    Dim myAdapater As New SqlDataAdapter(myCmd)

    SqlDataAdapter1.Fill(myTable)



    DataGridView2.DataSource = myTable

This code works when I compile and test it on my primary computer, but when I upload it to the server and it is downloaded to test, it comes up with the above runtime error on the form load. I've looked at other related posts and it looks like it might be a matter of order of execution?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

Do you not see an issue with this:

Dim myAdapater As New SqlDataAdapter(myCmd)
SqlDataAdapter1.Fill(myTable)

You set the CommandText of myAdapter and then call Fill on SqlDataAdapter1.

"fill select command code has not been initialized" run time error on executable only

Sign up