In below code my delete query does not work.It give a error of Quotation mark

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sagar shah

    #1

    In below code my delete query does not work.It give a error of Quotation mark

    Protected Sub BtnDelete_Click (ByVal sender As Object, ByVal e As System.EventArg s) Handles BtnDelete.Click
    Dim feedbackId, Comm As String
    Dim GrdItm As DataGridItem
    For Each GrdItm In GrdFeedback.Ite ms
    If CType(GrdItm.Fi ndControl("ChkF eedbackDelete") , CheckBox).Check ed = True Then
    feedbackId = feedbackId & Comm & CType(GrdItm.Fi ndControl("LblI d"), Label).Text 'THIS CODE WILL DELETE ALL ROWS WHICH CHECKBOX IS TRUE'
    Comm = ","
    End If
    Next
    If feedbackId <> "" Then
    ObjEng.ExecuteC ommand("Delete From FeedBack Where FeedBackId in (" & feedbackId & ")")
    End If
    LoadFeedback()
    End Sub
  • danp129
    Recognized Expert Contributor
    • Jul 2006
    • 323

    #2
    Instead of trying to execute the concatenated SQL, write it to the page and check it for syntax errors.

    Comment

    Working...