Znn3bq.jpeg
²é¿´: 2346  |  »Ø¸´: 7
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

zzahkj

ľ³æ (ÖøÃûдÊÖ)

Áú

[½»Á÷] ¡¾ÇóÖú¡¿vb.netµÄDataGridViewÈçºÎ±à¼­ºó±£´æµ½AccessÊý¾Ý¿âÖУ¿ ÒÑÓÐ2È˲ÎÓë

vb.netµÄDataGridViewÈçºÎ±à¼­ºó±£´æµ½Êý¾Ý¿âÖУ¿ÎÒÏÖÔÚÒѾ­ÊµÏÖÊý¾Ý±íÔÚDataGridViewÖÐÏÔʾÁË£¬¿ÉËæ±ã¶ÔÒ»¸öµ¥Ôª¸ñ½øÐб༭ºóÈ´ÎÞ·¨±£´æµ½Ô­À´µÄAccessÊý¾Ý±íÖУ¬Çó¸ßÊÖÖ¸µã£¬¸øÒ»¶Î´úÂ룿лл£¡  ¸ø¶ÎVB´úÂëÒ²Ðа¡£¡
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

²»ÒªÃÔÁµ¸ç£¬¸çÖ»ÊÇÒ»¸ö¹ý¿Í£¡
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zzahkj

ľ³æ (ÖøÃûдÊÖ)

Áú

¡ï
dubo(½ð±Ò+1): »¶Ó­³£À´³ÌÐòÓïÑÔ°æÌÖÂÛ 2011-07-31 13:49:40
ÒýÓûØÌû:
Originally posted by libralibra at 2011-03-05 01:04:38:
adoÁ´½ÓÊý¾Ý¿â
Ð޸ĺóupdate¾ÍÐÐÁË,ÄãµÃÓÃsqlÓï¾ä

ÎÒÊÇÕâÑù±àдµÄ
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        Dim Adapter As New OleDb.OleDbDataAdapter("Select   *   From   huaxue ", AAADataSet1)
        Dim Bulid As New OleDb.OleDbCommandBuilder(Adapter)
      
        Try
            shujubiaoadapter.Update(DataGridView1.DataSource)
            'Recorder.Update(Dt,   "Db "
            'Dt.AcceptChanges()
        Catch ex As Exception
            Console.WriteLine(ex.Message)
            MsgBox("Êý¾Ý±£´æÊ§°Ü! " & vbCrLf & ex.Message.ToString, MsgBoxStyle.Critical)
        Finally
            shujubiaoadapter.Dispose()
            Bulid.Dispose()

        End Try
    End Sub
End Class
È»ºó³öÏÖ´íÎó 1 ÖØÔØ¾ö²ßʧ°Ü£¬Ô­ÒòÊÇûÓпɷÃÎʵġ°New¡±¿ÉÒÔÓÃÕâЩ²ÎÊýµ÷ÓÃ:
    'Public Sub New(selectCommandText As String, selectConnection As System.Data.OleDb.OleDbConnection)': ÀàÐÍ¡°Êý¾Ý¿â_ʵÑé.AAADataSet1¡±µÄÖµÎÞ·¨×ª»»Îª¡°System.Data.OleDb.OleDbConnection¡±¡£
    'Public Sub New(selectCommandText As String, selectConnectionString As String)': ÀàÐÍ¡°Êý¾Ý¿â_ʵÑé.AAADataSet1¡±µÄÖµÎÞ·¨×ª»»Îª¡°String¡±¡£ F:\¸´¼þ ¸´¼þ Êý¾Ý¿â-ʵÑéoo\»­Í¼-ʵÑé\Form1.vb 228 13 Êý¾Ý¿â-ʵÑé
ÕâÊÇÔõô»ØÊ£¿¸ÃÈçºÎ½â¾ö£¿
²»ÒªÃÔÁµ¸ç£¬¸çÖ»ÊÇÒ»¸ö¹ý¿Í£¡
3Â¥2011-03-05 09:22:47
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 8 ¸ö»Ø´ð

libralibra

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

æôÆï½«¾ü

¡ï ¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
ÓàÔó³É(½ð±Ò+2): ллӦÖú£¡ 2011-03-07 21:55:46
adoÁ´½ÓÊý¾Ý¿â
Ð޸ĺóupdate¾ÍÐÐÁË,ÄãµÃÓÃsqlÓï¾ä
matlab/VB/python/c++/Javaд³ÌÐòÇë·¢QQÓʼþ:790404545@qq.com
2Â¥2011-03-05 01:04:38
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

libralibra

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)

æôÆï½«¾ü

¡ï ¡ï ¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
ÓàÔó³É(½ð±Ò+3): ÐÁ¿àÁË£¡ 2011-03-07 21:56:05
¸øÄãÒ»¶ÎÎÒ¹ýÈ¥µÄvb´úÂë,vbÁ¬½ÓaccessµÄ,ÓÃadodb,ºÜ·½±ã
´úÂë±È½Ï³óª,´ÕºÏ¿´°É,ÊǸö×ÔÓõÄͨѶ¼³ÌÐò
txlÊDZíÃû,Mobile,QQ,MSN...¶¼ÊÇ×Ö¶ÎÃû³Æ
CODE:
'½«Áбí¿òÄÚÈÝÖðÏî¼ÓÈëÊý¾Ý¿â,´´½¨¸üÐÂsql×Ö´®
sqlString = "update txl set Mobile='" & Trim$(txt(1).Text) & "',QQ='" & _     Trim$(txt(2).Text) & "',MSN='" & Trim$(txt(3).Text) & "',Email='" & Trim$(txt(4).Text) & "',Phone='" _     & Trim$(txt(5).Text) & "',Home='" & Trim$(txt(6).Text) & "',Birthday='" & txt(7).Text & "',Address='" _     & Trim$(txt(8).Text) & "',Postcode='" & Trim$(txt(9).Text) & "',Info='" & Trim$(txt(10).Text) & _     "' where Name='" & Trim$(ListView1.ListItems.Item(SelectIndex).Text) & "'"

'¸üмǼ
Set rs = conn.Execute(sqlString, , adCmdText)

Òª´´½¨È«¾Ö±äÁ¿
CODE:
Dim conn As ADODB.Connection 'Êý¾Ý¿âÁ¬½Ó

È»ºóformÔÚloadµÄʱºò´ò¿ªÁ´½Ó,¿ÉÒÔ²Ù×÷Êý¾Ý¿â
CODE:
'Á¬½ÓÎÞÃÜÂëÊý¾Ý¿â
Set conn = New ADODB.Connection
    conn.ConnectionString = _
        "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & dbName & ";" & _
        "Persist Security Info=False"

'´ò¿ªÁ¬½Ó
conn.Open

[ Last edited by libralibra on 2011-3-7 at 20:29 ]
matlab/VB/python/c++/Javaд³ÌÐòÇë·¢QQÓʼþ:790404545@qq.com
4Â¥2011-03-07 20:24:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zzahkj

ľ³æ (ÖøÃûдÊÖ)

Áú

ÒýÓûØÌû:
Originally posted by libralibra at 2011-03-07 20:24:31:
¸øÄãÒ»¶ÎÎÒ¹ýÈ¥µÄvb´úÂë,vbÁ¬½ÓaccessµÄ,ÓÃadodb,ºÜ·½±ã
´úÂë±È½Ï³óª,´ÕºÏ¿´°É,ÊǸö×ÔÓõÄͨѶ¼³ÌÐò
txlÊDZíÃû,Mobile,QQ,MSN...¶¼ÊÇ×Ö¶ÎÃû³Æ


[code]'½«Áбí¿òÄÚÈÝÖðÏî¼ÓÈëÊý¾Ý¿â,´´½¨¸üÐÂsql×Ö´®
sqlS ...

ллÄãµÄ»Ø´ð£¬¿ÉÊÇÎÒÏëÔÚDataGridViewÉÏÖ±½ÓÐÞ¸ÄÊý¾ÝÈ»ºóͨ¹ý°´Å¥±£´æµ½Ô­À´µÄÊý¾Ý¿âÉÏ£¬ÎÒ²»ÖªµÀ¸ÃÈçºÎ×ö£¿ÎÒ¸Õ½Ó´¥Õâ¸ö£¬»¹ºÜ²Ë£¡
²»ÒªÃÔÁµ¸ç£¬¸çÖ»ÊÇÒ»¸ö¹ý¿Í£¡
5Â¥2011-03-07 23:06:58
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] È˹¤ÖÇÄÜ320µ÷¼Á08¹¤À໹Óлú»áÂð +3 Õñ¡ªTZ 2026-04-10 3/150 2026-04-10 11:32 by wp06
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +13 Ò»ÑùYWY 2026-04-04 13/650 2026-04-10 11:07 by mattzhming
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤300Çóµ÷¼Á +30 Ф¿ªÎÄ 2026-04-09 32/1600 2026-04-10 10:59 by ×ÏÒí¾«Áé
[¿¼ÑÐ] ²ÄÁÏ»¯¹¤×Ü·Ö334Çóµ÷¼Á +16 Riot2025 2026-04-08 17/850 2026-04-09 20:19 by maddjdld
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤301·ÖÇóµ÷¼ÁԺУ +33 ´ÌÍ´jk 2026-04-06 34/1700 2026-04-09 18:31 by hy861222
[¿¼ÑÐ] 291·Öµ÷¼Á +3 Éϰ¶Ð¡Ó¨¼ÓÓÍ 2026-04-09 4/200 2026-04-09 17:28 by 1753564080
[¿¼ÑÐ] 348Çóµ÷¼Á +3 candyyyi 2026-04-09 3/150 2026-04-09 17:20 by ¶ÎΰÑÞ
[¿¼ÑÐ] µ÷¼Á +12 ÔÂ@163.com 2026-04-08 12/600 2026-04-09 14:27 by rl1980
[¿¼ÑÐ] 070300»¯Ñ§279Çóµ÷¼Á +17 ¹þ¹þ¹þ^_^ 2026-04-08 18/900 2026-04-09 10:49 by ÈýÆßÆßÏëÉϰ¶
[¿¼ÑÐ] 327Çóµ÷¼Á +10 Xxjc1107. 2026-04-06 11/550 2026-04-09 01:21 by lature00
[¿¼ÑÐ] 293·ÖÇóµ÷¼Á£¬ÍâÓïΪ¶íÓï +7 ¼ÓÒ»Ò»¾Å 2026-04-07 10/500 2026-04-08 20:14 by yutian743
[¿¼ÑÐ] 298Çóµ÷¼Á +4 manman511 2026-04-05 4/200 2026-04-08 16:50 by tjzhao
[¿¼ÑÐ] 312Çóµ÷¼Á +18 gtw1 2026-04-06 20/1000 2026-04-07 18:16 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 0854Çóµ÷¼Á +9 ºàÊÏ·¬ÇÑɳ˾ 2026-04-06 10/500 2026-04-07 14:37 by shdgaomin
[¿¼ÑÐ] 312Çóµ÷¼Á +4 LR6 2026-04-06 4/200 2026-04-07 08:42 by jp9609
[¿¼ÑÐ] 0854Çóµ÷¼Á +4 assdll 2026-04-05 4/200 2026-04-06 12:29 by ÖзÉÔº¿Õ¹ÜѧԺÑ
[¿¼ÑÐ] 315Çóµ÷¼Á +5 £¦123456789 2026-04-05 5/250 2026-04-05 19:55 by nepu_uu
[¿¼ÑÐ] Çóµ÷¼Áµ½0856²ÄÁϹ¤³Ì +3 ³Ì9915 2026-04-05 3/150 2026-04-05 18:15 by À¶ÔÆË¼Óê
[¿¼ÑÐ] ÄÐÉú£¬Ò»Ö¾Ô¸»¦9ÉúÎïѧ071000£¬³õÊÔ308Çóµ÷¼Á +3 Áõīī 2026-04-04 3/150 2026-04-05 08:26 by barlinike
[¿¼ÑÐ] 305Çóµ÷¼Á +3 77Qi 2026-04-03 3/150 2026-04-03 23:01 by qzxyhcsy
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û