XMLÔö\ɾ¡¢¸Ä¡¢²é¼òµ¥²Ù×÷
protected void Page_Load(object sender, EventArgs e)
{
lblValue.Text = string.Format("{0:N}", 2500000);
lblValue.Text = string.Format("{0:C3}", 2);
// ¼ÓÔØÊ±²»»º´æÊý¾Ý
Response.Cache.SetNoStore();
if (!IsPostBack)
{
// ³õʼ»¯Ò³ÃæÏÔʾ
ShowXml();
}
}
// ³õʼ»¯Ò³ÃæÏÔʾ
private void ShowXml()
{
// »ñÈ¡xmlÊý¾Ý
string url = Server.MapPath("user.xml");
StreamReader sr = new StreamReader(url, System.Text.Encoding.GetEncoding("GB2312"));
// ²Ù×÷xmlÎĵµ
XmlDataDocument xmlDataDocument = new XmlDataDocument();
// ½«¶ÁÈ¡µÄ×Ö½ÚÁ÷±£´æµ½DataSetÖÐ
xmlDataDocument.DataSet.ReadXml(sr);
this.DataGrid1.DataSource = xmlDataDocument.DataSet.Tables[0].DefaultView;
// ¶¨ÒåÏÔʾID
this.DataGrid1.DataKeyField = "username";
this.DataGrid1.DataBind();
xmlDataDocument = null;
sr.Close();
}
protected override void OnInit(EventArgs e)
{
Ïà¹ØÎĵµ£º
ÀûÓÃsqlhelperÖеÄExcuteXmlReader·½·¨£¬¶ÁÈ¡Êý¾Ý²¢±£´æÎªxmlÎļþ
string strConn = Properties.Settings.Default.Connections;
SqlConnection connection = new SqlConnection(strConn);
& ......
/*
* XMLTool.h ÅäÖÃÎļþ½âÎö¶¯Ì¬¿âÍ·Îļþ
* Ö÷ÒªÊä³öº¯Êý½Ó¿Ú·Ö±ðʵÏÖ¶ÔÅäÖÃÎļþµÄ¶ÁÈ¡ºÍдÈ룬Õë¶Ô½á¹û¼¯µÄ¸´ÖÆÇå¿Õ£¬ºÍÁ½¸ö×Ö·û´®´¦Àíº¯Êý
* ¶ÁÈ¡ÅäÖÃÎļþ½Ó¿Ú £ºint ReadXMLFile(XML_Node_Vector *XmlNodeVector, string filepath);
* дÈëÅäÖ ......
µÚÒ»ÖÖ·½Ê½--ʹÓÃMSXML2.DOMDOCUMENT.4.0
´´½¨xmldoc¶ÔÏ󣬲¢×°ÔØÒ»¸öxml
Set xmldoc = CreateObject("MSXML2.DOMDOCUMENT.4.0")
xmldoc.loadXML ("Ò»¸ö¾ßÌåµÄXMLʵÌå")
Ñ¡ÔñÐèҪɸѡµÄ½áµã
Set nodeList = xmldoc.selectNodes("//*[count(ancestor::*)= 2]") '¸ù½ÚµãµÄµÚ¶þ´úºó´ú
Set nodeList = xmldoc ......
SQL Server¸ù¾Ý²éѯ½á¹û,Éú³ÉXMLÎļþ
À´Ô´£º²»Ïê ×÷ÕߣºØýÃû ʱ¼ä£º2009-3-6 22:15:58 ·¢²¼£ººÚ¿ÍÈí¼þÔ°
/*
'bcp' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¿
¿´¿´ÔÚC:\Program Files\Microsoft SQL Server\80\Tools\BinnÀïÃæÓÐûÓÐbcp.exeÕâ¸öÎļþ
È»ºó¿´¿´pathÀïÃæ¼ÓC:\Program Files\Microso ......
java ´úÂë
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.NodeList; ......