һֱʹÓÃVB£¬¾õµÃme¹Ø¼ü×ֺܺÃÓã¬me.һϴ°ÌåµÄËùÓпؼþ¶¼»á³öÀ´¡£
ÏÖÔÚ¸Õ¿ªÊ¼Ñ§Ï°C£££¬ºÃÏñËýµÄthis¹Ø¼ü×ÖºÍVBµÄme²î²»¶à¡£ÊÇ·ñÊÇÕâÑù£¿this»¹ÓÐʲô×÷Ó㿺ÍÀàµÄ¸ÅÄîÓÐʲô¹Øϵ£¿Çë¸ßÊÖ»òÀÏÄñ¸ø½éÉܽéÉÜ¡£
thisºÍme²î²»¶àµÄ£¬thisÓÃÓÚÖ¸´úµ±Ç°¶ÔÏóʵÀý£¬Òò´Ë²»ÄÜÓÃthis¹Ø¼ü×Ö·ÃÎʾ²Ì¬¶ÔÏó¡£
vbÀïµÄMyºÍMeȷʵͦ¿â ......
²Ù×÷Êý¾Ý¿âʱ£¬ÁÐÊDZäÁ¿£¬ÈçÏÂ
OleDbCommand myCmd = new OleDbCommand();
myCmd.CommandText = "insert into users(" + item + ") values('" + direction + "')";
item ºÍ direction ¶¼ÊǶ¨ÒåµÄstring,µ«ÊÇÓöµ½Ò»¸öÎÊÌâ,insert²»ÄÜÓÃwhere,¸ÄÓÃupdata,µ«²»ÖªÁÐÊDZäÁ¿µÄʱºòupdata ......
c# + sqlite ³ö´í£¡£¡£¡
File opened that is not a database file
file is encrypted or is not a database
ºÍÒÔÇ°Ò»ÑùµÄд£¬ÔõôÕâ´Î¾ÍÊDz»Ðа¡£¡£¡£¡
ÎÒ¿ì²»ÐÐÁË£¬´ó¼Ò°ï°ïÎÒ°¡£¡£¡£¡
¼û¹ýһƪÎÄÕÂÊÇ˵Õâ¸ö
´íÎóºÃÏñÊÇ°ÑÃÜÂëÈ¥µôµÄÔÒò£¬½â¾ö·½°¸ÈçÏ£º
1. ¿ÉÒÔʹÓÃSQLiteConnectionStringBuilderÀ๹½¨Á´½ ......
ÒòΪ²»ÖªµÀÈçºÎ¼ÓÈ븽¼þÎÒ¾ÍÊÖдEXCELÊý¾ÝÁË¡£
C# code:
A B C D E F G £¨´ËÀ¸Î»EXCELÖÐROWÐУ¬µÚÒ»ÐÐÊý×ÖÒàÈ»£©
1 ʵÀý±êÌâ
2 by name
3 ¿ÆÄ¿ ±¸註 ³É¼¨
4 Ó¢Óï 89
5 Êýѧ 80
6 ¼ÆËã»ú ¶þ¼¶ 89
7 Èý¼¶ 70
8
ʵÀý±êÌ⣺CDEºÏ ......
½«ÏÖÓбíÖеÄÊý¾Ý£¬Ìí¼Óµ½Ã»Óд´½¨µÄÁíÒ»¸ö±í
Ôõô¶¼µÃ´´½¨Ò»¸öÁÙʱ±í°É£¬Òª²»È»insert¶¼²»ÕÒ²»µ½²Ù×÷¶ÔÏóµÄ£¡
create table newtable(×Ö¶Î1£¬×Ö¶Î2£¬×Ö¶Î3...)
insert into newtable
select ×Ö¶Î1£¬×Ö¶Î2£¬×Ö¶Î3...
from oldtable
ÏȽ«ÒÔÇ°µÄ±íÉú³É½Å±¾ÓïÑÔ£¬È»ºóÔÙ²éѯ·ÖÎöÆ÷ÖÐÔËÐнű¾ÓïÑÔ£¬ÔÙinsert½øÈ¥¾Í ......
ÏÂÃæÊÇVBÖеĴúÂë
Public Delegate Sub EventHandler(ByVal sender As Object, ByVal e As EventArgs)
Public my_eh As EventHandler
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'winceÏÂʵÀý
my_eh = New EventHa ......