asp.net¶ÔxmlÎļþµÄ¶Áд¡¢Ìí¼Ó¡¢Ð޸ġ¢É¾³ý
using System.Collections;
using System.Xml;
private void LoadXml()
{
xmlDoc=new XmlDocument();
xmlDoc.Load(Server.MapPath("User.xml"));
}
//Ìí¼Ó½Úµã
private void AddElement()
{
LoadXml();
XmlNode xmldocSelect=xmlDoc.SelectSingleNode("user");
XmlElement el=xmlDoc.CreateElement("person"); //Ìí¼Óperson½Úµã
el.SetAttribute("name","·çÔÆ"); //Ìí¼Óperson½ÚµãµÄÊôÐÔ"name"
el.SetAttribute("sex","Å®"); //Ìí¼Óperson½ÚµãµÄÊôÐÔ "sex"
el.SetAttribute("age","25"); //Ìí¼Óperson½ÚµãµÄÊôÐÔ "age"
XmlElement xesub1=xmlDoc.CreateElement("pass"); //Ìí¼Óperson½ÚµãµÄÀïµÄ½Úµã
xesub1.InnerText="123";//ÉèÖÃÎı¾½Úµã
el.AppendChild(xesub1);
XmlElement xesub2=xmlDoc.CreateElement("Address");
xesub2.InnerText="À¥Ã÷";//ÉèÖÃÎı¾½Úµã
el.AppendChild(xesub2);
xmldocSelect.AppendChild(el);
xmlDoc.Save(Server.MapPath("user.xml"));
}
//Ð޸Ľڵã
private void UpdateElement()
{
LoadXml();
XmlNodeList nodeList=xmlDoc.SelectSingleNode("user").ChildNodes;//»ñÈ¡bookstore½ÚµãµÄËùÓÐ×Ó½Úµã
foreach(XmlNode xn in nodeList)//±éÀúËùÓÐ×Ó½Úµã
{
XmlElement xe=(XmlElement)xn;//½«×Ó½ÚµãÀàÐÍת»»ÎªXmlElementÀàÐÍ
if(xe.GetAttribute("name")=="·çÔÆ")//Èç¹ûnameÊôÐÔֵΪ“·çÔÆ”
{
xe.SetAttribute("name","·¢Ã÷");
//Èç¹ûÏÂÃæÓÐ×Ó½ÚµãÔÚÏÂ×ß
XmlNodeList nls=xe.ChildNodes;//¼ÌÐø»ñÈ¡xe×Ó½ÚµãµÄËùÓÐ×Ó½Úµã
foreach(XmlNode xn1 in nls)//±éÀú
{
XmlElement xe2=(XmlElement)xn1;//ת»»ÀàÐÍ
if(xe2.Name=="pass")//Èç¹ûÕÒµ½
{
xe2.InnerText="66666";//ÔòÐÞ¸Ä
break;
}
}
break;
}
}
xmlDoc.Save(Server.MapPath("user.xml"));//±£´æ
}
//ɾ³ö½Úµã
private void deleteNode()
{
LoadXml();
XmlNodeList xnl=xmlDoc.SelectSingleNode("user").ChildNodes;
foreach(XmlNode xn in xnl)
{
XmlElement xe=(XmlElement)xn;
if(xe.GetAttribute("name")=="·¢Ã÷")
{
//xe.RemoveAttribute("name");//ɾ³ýnameÊôÐÔ
xe.RemoveAll();//ɾ³ý¸Ã½ÚµãµÄÈ«²¿ÄÚÈÝ
break;
}
}
xmlDoc.Save(Server.MapPath("user.xml"));//±£´æ
}
private void showIt()
{
LoadXml();
Ïà¹ØÎĵµ£º
´æ´¢¹ý³Ì´úÂ룺
create procedure proc_name
@para1 nchar(20), --ÊäÈë²ÎÊý
@para2 int = null output¡¡--Êä³ö²ÎÊý£¬¹©³ÌÐòʹÓÃ
as
begin
if (@para1='a')
begin
insert into employee(name) value ......
¹«Ë¾ÔÓÐÒ»¸ö¾ÖÓòÍø£¬¾¹ý¶àÄêµÄÐÞÐÞ²¹²¹£¬ÒѾ´´½¨Á˲»ÉÙµÄÄÚÈÝ£¬°üÀ¨Ò»Ð©Êý¾Ý¿â²éѯ±¨±í¡¢¹¤×÷Á÷µÈÍøÕ¾£¬ÕâÐ©ÍøÕ¾ÓÐһЩÊÇÓÃASP.NETÀ´¿ª·¢µÄ£¬²¢ÇÒÓÃÁ˺ܶàÄ꣬»ýÀÛÁ˺ܶàÒµÎñÊý¾Ý£»ÏÖÔÚ¹«Ë¾Ïë°Ñ¾ÖÓòÍøÓÃWSS3.0À´¼ÜÉ裬Õâ¾ÍÃæÁÙµ½Ò»¸öºÜ¼¬ÊÖµÄÎÊÌ⣬¾ÍÊÇÔõÑùÀ´´¦ÀíÕâЩ¾ÉµÄÍøÒ³¡£Èç¹ûÍÆµ¹ÖØÀ´£¬ÄÇô¹¤×÷Á¿½«ÊǷdz£ÏÅÈ˵ģ ......
ASP.NET³£¼û°²È«ÎÊÌâ
Ò»¡¢SQLÓï¾ä©¶´
Ðí¶à³ÌÐòÔ±ÔÚÓÃsqlÓï¾ä½øÐÐÓû§ÃÜÂëÑé֤ʱÊÇͨ¹ýÒ»¸öÀàËÆÕâÑùµÄÓï¾äÀ´ÊµÏֵģº
Sql="Select * from Óû§±í where ÐÕÃû = '" + name + "' and ÃÜÂë = '" + password + "'"
ͨ¹ý·ÖÎö¿ÉÒÔ·¢ÏÖ£¬ÉÏÊöÓï¾ä´æÔÚ×ÅÖÂÃüµÄ©¶´¡£µ±ÎÒÃÇÔÚÓû§Ãû³ÆÖÐÊäÈëÏÂÃæµÄ×Ö·û´®Ê±£ºtes ......
function _doPostBack(){};
if(typeof("__doPostBack")=="function")
{
_doPostBack=__doPostBack;
__doPostBack=_doPostBackNew;
}
document.attachEvent("onmousemove",_onmousemove);
var _isPosting=false;
var _divMask=null;
function _onmousemove()
{
if(_divMask)
with(_divMask.runtimeStyle)
......