السلام عليكم
عامل صفحة با asp.net وشغال vb2008 وداتا بيز 2008 Sql server
المهم
انا عامل
insert
update
جيت اعمل delete
طلعلي المشكلة دي
Incorrect syntax near '*'.
ده الكود
Dim cn As New SqlConnection("Data Source=IBRAHIM-1C3291F;Initial Catalog=DataBase;Integrated Security=True")
Dim Cmd As New SqlCommand
Dim Dr As SqlDataReader
Dim Ad As New SqlDataAdapter
Dim Dbs As New DataSet
Dim S As String
Dim H As Integer
Dim onH As Integer
cn.Open()
Cmd.Connection = cn
Cmd.CommandType = CommandType.Text
Cmd.CommandText = "Delete * from Items where Icode = '" + Icode.Text + "'"
Cmd.ExecuteNonQuery()
cn.Close()