Public Sub gridedit_DeleteCommand(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
Dim con As New SqlConnection(GetConnectionString())
Dim U_ID As String = gridedit.DataKeys(e.Item.ItemIndex).Value.ToString
cmd.CommandText = " Delete from AtdWeekend where WeekendID=" & U_ID
cmd.Connection = con
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
gridedit.EditItemIndex = -1
Binddata()
End Sub
data save in table in WeekendID as char format so here it gives eror how can i resolve it