[RESOLVED] [02/03] URGENT : Strange Problem with SqlParameter in Update Query

[Coool]

Hi all,
I have faced one problem in SqlParamter passing.

I have one table named tbl_Member in SQL Server 2000

Mem_Id---> Int - Primary Key
Mem_Income-->Int
Mem_Note --> Varchar(50)

Try
            Dim sqlConn As New SqlConnection("Server=Aceteam;Database=Parth-Temp;UID=sa;PWD=*sAraM!wAt")
            Dim strQuery As String = ""
            strQuery = "UPDATE tbl_Member SET " + _
                            " Mem_Id = @ID ," + _
                            " Mem_Income = @Income ," + _
                            " Mem_Note = @Note " + _
                            " WHERE Mem_Id = " + Convert.ToInt32(e.Item.Cells(0).Text)
            Dim sqlCmd As New SqlCommand
            sqlCmd.Parameters.Add("@ID", SqlDbType.Int)
            sqlCmd.Parameters.Add("@Income", SqlDbType.Int)
            sqlCmd.Parameters.Add("@Note", SqlDbType.VarChar)
 
            sqlCmd.Parameters("@ID").Value = Convert.ToInt32(DirectCast(e.Item.Cells(1).Controls(0), TextBox).Text)
            sqlCmd.Parameters("@Income").Value = Convert.ToInt32(DirectCast(e.Item.Cells(2).Controls(0), TextBox).Text)
            sqlCmd.Parameters("@Note").Value = DirectCast(e.Item.Cells(1).Controls(0), TextBox).Text
 
            sqlCmd.CommandType = CommandType.Text
            sqlCmd.CommandText = strQuery
            sqlCmd.Connection = sqlConn
 
            sqlConn.Open()
            sqlCmd.ExecuteNonQuery()
            sqlConn.Close()
        Catch ex As Exception
            Response.Write(ex.Message)
        End Try

The error it shows is ...
Cast from string "UPDATE tbl_Member SET Mem_Id = " to type 'Double' is not valid.

PLZ HELP URGENT