[VB2013] & [MSSQL] Temp Table only lasts as long as the next command.

Having a bit of an issue here and need some input on how to either fix it or change my approach. sSQLTempTables = “CREATE TABLE ” & sMainTargetTable & sSQLTempTableFields sqlMainCmd.CommandText = sSQLTempTables ExecuteSQL(sqlMainCmd, sConn) sSQLTempTables = “CREATE TABLE ” & sFilterTable & sSQLTempTableFields sqlMainCmd.CommandText = sSQLTempTables ExecuteSQL(sqlMainCmd, sConn) Dim sSQL As String = “INSERT […]

Using value from one sub into another

Hey how do I use the cardcount located in the first code in a separate sub for eventhandler (which prints the value of the cardcount) ​ Private Sub bigpictureloader() Dim cardcount As Integer Dim cards As List(Of String) = New List(Of String) cards.Add(imageurltxt.Text) ​ ‘Create a placeholder variable Dim cardPictureBox As PictureBox ​ ‘Loop through […]