Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Excel µ¼Èësqlserver c#

using System.Data.SqlClient;
using System.Data.OleDb;
 private void button1_Click(object sender, EventArgs e)
        {
OleDbConnection conn = null;
            try
            {
                string path = "./Users.xls";
                string strConn;
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" + path + ";" +
                "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
                conn = new OleDbConnection(strConn);
                conn.Open();
                string Sql = "select * from [Users$]";
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                OleDbDataAdapter ddp = new OleDbDataAdapter(Sql, conn);
                DataTable dt = new DataTable();
                ddp.Fill(dt);
                ddp.D


Ïà¹ØÎĵµ£º

¡°ASP.NET(C#)Fans¡± QQȺ£º96877690

---------------------------------------
Asp.Net,C#,SQL,JS,WCF,AJAX,¹¤×÷Á÷,WPF,MVC,LINQ,Éè¼ÆÄ£Ê½(¼Ü¹¹)µÈ¼¼ÊõÌÖÂÛ
“ASP.NET(C#)Fans” QQȺ£º96877690
---------------------------------------
²»¹ÜÊÇJ2SE¡¢J2EE»¹ÊÇJ2ME¾´Çë¼ÓÈ룡Eclipse¡¢NetBeans
Java½»Á÷QQ¸ß¼¶ÈºÀ©ÕУº96878255  ......

C# »ñÈ¡µ±Ç°ÊÇÐÇÆÚ¼¸µÄÁ½ÖÖ·½·¨

C#µÄ¹¦ÄܺÜÇ¿´ó£¬È´Ã»ÓÐÖ±½ÓÌá¹©ÃæÏòºº×ÖÎÄ»¯µÄ¿ª·¢ÇãÏò
±ÈÈçÎÒÏÖÔÚҪ˵µÄ»ñÈ¡µ±Ç°µÄÐÇÆÚÎÒÌṩÁ½ÖÖ·½·¨£º
¢Ù£¬DateTime.Now.DayOfWeek £¬²éѯMSDN¿ÉÒÔÖªµÀ¸ÃÊôÐÔ·µ»ØµÄ½á¹ûÊÇ£º
//
        // ÕªÒª:
        //     »ñÈ¡ ......

ÓÃjavaÍê³ÉC#ͬÑùµÄDES¶Ô³Æ¼ÓÃÜ

ÔÚÒ»¸öÏîÄ¿ÖУ¬¿Í»§ÓÃC#ʵÏÖÁËDES¼ÓÃÜ£¬ÓÉÓÚÐèÒªºÍjava·½ÃæµÄ³ÌÐò½øÐÐÊý¾Ý½»»¥£¬ËùÒÔ±ØÐëÅäºÏ½øÐмӽâÃܹ¤×÷¡£¿Í»§ÌṩÁËÃÜÔ¿ºÍÏòÁ¿£¬ÎÒ¿´ÁË¿´´úÂ룬c#×öÕâ¸öÊÂÇ黹Âù¼òµ¥¡£ ÓÃjavaʵÏֹؼüÊÇÎÒ²»×Ö¶ÎÔõôÉèÖÃÏòÁ¿£¬Ò»°ãÓÃCipher¶ÔÏó¶¼ÊÇĬÈÏËæ»úÏòÁ¿¡£¸ãÁËÒ»Õ󣬷¢ÏÖÊÇÓÃIvParameterSpecÕâ¸öÀàÀ´ÉèÖá£ÓÚÊÇÓÐÁËÒÔÏ´ú ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ 
S:select abs(-1) value
O:select abs(-1)  value from dual
2.È¡Õû(´ó) 
S:select ceiling(-1.001) value  
O:select ceil(-1.001)  value from dual
3.È¡Õû£¨Ð¡£© 
S:select floor(-1.001) value  
O:select floor(-1.001)  value from dual
4.È ......

sqlserver »ù´¡ÖªÊ¶´óÕûÀí

                              SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹û ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ