Hide menus in master page using asp.net

if (Request.QueryString["hid"] != null)
{
if (Request.QueryString["hid"] == "hidelink")
{
_master.ShowHideLinks("hidelinkedarea");
}
}

send this QueryString whenever you need to hide
sample : Response.Redirect("SearchDetails.aspx?cid=" + compid + "&hid=hidelink");

Update(add) values with current values in same column in sqlserver 2005

Create procedure to get XML output in sqlserver 2005

CREATE PROCEDURE [dbo].[GetUsersXML]

AS
BEGIN
SELECT 1 AS TAG,
NULL AS PARENT,
UserID AS [User!1!ID],
UserName AS [User!1!Name]
FROM T_Users
FOR XML EXPLICIT
END

Replace special characters in sqlserver 2005

select field as a XML content in sqlserver 2005