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#,SQL,JS,WCF,AJAX,¹¤×÷Á÷,WPF,MVC,LINQ,Éè¼ÆÄ£Ê½(¼Ü¹¹)µÈ¼¼ÊõÌÖÂÛ
“ASP.NET(C#)Fans” QQȺ£º96877690
---------------------------------------
²»¹ÜÊÇJ2SE¡¢J2EE»¹ÊÇJ2ME¾´Çë¼ÓÈ룡Eclipse¡¢NetBeans
Java½»Á÷QQ¸ß¼¶ÈºÀ©ÕУº96878255 ......
C#µÄ¹¦ÄܺÜÇ¿´ó£¬È´Ã»ÓÐÖ±½ÓÌá¹©ÃæÏòºº×ÖÎÄ»¯µÄ¿ª·¢ÇãÏò
±ÈÈçÎÒÏÖÔÚҪ˵µÄ»ñÈ¡µ±Ç°µÄÐÇÆÚÎÒÌṩÁ½ÖÖ·½·¨£º
¢Ù£¬DateTime.Now.DayOfWeek £¬²éѯMSDN¿ÉÒÔÖªµÀ¸ÃÊôÐÔ·µ»ØµÄ½á¹ûÊÇ£º
//
// ÕªÒª:
// »ñÈ¡ ......
ÔÚÒ»¸öÏîÄ¿ÖУ¬¿Í»§ÓÃC#ʵÏÖÁËDES¼ÓÃÜ£¬ÓÉÓÚÐèÒªºÍjava·½ÃæµÄ³ÌÐò½øÐÐÊý¾Ý½»»¥£¬ËùÒÔ±ØÐëÅäºÏ½øÐмӽâÃܹ¤×÷¡£¿Í»§ÌṩÁËÃÜÔ¿ºÍÏòÁ¿£¬ÎÒ¿´ÁË¿´´úÂ룬c#×öÕâ¸öÊÂÇ黹Âù¼òµ¥¡£ ÓÃjavaʵÏֹؼüÊÇÎÒ²»×Ö¶ÎÔõôÉèÖÃÏòÁ¿£¬Ò»°ãÓÃCipher¶ÔÏó¶¼ÊÇĬÈÏËæ»úÏòÁ¿¡£¸ãÁËÒ»Õ󣬷¢ÏÖÊÇÓÃIvParameterSpecÕâ¸öÀàÀ´ÉèÖá£ÓÚÊÇÓÐÁËÒÔÏ´ú ......
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.È ......
SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹û ......