Posted on: 5/10/2013 2:10:01 AM | Views : 202

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 ...