C# ²Ù×÷XML£¬×Ô¼ºÓùýµÄ´úÂ룬¿ÉÄÜÖ»ÓÐÎÒÄÜ¿´¶®
public string WriteXML(string[] values, int flag)
{
//Èç¹ûflag==0ÔòΪµÚÒ»´ÎÔËÐÐÐèÒª³õʼ»¯XMLÎļþ
if (flag == 0)
{
//ÉúÔÚËæ»úÎļþÃû
string dateName = System.DateTime.Now.ToString("yyyyMMddHHmmss");
string newFileName = Session["orgid"].ToString() + "_" + Session["DeptID"].ToString() + "_" + Session["UserID"].ToString() + "_" + dateName;
string PersonalFolder = Server.MapPath(@"~/offline/" + Session["OrgID"].ToString() + "_" + Session["DeptID"].ToString() + "_" + Session["UserID"].ToString() + "/" + DateTime.Now.ToString("yyyy-MM-dd HH_mm_ss"));
if (!Directory.Exists(PersonalFolder))
{
Directory.CreateDirectory(PersonalFolder);
}
//Directory.SetAccessControl(PersonalFolder, System.Security.AccessControl.DirectorySecurity);
string file = PersonalFolder + "\\" + newFileName + ".xml";
Session["PersonalFolder"] = PersonalFolder;
Session["file"] = file;
#region ´´½¨Îļþ
StreamWriter sw = File.CreateText(file);
sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
sw.WriteLine("<ChkQuaran UserID=\"\" UserName=\"\" DeptID=\"\" OrgID=\"\" RoleID=\"\">");
//sw.WriteLine("<ChkInfo>");
sw.WriteLine();
//sw.WriteLine("</ChkInfo>");
sw.WriteLine("</ChkQuaran>");
sw.Close();
sw.Dispose();
#endregion
#region ²åÈëÓû§ÐÅÏ¢
XMLDataBase.XMLCommen xmlHelper = new XMLDataBase.XMLCommen(file);
xmlHelper.UpdateAttr("ChkQuaran", "UserID", Session["Userid"].ToString());
xmlHelper.UpdateAttr("ChkQuaran", "UserName", Session["UserName"].ToString());
Ïà¹ØÎĵµ£º
ÀûÓÃsqlhelperÖеÄExcuteXmlReader·½·¨£¬¶ÁÈ¡Êý¾Ý²¢±£´æΪxmlÎļþ
string strConn = Properties.Settings.Default.Connections;
SqlConnection connection = new SqlConnection(strConn);
& ......
/*
* XMLTool.cpp ÅäÖÃÎļþ½âÎö¶¯Ì¬¿â×ÊÔ´Îļþ
* Ö÷ÒªÊä³öº¯Êý½Ó¿Ú·Ö±ðʵÏÖ¶ÔÅäÖÃÎļþµÄ¶ÁÈ¡ºÍдÈ룬Õë¶Ô½á¹û¼¯µÄ¸´ÖÆÇå¿Õ£¬ºÍÁ½¸ö×Ö·û´®´¦Àíº¯Êý
* ¶ÁÈ¡ÅäÖÃÎļþ½Ó¿Ú £ºint ReadXMLFile(XML_Node_Vector *XmlNodeVector, string filepath);
* Ð´È ......
Ò»¡¢Access´ÓExcelÖе¼ÈëÊý¾Ý
1.Óõ½µÄExcel±íµÄ¸ñʽ¼°ÄÚÈÝ
ʵÏÖ
OleDbConnection con = new OleDbConnection();
try
{
OpenFileDialog openFile = new OpenFileDialog();//´ò¿ªÎļþ¶Ô»°¿ò¡£
openFile.Filter = ("Excel Îļþ(*.xls)|*.xls") ......
²úÆ·¼¸ÄêǰʹÓÃASP£¬ºóÀ´Éý¼¶µ½.Net 1.1£¬ÔÙÉý¼¶µ½2.0£¬Ò»Ö±¶¼ÓÐÓÃXSLTת»»XMLÉú³ÉÍøÒ³µÄ·½Ê½£¬ÉÔ΢ÕûÀíÏ¡£
XML file:
<?xml version="1.0" encoding="utf-8" ?>
<ric>
<catalog>
<book price ......