here is the code for del.aspx

<form name="form1" method="post" action="table1.aspx">
        <%
        dim cv as string
    dim str as string
    Dim strConnection As String = "user id=sa;password=;server=.;initial catalog=students"
    Dim cn As SqlConnection = New SqlConnection(strConnection)
     cn.Open()
     str=(Request.QueryString("cv"))
         Dim strSelect As String = "DELETE teachers where TID ='"& str &"' "
     response.write(strSelect)
    ' response.End()
     Dim sqlComm As new SqlCommand(strSelect,cn)
     try
     sqlComm.ExecuteNonQuery()
     catch ex as exception
     response.Write(ex.ToString())
     finally
     cn.close()
     end try
'response.redirect("Teachview.aspx")

        %>
        </form>
my sql statement passing value is correct,

DELETE teachers where TID ='1' System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ' '. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.del_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in http://localhost/add/del.aspx:line 32


Line 32 is the sqlcomm.executenonquery() method.its in this statement error is there.i duno wats wrong.if anybody knows pls tel me.

Is TID a string data type of numerical (int, for example)? Your DELETE statment is using TID as a string.

Hi,

TID is a nvarchar.

Not sure what SQL variation your are using, but it looks like you are missing the FROM statement in your SQL statement.

Try "DELETE FROM teachers WHERE TID ='"& str &"';"

- A.Kahtava

i did use from statement b4.then a memeber in wrox told me to remove it.and it was working perfectly fine with with my above sql statement.but after few days i rerun it,its not working.

When deleting items, you usually need to declare what table you are deleting from. Be careful, because a wayward delete statement can toss ALL of the data in your table/database.

This statement:

    Dim strSelect As String = "DELETE teachers where TID ='"& str &"' "

seems a bit suspicious. There looks like there is a trailing space (which shouldn't hurt) or worse, some nonprintable character.

How about:

    Dim strSelect As String = "DELETE teachers where TID ='" & str & "'"

The resultant

    DELETE teachers where TID = '1'

is correct syntax, so if this fails something else is going on.

As an aside, the FROM keyword in a DELETE statement is optional.


Jeff Mason
Custom Apps, Inc.
www.custom-apps.com