Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

SQLServer ά»¤Ë÷ÒýʵÏÖ²éѯÓÅ»¯

Ë÷Òý·ÖΪÁ½´óÀà:¾Û¼¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷Òý
Ò»¡¢¾Û¼¯Ë÷Òý
µ±Êý¾Ý±íÖеÄÒ»Áб»È·¶¨ÎªÖ÷¼üºó,SQLServer»á×Ô¶¯ÎªËü½¨Á¢¾Û¼¯Ë÷Òý,ÒòΪ¾Û¼¯Ë÷ÒýÊDZêʶÿ¸ö¼Ç¼Ðеļü,ËùÒÔËü½«±»Ó¦Óõ½Ã¿¸ö²éѯÖÐ.
¶þ¡¢·Ç¾Û¼¯Ë÷Òý
·Ç¾Û¼¯Ë÷ÒýµÄÇé¿ö¾Í±È½Ï¸´ÔÓÁË,ÒòΪËüÊÇÏà¶ÔÓÚ±í¶ÀÁ¢×éÖ¯µÄ,ÔÚSQLServerÖÐÓе¥¶ÀµÄ½á¹¹À´´æ´¢·Ç¾Û¼¯Ë÷Òý.
 
......

C#»ù´¡ÎÊÌâ

Èç¹ûÄãµÄ¼òÀúÉÏÃæÐ´“ÊìϤ/Á˽âC#”£¬ÄÇôÄã¾ÍÓ¦¸ÃÄܹ»»Ø´ðÏÂÃæµÄÕâЩ»ù´¡ÎÊÌâ¡£
´«Èëij¸öÊôÐÔµÄset·½·¨µÄÒþº¬²ÎÊýµÄÃû³ÆÊÇʲô£¿
value£¬ËüµÄÀàÐͺÍÊôÐÔËùÉùÃûµÄÀàÐÍÏàͬ¡£
ÈçºÎÔÚC#ÖÐʵÏּ̳У¿
ÔÚÀàÃûºó¼ÓÉÏÒ»¸öðºÅ£¬ÔÙ¼ÓÉÏ»ùÀàµÄÃû³Æ¡£
C#Ö§³Ö¶àÖØ¼Ì³Ðô£¿
²»Ö§³Ö¡£¿ÉÒÔÓýӿÚÀ´ÊµÏÖ¡£
±»protecte ......

C#±àдCom×é¼þ

1¡¢Ð½¨Ò»¸öÀà¿âÏîÄ¿
2¡¢½«Class1.cs¸ÄΪÎÒÃÇÏëÒªµÄÃû×Ö
ÎÊÊÇ·ñͬʱ¸øÀà¸ÄÃû£¬È·¶¨
3¡¢ÐÞ¸ÄPropertiesĿ¼ÏÂÃæµÄAssemblyInfo.cs
ComVisibleÊôÐÔÉèÖÃΪTrue
4¡¢ÏîÄ¿²Ëµ¥->MyLibÊôÐÔ
ÕÒµ½“Éú³É”Ñ¡Ï
ÍùÏ¿´£¬ÕÒµ½“Ϊ COM Interop ×¢²á”¹´ÉÏ
5¡¢¼ÌÐøÍùÏ£¬ÕÒµ½“Ç©Ãû&rdqu ......

java ºÍ C# ͨÓüÓÃܽâÃÜ

java ´úÂë
package util;
import java.io.UnsupportedEncodingException;
import dao.socket.OperType;
public class Encrpt {
 private String key;
 public Encrpt() {
  this("sitow");
 }
 public Encrpt(String key) {
  this.key = key;
 }
 private ......

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.È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ