c# ²Ù×÷excel
OleDbConnection conn = null;
try
{
`string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source="+path+";"+
"Extended Properties='Excel 8.0;'";
conn = new OleDbConnection(strConn);
conn.Open();
string Sql = "select * from [list$]";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
OleDbDataAdapter ddp = new OleDbDataAdapter(Sql, conn);
DataSet ds = new DataSet();
ddp.Fill(ds);
//cmd.Connection = conn;
//ÔÚExcelµÄSheet1µÄA3µ½H3´¦²åÈëÊý¾Ý
//cmd.CommandText = "insert into [Sheet1$A3:H3] (F1,F2,F3,
Ïà¹ØÎĵµ£º
Ribbon ÔÀ´³öÏÖÔÚ Microsoft Office 2007 µÄ Word¡¢Excel ºÍ Powerpoint 組¼þÖУ¬ºóÀ´Ò²±»ÔËÓõ½ Windows 7 µÄһЩ¸½¼Ó×é¼þµÈÆäËüÈí¼þÖУ¬Èç»Í¼ºÍд×Ö°å¡£ËüÊÇÒ»¸öÊÕ²ØÁËÃüÁî°´Å¥ºÍͼ±êµÄÃæ°å¡£Ëü°ÑÃüÁî×éÖ¯³ÉÒ»×é"±êÇ©"£¬Ã¿Ò»×é°üº¬ÁËÏà¹ØµÄÃüÁÿһ¸öÓ¦ÓóÌÐò¶¼ÓÐÒ»¸ö²»Í¬µÄ±êÇ©×飬չʾÁ˳ÌÐòËùÌṩ ......
C#ÐòÁл¯xml
¹Ø¼ü²½Ö裺
XmlSerializer xSerializer = new XmlSerializer(typeof(MyObj));
StringWriter sWriter = new StringWriter(CultureInfo.InvariantCulture);
XmlTextWriter xTextWriter = new XmlTextWriter(sWriter);
......
MSSQL:
declare @begin datetime
declare @End datetime
set @begin=getdate()
--Ö´ÐеÄÓï¾äдÔÚÕâÀï
set @End=getdate()
select datediff(millisecond,@begin,@End) as Ö´ÐеÄʱ¼ä
--millisecond±íʾºÁÃë Èç¹û¿´Ãë¿ÉÒÔʹÓÃss
C#:
ºÜ¶àʱº ......
XmlDocument doc = new XmlDocument();
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", "GB2312", null);
doc.AppendChild(dec);
//´´½¨Ò»¸ö¸ù½Úµã£¨Ò»¼¶£©
XmlElement root = doc.CreateElement("First");
doc.AppendChild(root);
//´´½¨½Úµã£ ......
¡¡¡¡´ó¼ÒÔÚʵ¼Ê¹¤×÷ѧϰC#µÄʱºò£¬¿ÉÄÜ»áÎÊ£ºÎªÊ²Ã´ÎÒÃÇҪΪһЩÒѾ´æÔڵŦÄÜ£¨±ÈÈçWindowsÖеÄһЩ¹¦ÄÜ£¬C++ÖÐÒѾ±àдºÃµÄһЩ·½·¨£©ÒªÖØбàд´úÂ룬C#ÓÐûÓз½·¨¿ÉÒÔÖ±½Ó¶¼ÓÃÕâЩԱ¾ÒѾ´æÔڵŦÄÜÄØ£¿´ð°¸Êǿ϶¨µÄ£¬´ó¼Ò¿ÉÒÔͨ¹ýC#ÖеÄDllImportÖ±½Óµ÷ÓÃÕâЩ¹¦ÄÜ¡£
¡¡¡¡DllImportËùÔÚµÄÃû×Ö¿Õ¼ä using System.Runt ......