[ת]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 += @" (
Ïà¹ØÎĵµ£º
Õ⼸Ìì°ïͬѧ×öÒ»¸öСµÄ¹ÜÀíϵͳ£¬B/S½á¹¹µÄ£¬ÓÉÓںܾÃûÓÐ×öB/S½á¹¹µÄ¶«Î÷ÁË£¬×öµÄʱºòºÜÉúÊè¡£Ò»¸öÏÂÎ磬Óöµ½ÁËÒ»¸öÎÊÌ⣺ÍùAccessÀï²åÈëÊý¾ÝµÄʱºò£¬ÀÏÊÇÌáʾÎÒsqlÓï¾ä´íÎ󣬵«ÊǾͺÜÄÉÃÆÁË£¬ÕâÖÖsqlÓï¾äдÁ˲»ÏÂ500±éÁ˰ɣ¬¾ÍËãÊÇ×öÃÎÒ²²»»áд´íµÄ£¬Ôõô»ØÊ£¿sqlÓï¾ ......
Ê×Ò³£º
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head ......
ÈÕÆÚ/ʱ¼ä
CDate ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1& ......
ÕâÊÇÒ»¸öÓйطÖÒ³µÄʵÀý,½ö¹©²Î¿¼(´úÂëÀ´×ÔÍøÂç)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;
using System.Threading;
using System.Collections;
us ......
public static void Main()
{
WebRequest req = WebRequest.Create("http://blog.csdn.net/xiaofengsheng");
try
& ......