ASP.NET

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