Save XML to SQL Server database - C# - CRASH - Please Help

I am trying to save XML to SQL Server 2005 database through C# in a ASP.Net Application ?

It's crashing on
 myCommand.ExecuteNonQuery();

Error getting while debugging is - "Failed to convert parameter value from a XmlDocument to a String."
Error showing in error page is "Object must implement IConvertible"

What I am doing wrong here ?

Appreciates your suggestion that could resolve this issue!

Thanks
Raj


This is the Stored Procedure
 

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[uspS_WorkspeedXML]
(
	@WorkspeedTransDetailsID	BIGINT,
	@RequestXML					XML,
	@RequestTime				DATETIME,
	@ResponseXML				XML,
	@ResponseTime				DATETIME
)
AS
BEGIN

	DECLARE @ATTEMPT INT
	SET @ATTEMPT = 0

	SELECT @ATTEMPT = COUNT(*) FROM TBL_WORKSPEED_XMLs
		WHERE WorkspeedTransDetailsID = @WorkspeedTransDetailsID

	INSERT INTO TBL_WORKSPEED_XMLs
	(
		WorkspeedTransDetailsID,
		AttemptNumber,
		RequestXML,
		ResponseXML,
		RequestTime,
		ResponseTime
	)
	VALUES
	(
		@WorkspeedTransDetailsID,
		@ATTEMPT + 1,
		@RequestXML,
		@ResponseXML,
		@RequestTime,
		@ResponseTime
	)

END

Select allOpen in new window

Here is the C# Code
 

private void SaveXMLToDatabase(XmlDocument xmlRequest, XmlDocument xmlResponse, DateTime requestTime,
                    DateTime responseTime, SqlConnection mySQLConnection)
    {
        SqlCommand myCommand = default(SqlCommand);

        if (mySQLConnection.State == 0)
            mySQLConnection.Open();


        myCommand = new SqlCommand("uspS_WorkspeedXML", mySQLConnection);
        myCommand.CommandType = CommandType.StoredProcedure;

        // @WorkspeedTransDetailsID	    BIGINT
        myCommand.Parameters.Add(new SqlParameter("@WorkspeedTransDetailsID", SqlDbType.BigInt));
        myCommand.Parameters["@WorkspeedTransDetailsID"].Value = objUser.SubmitTransMasterID; // TBL_WORKSPEED_DETAILS.WorkspeedTransDetailsID

        // @RequestXML	XML
        myCommand.Parameters.Add(new SqlParameter("@RequestXML", SqlDbType.Xml));
        myCommand.Parameters["@RequestXML"].Value = xmlRequest;

        // @RequestTime				DATETIME
        myCommand.Parameters.Add(new SqlParameter("@RequestTime", SqlDbType.DateTime));
        myCommand.Parameters["@RequestTime"].Value = requestTime;

        // @ResponseXML				XML
        myCommand.Parameters.Add(new SqlParameter("@ResponseXML", SqlDbType.Xml));
        myCommand.Parameters["@ResponseXML"].Value = xmlResponse;
        
        // @ResponseTime				DATETIME
        myCommand.Parameters.Add(new SqlParameter("@ResponseTime", SqlDbType.DateTime));
        myCommand.Parameters["@ResponseTime"].Value = responseTime;

        myCommand.ExecuteNonQuery();

        myCommand.Dispose();

        if (mySQLConnection.State == ConnectionState.Open)
            mySQLConnection.Close();

    }

Select allOpen in new window