WriteXmlÀà(C#)
using System;
using System.Web;
using System.Data;
using System.Text;
using System.Xml;
using System.IO;
namespace Baolee.GeneralMethod
{
/// <summary>
/// WriteXml µÄժҪ˵Ã÷¡£
/// </summary>
public class WriteXml
{
/// <summary>
/// ¹¹Ô캯Êý
/// </summary>
public WriteXml()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
/// <summary>
/// ¶ÁÈ¡XMLºÍXSD, Á½ÎļþͬÃûÈç¹ûÁ½Îļþ²»Í¬Ãû£¬Ôò²Î¿´LoadSignXML
/// </summary>
/// <param name="descDirectory"></param>
/// <param name="fileName">ÎļþÃû£¬²»´øÀ©Õ¹Ãû</param>
/// <returns></returns>
public DataSet Load(string descDirectory, string fileName)
{
DataSet set = new DataSet();
set.ReadXmlSchema(descDirectory + @"\" + fileName + ".xsd");
set.ReadXml(descDirectory + @"\" + fileName + ".xml");
return set;
}
/// <summary>
/// ¶ÁÈ¡µ¥Ò»XMLÎļþ
/// </summary>
/// <param name="descDirectory"></param>
/// <param name="fileName"></param>
/// <returns></returns>
public DataSet LoadSignXML(string descDirectory, string fileName)
{
XmlDataDocument document = new XmlDataDocument();
document.DataSet.ReadXml(descDirectory + @"\" + fileName + ".xml");
return document.DataSet;
}
/// <summary>
/// ¶ÁÈ¡XMLºÍXSD, Á½Îļþ²»Í¬Ãû
/// </summary>
/// <param name="descDirectory"></param>
/// <param name="xmlName"></param>
/// <param name="xsdName"></param>
/// <returns></returns>
public DataSet LoadSignXML(string descDirectory, string xmlName, string
Ïà¹ØÎĵµ£º
Ò»¡¢³éÏóÀࣺ
³éÏóÀàÊÇÌØÊâµÄÀֻ࣬ÊDz»Äܱ»ÊµÀý»¯£»³ý´ËÒÔÍ⣬¾ßÓÐÀàµÄÆäËûÌØÐÔ£»ÖØÒªµÄÊdzéÏóÀà¿ÉÒÔ°üÀ¨³éÏó·½·¨£¬ÕâÊÇÆÕͨÀàËù²»Äܵġ£³éÏó·½·¨Ö»ÄÜÉùÃ÷ÓÚ³éÏóÀàÖУ¬ÇÒ²»°üº¬ÈκÎʵÏÖ£¬ÅÉÉúÀà±ØÐ븲¸ÇËüÃÇ¡£ÁíÍ⣬³éÏóÀà¿ÉÒÔÅÉÉú×ÔÒ»¸ö³éÏóÀ ......
C#¸ñʽ»¯ÊýÖµ½á¹û±í
×Ö·û
˵Ã÷
ʾÀý
Êä³ö
C
»õ±Ò
string.Format("{0:C3}", 2)
¡ç2.000
D
Ê®½øÖÆ
string.Format("{0:D3}", 2)
002
E
¿ÆÑ§¼ÆÊý·¨
1.20E+001
1.20E+001
G
³£¹æ
string.Format("{0:G}", 2)
2
N
Ó÷ֺŸô¿ªµÄÊý×Ö
string.Format("{0:N}", 250000)
250,000.00
X
Ê®Áù½øÖÆ
string.Forma ......
×î½üÔÚæÓÚ ½«×âÁÞ¹ÜÀíϵͳmssqlÊý¾Ý¿â×ªÒÆÖÁfirebirdÊý¾Ý ÒÔ¼õÉٳɱ¾¸ºµ£ Õâ¸ö³£¼ûÎÊÌâ½â¾ö·½°¸Áô¸ø´ó¼Ò ÓиüºÃµÄ»òÕ߯²×©¿éµÄÀ´×Ų»¾Ü ºÇºÇ
MS-sqlÔÚͨ³£ C#´úÂëÀï ÎÒÃÇÌá½»Ò»¸ö²éѯ×Ö·û´® Ö»ÐèÈ磺 string sql=" select id ±àºÅ,[name] ÐÕÃû,sex ÐÔ±ð from users";
Ìá½»¼´¿É·µ»Øtable
µ«ÊÇÔÚ firebirdÔÚ×Ö¶Î ÃüÃû»òÕß ......
1 ArgumentException ÔÚÏò·½·¨ÌṩµÄÆäÖÐÒ»¸ö²ÎÊýÎÞЧʱÒý·¢µÄÒì³£
2 AppDomainUnloadedException ÔÚ³¢ÊÔ·ÃÎÊÒÑÐ¶ÔØµÄÓ¦ÓóÌÐòÓòʱÒý·¢µÄÒì³£
3 ArithmeticException ÒòËãÊõÔËËã¡¢ÀàÐÍת»»»òת»»²Ù×÷ÖеĴíÎó¶øÒý·¢µÄÒì³£
4 ArrayTypeMismatc ......