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

[ת]C#.net±à³Ì´´½¨ Access ÎļþºÍ Excel Îļþ

һЩϵͳ¿ÉÄÜÐèÇó°ÑÊý¾Ýµ¼³öµ½Access»òÕßExcelÎļþ¸ñʽ£¬ÒÔ·½±ãµÄ´«µÝÊý¾Ý¡¢´òÓ¡µÈ¡£
Excel Îļþ»òÕß AccessÕâÁ½ÖÖÐèÒªµ¼³öµÄÎļþ¿ÉÄܲ¢²»ÊÇÊÂÏȾʹæÔڵģ¬Õâ¾ÍÐèÒªÎÒÃÇ×Ô¼º±à³ÌÉú³ÉËûÃÇ£¬ÏÂÃæÕûÀíÒ»ÏÂÉú³ÉÕâÁ½¸öÎļþµÄһЩ·½·¨£¬Ö»ÂÞÁÐ×î³£Óõġ£²¢²»È«¡£
Ò»¡¢Ê×ÏÈÉú³ÉExcelÎļþ¡£
    ·½°¸Ò»¡¢Èç¹ûÓÃExcel±£´æµÄÖ»ÊǶþάÊý¾Ý£¬Ò²¾ÍÊǰÑËûµ±Êý¾Ý¿âµÄÀ´Óá£
×î¼òµ¥£¬Äã²»ÓÃÒýÓÃÈκζîÍâ×é¼þ£¬Ö»ÐèÒªÓà OLEDB ¾Í¿ÉÒÔÍê³É´´½¨ExcelÎļþ¡£ ·¶Àý´úÂëÈçÏ¡£
using System.Data.OleDb;
public static void CreateExcelFile2()
  {
   string OLEDBConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\aa2.xls;";  
   OLEDBConnStr +=   " Extended Properties=Excel 8.0;";
   string strCreateTableSQL = @" CREATE TABLE ";
   strCreateTableSQL += @" ²âÊÔ±í ";
   strCreateTableSQL += @" ( ";
   strCreateTableSQL += @" ID INTEGER, ";
   strCreateTableSQL += @" UserID INTEGER, ";
   strCreateTableSQL += @" UserIP VARCHAR , ";
   strCreateTableSQL += @" PostTime DATETIME , ";
   strCreateTableSQL += @" fromParm VARCHAR  ";
   strCreateTableSQL += @" ) ";
   OleDbConnection oConn = new OleDbConnection();
  
   oConn.ConnectionString = OLEDBConnStr;
   OleDbCommand oCreateComm = new OleDbCommand();
   oCreateComm.Connection = oConn;
   oCreateComm.CommandText = strCreateTableSQL;
   oConn.Open();
   oCreateComm.ExecuteNonQuery();
   oConn.Close();
}
using System.Data.OleDb;
public static void CreateExcelFile2()
  {
   string OLEDBConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\aa2.xls;";  
   OLEDBConnStr +=   " Extended Properties=Excel 8.0;";
   string strCreateTableSQL = @" CREATE TABLE ";
   strCreateTableSQL += @" ²âÊÔ±í ";
   strCreateTableSQL += @" (


Ïà¹ØÎĵµ£º

Access ÖÐ×Ô¶¯±àºÅµÄ½â¾ö˼·

ÈçºÎÔÚ Access ÖвåÈëÒ»ÌõеļǼʱ,Ô¤ÏÈÖªµÀËûµÄ×Ô¶¯±àºÅIDÄØ?
Õâ¸öÎÊÌâÀ§ÈÅÁËÎҺܾÃ
ºóÀ´ÎÒÏëÁËÒ»¸öºÜ±¿°ì·¨
¾ÍÊÇÏȲåÈëÒ»Ìõ ËæÒâµÄÊý¾Ý µ±È»ÀïÃæÓÐÓÐÒ»¸öÄãʵÏÖÔ¤¶¨ºÃµÄ±êʶ
±ÈÈç
insert into cmd (classID,cmdType,cmd) values('temp','temp','temp')
È»ºóÕÒµ½Ëü ¶ÁÈ¡ËüµÄID
select * from cmd where classID ......

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......

accessת»»³Émssql·½·¨

1£¬´ò¿ª”¿ØÖÆÃæ°å“Ï”¹ÜÀí¹¤¾ß“ÖеĔÊý¾Ý¿âÔ´“£»
2£¬°´”Ìí¼Ó“Ìí¼ÓÒ»¸öеÄÊý¾ÝÔ´£¬ÔÚÑ¡ÔñÀ¸ÀïÑ¡“Driver do microsoft Access (*.mdb)”£¬Íê³Éºó½«³öÏÖÒ»¸ö¿ò£¬ÔÚ“Êý¾Ý¿âÔ´”ÀïÃæÊäÈëÄãÏëдµÄÃû³Æ£¬ÎÒÈ¡Ãû½Ð“ABC”£¬ËµÃ÷²»ÐèÒªÌ½Ó×Å ......

C#: ÌáÈ¡ÍøÒ³ÖеÄjavascript´úÂë

public static void Main()
        {
            WebRequest req = WebRequest.Create("http://blog.csdn.net/xiaofengsheng");
            try
  & ......

¼Ü¹¹B/SËÄ DALFactory Êý¾Ý·ÃÎʲã Data Access Layer

2008-04-10 09:45 //*******FactoryManage.cs using System;
using System.Reflection;
using System.Configuration;
using CoalTraffic.IDAL; namespace CoalTraffic.DALFactory
{
    /// <summary>
    /// ³éÏ󹤳§Ä£Ê½´´½¨DAL¡£
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ