VBÖÐÁí´æÎª¶Ô»°¿òµÄʹÓÃ
ÎÒÒªµ¼Èëµ¼³öÊý¾Ý¿âÎļþ£¬ÔÚµ½´¦µÄʱºòʹÓÃÁí´æÎª¶Ô»°¿ò£¬¾ßÌå´úÂëÊÇÈçºÎʵÏֵģ¿ÎÒÖ±½ÓÓÃcommondialog1.showsaveÖ®ºóµãÁí´æÎªÃ»ÓÐÏìÓ¦£¬ÊDz»ÊÇÒªÌí¼Óʲô´úÂ룿¼±£¡
Áí´æÎªÊ²Ã´¸ñʽµÄÎļþÄãÐèÒª¸æËß´ó¼Ò,дµ½²»Í¬ÀàÐ͵ÄÎļþÖÐÓõ½µÄ´úÂë²»Ò»Ñù
Áí´æÎªMDB£¬±ÈÈ磬ÎÒµ¼ÈëÊý¾Ý¿âµÄ´úÂëÈçÏ£º
VB code:
On Error Resume Next
CommonDialog1.Filter = "Access (*.mdb)|*.mdb|All files (*.*)|*.*"
CommonDialog1.FilterIndex = 1
CommonDialog1.CancelError = True
CommonDialog1.ShowOpen
If Err.Number = 32755 Then '¶Ô»°¿òµ¥»÷ È¡Ïû µÄ´¦Àí
Err.Clear
Exit Sub
End If
fn = CommonDialog1.FileName
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;" & _
"Data Source=" & CommonDialog1.FileName
Adodc1.CursorLocation = adUseClient
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from admin" 'admin»»³ÉÄã¿âÖÐÓеıíÃû
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
ÏÖÔÚÐèÒªÁí´æÎªµÄ´úÂë
commondialog1.showsave¸úcommondialog1.showOpenÒ»Ñù£¬ËüÖ»¸øÄã·µ»ØÂ·¾¶ºÍÎļþÃû£¬¾ßÌåµÄ´ò¿ª»ò±£´æ²Ù×÷£¬¶¼ÊÇÒªÄã×Ô¼ºÐ´´úÂëÀ´Íê³ÉµÄ¡£
´Ócommondialog1.filename ÊôÐÔÖеõ½Â·¾¶ºÍÎļþÃû¡£
×îºÃÊDZðÓÃadodc¿Ø¼þ,¸ÄÓ
Ïà¹ØÎÊ´ð£º
ΪʲôCдµÄDLLÎļþC¡¢PBÄܵ÷ÓÃVB²»Äܵ÷Óã¿
VBÀïΪʲôÓеÄDLLÖ±½Óͨ¹ýÒýÓÿÉÒÔʹÓã¿ÓеÄÐèҪͨ¹ýdeclareÉêÃ÷Íⲿº¯Êý£¿ÕâЩDLLÓÐʲô²î±ð£¿
1¡¢ÎªÊ²Ã´PBÄÜͨ¹ýDECLAREÉùÃ÷¶øVB²»ÐУ¿
2¡¢Èç¹ûÕâ¸ödllÖÐµÄ ......
Ò»¸ö´°Ì壬3¸ödatagrid£¬¹²¼Æ3¸ö±í£¬Ò»¸ö±í¶ÔÓ¦Ò»¸ödatagrid£¬µã»÷datagrid1(´ò¿ª¸Ã´°ÌåʱÒѾ±»¸³Öµ)£¬¸ù¾Ýdatagrid1ÖеÄij¸öÖµ£¬²éѯ±í2ºÍ±í3£¬²¢°Ñ·ûºÏÌõ¼þµÄ·Ö±ð¸³Öµ¸ødatagrid2ºÍdatagrid3£¬ÒªÔõôд
VB ......
ÓÃvb×öºÃµÄÈí¼þ£¬ÏëÒª¼ÓÈë×Ô¶¯Òþ²ØµÄ¹¦ÄÜ£¬ÔÚÄÇÌí¼Ó°¡£¬»¹ÓÐÒþ²ØµÄ´úÂëÄÇÓа¡ ½èÓÃһϠлÁË
·½·¨1
Private Sub Form_Load()
Me.Height = 1 * Screen.TwipsPerPixelY
Me ......