Çë¸ßÊÖ¸øÒ»¸ö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
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......