如何删除空行:您好,我有我的数据库probleam,probleam是我有10个空行不没有任何数据,这是发生,因为我按许多插入"按钮插入数据。请告诉我我应该用我的空行删除的编码。对于您的详细信息,我有表名是捆绑和2列的名称和类型。请给我的例子please.Is我的编码正确
connection.ConnectionString = " Data Source=Danawa;Initial Catalog=Store;Integrated Security=True"
Try
connection.Open()
cmd = New SqlCommand("DELETE FROM bundle WHERE type = is NUll'" & Me.txtsearchbundle.Text & "' ", connection)
ra = cmd.ExecuteNonQuery()
MsgBox("Category Are Deleted!!", MsgBoxStyle.Information, "Record Deleted = " & ra)
Catch ex As Exception
MsgBox("Record Failed to Delete")
End Try
connection.Close()
[编辑]增加了"代码"的标签 - losmac [/编辑]