ASP.NET

ALTER PROCEDURE [dbo].[Usp_User_Delete]
@LoginID AS int,
@DeletingPersonLoginId AS int,
@ErrorMessage as varchar(100) OUTPUT
AS
BEGIN
SET @ErrorMessage = 'SUCCESS'

	BEGIN TRY
		DELETE FROM [tbl_User]
		WHERE
			
		ID = @LoginID and ID<>@DeletingPersonLoginId
	END TRY
	BEGIN CATCH
		SELECT @ErrorMessage = ERROR_MESSAGE()
	END CATCH

DisplayMode = dMode;
FolderAlias = _folderAlias;
SqlConnection conn = new SqlConnection(@"Data Source= .;Initial Catalog=MXContact.NET_Demo_100401;Integrated Security=true;");

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "stbFormPropertiesToXML";    //stored procedure
SqlDataAdapter frmDA = new SqlDataAdapter(cmd.CommandText, cmd.Connection);
DataSet FormPropertiesDS = new DataSet();

try
{
    conn.Open();
    cmd.Parameters.Add(new SqlParameter("@displayMode", SqlDbType.NVarChar));
    cmd.Parameters["@displayMode"].Direction = ParameterDirection.Input;

    cmd.Parameters.Add(new SqlParameter("@folderAlias", SqlDbType.NVarChar));
    cmd.Parameters["@folderAlias"].Direction = ParameterDirection.Input;


    cmd.Parameters["@displayMode"].Value = DisplayMode;
    cmd.Parameters["@folderAlias"].Value = FolderAlias;

    cmd.ExecuteNonQuery();
    frmDA.Fill(FormPropertiesDS);
    conn.Close();

    FormPropertiesDS.WriteXml("FormProperties.xml");
    //FormPropertiesDS.WriteXml(MapPath("FormProperties.xml"));
}
catch (Exception ex)
{
    errorMsg = ex.Message;
}
finally
{
    conn.Close();
}

ALTER PROCEDURE [dbo].[stbFormPropertiesToXML]
@displayMode NVARCHAR(2),
@folderAlias NVARCHAR(30)

AS

SELECT	*
FROM	[stbFormProperties]
WHERE	[FolderKey]		=	(SELECT [FolderKey] FROM [stbFolders] WHERE [FolderAlias] =	@folderAlias)
AND		[DisplayMode]	=	@displayMode