c#²Ù×÷Excel һЩÎÊÌâ ×Ö·û±äΪnull½â¾ö·½·¨
C#¶ÁÈ¡ExcelÓöµ½ÎÞ·¨¶ÁÈ¡µÄ½â¾ö·½·¨£º
1.ÔÚµ¼ÈëÊý¾ÝÁ¬½Ó×Ö·û´®ÖУ¬½«IMEX=1¼ÓÈ룬“Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Data.xls";Extended Properties="Excel 8.0;HDR=Yes;IMEX=1; ”£¬ÕâÑù¾Í¿ÉÒÔ¡£
C#¶ÁÈ¡ExcelÐèҪעÒâµÄ£º
IMEX=1£º»ìºÏģʽ
HDR=Yes; ÊÇ·ñÈõÚÒ»ÐÐ×÷ΪÁÐÍ·
Á½Õß±ØÐëÒ»ÆðʹÓá£
±¾ÒÔΪÕâÑù¾ÍOKÁË¡£
µ«ÔÚʵ¼ÊʹÓùý³ÌÖУ¬ÕâÑùÉèÖû¹ÊDz»ÐУ¬²éÔÄÁ˲»ÉÙ×ÊÁϲŷ¢ÏÖ£¬ÔÀ´»¹ÓÐÒ»¸ö×¢²á±íÀïµÄÐÅÏ¢ÐèÒªÐ޸ģ¬
ÕâÑù´øÄÜÈÃexcel²»ÔÙʹÓÃǰ8ÐеÄÄÚÈÝÀ´È·¶¨¸ÃÁеÄÀàÐÍ¡£
C#¶ÁÈ¡ExcelÖ®×¢²á±íÐÞ¸ÄÄÚÈÝÈçÏ£º
ÔÚHKLM\Software\Microsoft\Jet\4.0\Engines\ExcelÓÐÒ»¸öTypeGuessRowsÖµ,Ô¤ÉèÊÇ8,±íʾ»áÏȶÁȡǰ8ÁÐÀ´¾ö¶¨Ã¿Ò»¸öÀ¸Î»µÄÐÍ̬,ËùÒÔÈç¹ûǰ8ÁеÄ×ÊÁ϶¼ÊÇÊý×Ö,µ½Á˵Ú9ÁÐÒÔºó³öÏÖµÄÎÄ×Ö×ÊÁ϶¼»á±ä³Énull,ËùÒÔÈç¹ûÒª½â¾öÕâ¸öÎÊÌâ,Ö»Òª°ÑTypeGuessRows»úÂëÖµ¸Ä³É0,¾Í¿ÉÒÔ½âÕâ¸öÎÊÌâÁË!
Ïà¹ØÎĵµ£º
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#:
ºÜ¶àʱº ......
ºÜ¶àʱºòÓÐÒ»¸öxml×Ö·û´®£¬Ã»Óл»ÐУ¬Ã»ÓÐËõ½ø£¬ÒªÉú³ÉxmlÎļþ²»Ò×ÔĶÁ¡£ÏÂÃæµÄ´úÂë¾ÍÊÇÔõô½«Ò»¸öÁ¬ÐøµÄxml×Ö·û´®¸ñʽ»¯Êä³ö
// a demo string
string xml = "<Root><Eles><Ele>abc</Ele><Ele>123</Ele></Eles></Root>";
System.Xml.XmlDocument doc = new System.Xml ......
1. ´ò¿ªÐµĴ°¿Ú²¢´«ËͲÎÊý£º
¡¡¡¡´«ËͲÎÊý£º
response.write("£¼script£¾window.open(’*.aspx?id="+this.DropDownList1.SelectIndex+"&id1="+...+"’)£¼/script£¾")
¡¡¡¡½ÓÊÕ²ÎÊý£º
string a = Request.QueryString("id");
string b = Request.QueryString("id1");
¡¡¡¡2.Ϊ°´Å¥Ìí¼Ó¶Ô»°¿ò
Button1 ......
¡¡¡¡´ó¼ÒÔÚʵ¼Ê¹¤×÷ѧϰC#µÄʱºò£¬¿ÉÄÜ»áÎÊ£ºÎªÊ²Ã´ÎÒÃÇҪΪһЩÒѾ´æÔڵŦÄÜ£¨±ÈÈçWindowsÖеÄһЩ¹¦ÄÜ£¬C++ÖÐÒѾ±àдºÃµÄһЩ·½·¨£©ÒªÖØÐ±àд´úÂ룬C#ÓÐûÓз½·¨¿ÉÒÔÖ±½Ó¶¼ÓÃÕâЩԱ¾ÒѾ´æÔڵŦÄÜÄØ£¿´ð°¸Êǿ϶¨µÄ£¬´ó¼Ò¿ÉÒÔͨ¹ýC#ÖеÄDllImportÖ±½Óµ÷ÓÃÕâЩ¹¦ÄÜ¡£
¡¡¡¡DllImportËùÔÚµÄÃû×Ö¿Õ¼ä using System.Runt ......