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,¾Í¿ÉÒÔ½âÕâ¸öÎÊÌâÁË!
Ïà¹ØÎĵµ£º
ÓÉÓÚÐèҪʵÏÖÒÔϹ¦ÄÜ£º
Íø¹ØÍ¨¹ý´®¿Ú·¢ËÍÊý¾Ý¸øPC»ú£¬PC»úÊÕ¼¯Êý¾Ý²¢½âÎö±£´æµ½MySQLÖУ¬È»ºóJSPÒ³Ãæ¶ÁÈ¡MySQLÖеÄÊý¾Ý²¢ÏÔʾ¡£
ËùÒÔÀûÓÃC#Á¬½ÓMySQLÊý¾Ý³ÉΪÁ˱ØÐëÒª¾¹ýµÄ¹ý³Ì£¬Ôڴ˸øÓèÏêϸµÄ˵Ã÷¡£
1¡¢ÏÂÔØÐèÒªµÄÎļþMySQLDriverCS£¬ÏÂÔØµØÖ·Îª£ºhttp://sourceforge.net/projects/mysqldrivercs
2¡¢°²×°Îļþ£ºMySQ ......
ǰһ¶Îʱ¼äÊÔ×ÅÓÃÕâÈýÖÖÓïÑÔ¼òµ¥µÄдÁ˹ØÓÚÎļþ¿½±´µÄ³ÌÐò£¬·¢ÏÖc#ºÍpythonµÄapi¾ªÈ˵ÄÏàËÆ£¬¶ÔÓÚÎļþµÄ²Ù×÷ÕâÁ½ÖÖÓïÑԷdz£µÄ·½±ã¡£¶¼Ã»ÓмÓÒì³£µÄ´¦Àí
C#Ô´´úÂ룺
public static void CopyFile(string source, string destination)
& ......
ºÅ³ÆxmlhelperµÄÒ»¸öÀà
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Xml;
namespace WebApplication2
{
/// <summary>
/// XMLHelper XMLÎĵµ²Ù×÷¹ÜÀíÆ÷
/// </summary>
public class XMLHelper
{
public X ......
MSSQL:
declare @begin datetime
declare @End datetime
set @begin=getdate()
--Ö´ÐеÄÓï¾äдÔÚÕâÀï
set @End=getdate()
select datediff(millisecond,@begin,@End) as Ö´ÐеÄʱ¼ä
--millisecond±íʾºÁÃë Èç¹û¿´Ãë¿ÉÒÔʹÓÃss
C#:
ºÜ¶àʱº ......
½ñÌìÓõ½Õâ¸ö£¬ÍøÉÏÕÒ¸ö²»´íµÄ£¬±£´æÏÂÀ´¡£
×¢Ò⣺Õâ¸ö·½·¨ÊÇ¿ìËٹػú£¬²»»á±£´æÄãµÄÈκÎδ±£´æÐÅÏ¢¡£
// Õâ¸ö½á¹¹Ì彫»á´«µÝ¸øAPI¡£Ê¹ÓÃStructLayout
[StructLayout(LayoutKind.Sequential, Pack = 1)]
internal struct TokPriv1Luid
{
public int Count;
public ......