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

Çë¸ßÊÖ¸øÒ»¸öaccessÌí¼ÓÒ»¸ö¿ÉÒÔΪnullµÄ×ֶεĴúÂë

ÈçÌ⣬ÔÚaccessÖÐÌí¼ÓÒ»¸ö¿ÉÒÔΪnullµÄ×ֶδúÂëÔõôд£¿
°ÑÊý¾Ý×Ö¶ÎÉèÖÃΪ ÔÊÐíΪ¿Õ


¾ÍÐÐÁË

Èç¹ûÄãµÄÊý¾Ý¿âÖиÃ×Ö¶ÎΪ·Ç¿ÕÏîÄ¿£¬¶øÄãÓÖÏëÍùÀïÃæÈëÒ»¸ö¿ÕÖµ¡£ÄÇôÄã¿ÉÒÔ²åÈëÒ»¸öÕâÑùµÄÖµ£º
DBNull.value


ÒÔÏÂÊÇÎÒÓÃÀ´´´½¨Êý¾Ý¿âµÄ´úÂ룬Êý¾Ý¿âºÍ±í¶¼Äܳɹ¦½¨Á¢¡£×¢Ê͵ôµÄÁ½ÐдúÂë·Ö±ðΪ´´½¨×Ö·ûÐÍ×ֶκÍÉèÖÃij×ֶαØÌîÊôÐԵĴúÂë¡£ÕâÁ½ÐдúÂë¶¼²úÉúÒì³££¬Çë¸ßÊÖÖ¸µã——¸ø³öÕýÈ·´úÂ룬лл£¡
VB.NET code:
Imports ADOX

Public Class Form1
'Ìí¼ÓÒýÓÃ
'Microsoft ActiveX Data Objects 2.x Library
'Microsoft ADO Ext. 2.x for DDL and Security
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cat As Catalog = New Catalog()
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source= NewMDB.ACCdb")
Dim Cn As ADODB.Connection = New ADODB.Connection '¶¨ÒåÁ¬½Ó
Dim myTable As ADOX.Table = New ADOX.Table '¶¨Òåбí

Cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NewMDB.ACCdb") 'Á´½Óµ½Êý¾Ý¿â

myTable.Name = "²âÊÔÏîÄ¿±í" '±íÃüÃû
cat.Tables.Append(myTable) '×·¼Ó±í
With myTable
.Columns.Append("Ö÷¼ü", DataTypeEnum.adInteger) '¸ø±í¡°²âÊÔÏîÄ¿±í¡± ´´½¨Ò»¸öеÄ×ֶΣ¬×Ö¶ÎÃû¡°Ö÷¼ü¡±
.Keys.Append(&q


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

dwr Illegal access to default constructor´íÎó

dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
  <param name="formBean" value="prisonerForm"/>
  < ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......

ÈçºÎÔÚVB.NET´´½¨accessÊý¾Ý¿â£¿

¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ