I have the following code generating error when executing the executenonquery command. I think the error is with the DELETE sql statement
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Partial Class ContentPages_ShowOfficeIssues
Inherits System.Web.UI.Page
Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
Dim conString = ConfigurationManager.ConnectionStrings("TrackingConnectionString").ConnectionString
Dim queryString As String = "DELETE PostingsTemp.* FROM PostingsTemp"
Dim connection As New SqlConnection(conString)
If Not Page.IsPostBack Then
Dim command As New SqlCommand(queryString, connection)
connection.Open()
command.ExecuteNonQuery()
ListView1.DataBind()
End If
End Sub
Thanks
...
Go to the complete details ...