web.sitemap error

Response.ContentType = "text/xml";

using (XmlTextWriter writer = new XmlTextWriter(Server.MapPath("Web.sitemap"), Encoding.UTF8))

{

writer.WriteStartDocument();

writer.WriteRaw("\n");

writer.WriteStartElement("siteMap");

writer.WriteAttributeString("xmlns", "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0");

writer.WriteRaw("\n");

writer.WriteRaw("\t");

writer.WriteStartElement("siteMapNode");

writer.WriteAttributeString("url", "~/Home.aspx");

writer.WriteAttributeString("title", "Home");

writer.WriteRaw("\n");

writer.WriteRaw("\t\t");

writer.WriteStartElement("siteMapNode");

writer.WriteAttributeString("url", "~/MainPage/main.aspx?system=" + lblsystemID.Text);

writer.WriteAttributeString("title", "");

using (SqlConnection con = ClassConn.GetPortalCon())

{

// con.Open();

// da.SelectCommand = new SqlCommand("SELECT * FROM Menu", con);

SqlCommand cmd = new SqlCommand("ret_Menu", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@userID", nopkj);

cmd.Parameters.AddWithValue("@systemID", lblsystemID.Text);

//cmd.Parameters.AddWithValue("@userID", nopkj);

//cmd.Parameters.AddWithValue("@systemID", lblsystemID.Text);

// da.SelectCommand = new SqlCommand("select dbo.Module.moduleDesc, dbo.Module.moduleID,dbo.Module.modulePath, dbo.Module.systemID, dbo.Module.sort, dbo.Module.thcreate, dbo.[User].userID, dbo.Menu.menuID as menuID, dbo.Menu.menuDesc, dbo.Menu.menuPath, dbo.System.systemDesc from dbo.[User],dbo.[System],dbo.Group_Module,dbo.Module,dbo.Group_Menu,dbo.Menu where userID='" + nopkj + "' and dbo.Group_Module.groupID =dbo.[User].groupID and dbo.Module.moduleID=dbo.Group_Module.moduleID and dbo.Module.systemID=dbo.[System].systemID and dbo.[System].systemID='" + lblsystemID.Text + "' and dbo.Group_Menu.moduleID=dbo.Group_Module.moduleID and dbo.Group_Menu.groupID=dbo.[User].groupID and dbo.Menu.menuID=dbo.Group_Menu.menuID ORDER BY Menu.sort ", con);

SqlDataReader sc = cmd.ExecuteReader();

// SqlDataReader sc = da.SelectCommand.ExecuteReader();

if (sc.HasRows)

{

while (sc.Read())

{

var menuID = sc["menuID"].ToString();

writer.WriteRaw("\n"); writer.WriteRaw("\t\t\t");

writer.WriteStartElement("siteMapNode");

writer.WriteAttributeString("url", sc["menuPath"].ToString());

//writer.WriteAttributeString("title", sc["menuDesc_bi"].ToString() + "/" + sc["menuDesc"].ToString());

//writer.WriteAttributeString("description", sc["menuDesc_bi"].ToString() + "/" + sc["menuDesc"].ToString());

writer.WriteAttributeString("title", sc["menuDesc_bi"].ToString());

writer.WriteAttributeString("menuID", sc["menuID"].ToString());

using (SqlConnection con1 = ClassConn.GetPortalCon())

{

//con1.Open();

// da.SelectCommand = new SqlCommand("SELECT * FROM SubMenu where menuID ='" + menuID + "'", con1);

SqlCommand cmd1 = new SqlCommand("ret_SubMenuSiteMap", con1);

cmd1.CommandType = CommandType.StoredProcedure;

cmd1.Parameters.AddWithValue("@userID", nopkj);

cmd1.Parameters.AddWithValue("@systemID", lblsystemID.Text);

cmd1.Parameters.AddWithValue("@menuID", menuID);

SqlDataReader sc1 = cmd1.ExecuteReader();

//SqlDataReader sc1 = da.SelectCommand.ExecuteReader();

if (sc1.HasRows)

{

while (sc1.Read())

{

//string menuPath = sc1["subMenuPath"].ToString();

// int duplicateCounter = 0;

//duplicateCounter++;

writer.WriteRaw("\n");

writer.WriteRaw("\t\t\t\t");

writer.WriteStartElement("siteMapNode");

// writer.WriteAttributeString("subMenuID", sc1["MenuIDsub"].ToString());

// writer.WriteAttributeString("subMenuID", sc1["MenuIDsub"].ToString());

//writer.WriteAttributeString("group", sc1["groupID"].ToString());

//if (menuPath == URL)

//{

// string menuURL = "?id=" + duplicateCounter.ToString();

// writer.WriteAttributeString("url", menuPath + menuURL);

// // Response.Redirect("index.aspx?Path=" + menuPath); }

//}

//else

//{

writer.WriteAttributeString("url", sc1["subMenuPath"].ToString());

// }

// duplicateCounter++;

writer.WriteAttributeString("title", sc1["subMenuDesc_bi"].ToString());

writer.WriteAttributeString("description", sc1["subMenuDesc_bi"].ToString());

//writer.WriteAttributeString("title", sc1["subMenuDesc_bi"].ToString() + "/" + sc1["subMenuDesc"].ToString());

//writer.WriteAttributeString("description", sc1["subMenuDesc_bi"].ToString() + "/" + sc1["subMenuDesc"].ToString());

writer.WriteEndElement();

}

}

con1.Close();

con1.Dispose();

}

writer.WriteEndElement();

}

}

con.Close();

con.Dispose();

}

//writer.WriteRaw("\n");

//writer.WriteRaw("\t\t");

writer.WriteEndElement();

writer.WriteEndDocument();

writer.Close();

}