&#060;WebMethod()&#062; Public Function DeleteCatalog(ByVal index As Integer) As Catalog1<BR> Dim Catalog As New Catalog1()<BR> SqlDataAdapter1.Fill(Catalog)<BR> Dim row As DataRow = Catalog.Catalog(index)<BR> Catalog.Catalog.RemoveCatalogRow(row)<BR> SqlDataAdapter1.Update(Catalog)<BR> Return Catalog<BR> End Function<BR><BR>i use the following code to remove a row from database. basically it removes row from dataset "Catalog" but it doesnt update the sqldatabase, so it doesnt really delete. I do the same thing with inserting row and it works fine. can anyone help?