Mufi,
One thing you can try it to look at SQL Profiler and see exactly what commands are being sent to the backend when you try to update your table.
~~Bonnie
>SQL PROCEDURE
>
>
>SET QUOTED_IDENTIFIER ON
>GO
>SET ANSI_NULLS ON
>GO
>
>ALTER Proc UpGpFilter
>@Finame varchar(25)= null,
>@Finameid int
>AS
>Update GpFilter
>
>Set Finame = @Finame
>Where
>Finameid = @Finameid
>
>GO
>SET QUOTED_IDENTIFIER OFF
>GO
>SET ANSI_NULLS ON
>GO
>
>
>
>
>
>
>VB.NET CODE
>
>Private Sub UpdateRecord()
> Try
> Dim mycnn As New SqlConnection(ConnectionString)
> dap1.UpdateCommand = New SqlCommand("UpGpFilter", mycnn)
> With dap1.UpdateCommand
> .CommandType = CommandType.StoredProcedure
> .Parameters.Add("@Finame", SqlDbType.VarChar, 25, "Finame")
> Dim prm1 As SqlParameter = dap1.UpdateCommand.Parameters.Add("@Finameid", SqlDbType.Int)
> prm1.SourceColumn = "Finameid"
> prm1.SourceVersion = DataRowVersion.Original
> End With
>
> mycnn.Open()
> myds.GpFilter.GetChanges(DataRowState.Modified)
> dap1.Update(myds, "GpFilter")
> mycnn.Close()
>
> Catch ex As SqlException
> MsgBox(ex.Message, MsgBoxStyle.Critical, "SQL ERROR")
>
> Catch ex As Exception
> MsgBox(ex.Message, MsgBoxStyle.Critical, "General Error")
>
> End Try
>
> End Sub
>
>