winformµ¼Èëexcelµ½accessÊý¾Ý¿âÖÐ
ÏîÄ¿ÖÐÓõ½Á˴˹¦ÄÜ¡£°Ñ´ó¸Å×ö·¨¸ú´ó¼Ò¹²ÏíÏ£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£Ò²¸ø×Ô¼º×ܽáһϣ¬¼¤Àø×Ô¼ºÔÙ½ÓÔÙÀ÷¡£ÏÂÃæÖв¿·Ö´úÂë±»ºº×ÖÌæ»»ÁË£¬Ö÷Òª¿¼Âǵ½¹«Ë¾µÄ²úƷȨ£¬Ï£ÍûÁ½⡣
/// <summary>
/// µã»÷´ò¿ª°´Å¥
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOpen_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "ExcelÎļþ(*.xls)|*.xls";
//±êÌâ
ofd.Title = "´ò¿ª";
//¶àÑ¡
ofd.Multiselect = false;
//ĬÈÏÖµ
ofd.FilterIndex = 1;
ofd.InitialDirectory = System.AppDomain.CurrentDomain.BaseDirectory;
&
Ïà¹ØÎĵµ£º
ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+ ......
http://www.cnblogs.com/byeday/archive/2009/10/04/1578034.html
ÎÊÌ⣺“Failed to access IIS metabase”½â¾ö
2009-08-14 17:03
ÔÒò£ºIISûÓÐ×¢²á
½â¾ö°ì·¨£º
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ ......
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
sqlserver£ºupdate Table_A set Table_A.col1 = (select Table_B.col1 from Table_B where Table_A.col2 = Table_B.col2)
Access: UPDATE Table_ A, Table_B SET Table_ A.×Ö¶Î2 = Table_ B.×Ö¶Î2
WHERE Table_ A.񅧏=Table_ A.񅧏;
×Ô¼º¼ÇÏ£¬ÌáÐÑ×Ô¼º ......