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

·¹ýµÄ´óϺÃÇ£¬°ï°ïСµÜÎÒ°É£¬Ò»¸öVB+SQLµÄÎÊÌâ

Êý¾Ý¿âѧ¼®¹ÜÀíÀïÓÐÈýÕÅ±í£º
±íXS°üÀ¨×ֶΣº ѧºÅ£¬ÐÕÃû£¬×¨Òµ£¬ÐԱ𣬳öÉúÈÕÆÚ£¬×Üѧ·Ö£¬±¸×¢
±íXSKC°üÀ¨×ֶΣºÑ§ºÅ£¬ÐÕÃû£¬¿Î³ÌÃû£¬³É¼¨£¬×Üѧ·Ö£¬×¨Òµ
±íKC°üÀ¨×ֶΣº רҵ£¬¿Î³ÌÃû

´°Ìåform1ÀïÓиöDatagrid¿Ø¼þ£¬±àд¿Ø¼þË«»÷ʼþÈçÏ£¬µ¯³ö´°Ìåshowstukc,´°ÌåshowstukcÉÏÓÐÁ½¸ö¿Ø¼þ£¬ADODCºÍDatagrid,Ãû×Ö·Ö±ðÊÇstukcado,studg¡£
ÎÒÏëʵÏÖ¹¦ÄÜÊÇ£¬Ë«»÷form1ÖеÄdatagrid¿Ø¼þ£¬µ¯³ö´°Ìåshowstukc£¬µ¯³ö´°ÌåÖÐÏÔʾ²éѯÐÅÏ¢£¬´úÂëÈçÏ£º

Private Sub DataGrid1_DblClick()
showstukc.stukcado.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=ѧ¼®¹ÜÀí"    'ADODCÖÐÉú³É×Ö·û´®Õ³ÔÚÒýºÅÖмä
showstukc.stukcado.RecordSource = "select XS.ѧºÅ,XS.ÐÕÃû,KC.¿Î³ÌÃû,XSKC.³É¼¨,KC.רҵ from XS,XSKC,KC where XSKC.¿Î³ÌÃû=KC.¿Î³ÌÃû and XSKC.רҵ=KC.רҵ and XS.ѧºÅ='" + stuado.Recordset.Fields("ѧºÅ") + "'"
showstukc.stukcado.Refresh
Set showstukc.studg.DataSource = showstukc.stukcado
showstukc.Show
End Sub


ÎÒÔËÐв»ÕýÈ·£¬VBÏÔʾʵʱ´íÎó424£¬ÒªÇó¶ÔÏ󣬿ÉÊÇÎÒ²»ÖªµÀÄÄÀï³öÏÖÎÊÌâÁË£¬¸÷λ´óϺ°ï°ïÎÒ°É£¬ÏÖÔÚ¶¼¼±µÃÎÒÕâôÍíÁË˯²»×ŽÌѽ~~
ÄÄÒ»¾ä³ö´í£¿


.net ϲ»ÊǺÜÊì
Set showstukc.studg.DataSource = showstukc.stukcado
¶ÔÂð£¿

»¹ÕæÊǶþ¥˵µÄÄÇÑù°¡£¬È·ÊµÊǿؼþÃû²»Ò»Ö£¬ÎÒ¸ÄÁËһϣ¬³ÉÁË~~

²»¹ýÏÖÔÚÓÖÓÐÎÊÌâÁË£¬Âé·³Äã°ï濴һϰɣ¬Ð»Ð»ÁË0.0
Dim sqlstr As String
Publ


Ïà¹ØÎÊ´ð£º

ΪʲôÓÃVB¸Ä±ä²»Á˹¤¾ßÀ¸°´Å¤µÄ¿í¶È - VB / ¿Ø¼þ

Ϊʲô¹¤¾ßÀ¸°´Å¤µÄ¿í¶È¸Ä±ä²»ÁË,ÔÚÊôÐÔÀï¸ÄÁËÓÖ±ä³ÉÔ­À´µÄÊýÖµÁË

´óºú×ÓÕæÀ÷º¦£¬»Ø´ð»ù±¾¶¼ÊDZ¬Áϼ¶µÄ
´óºú×ÓÉý¼¶Õæ¿ì°¡£¬Õâ²Å¼¸Ìì¾Í5Ìõ¶Ì¿ãÍâ¼ÓÔÂÅÅÃûµÚÒ»ÁË
ÏëÏëÎÒÕâ5¸ö¶Ì¿ã»ìÁ˲¶à8Äê²ÅµÃµ½µÄ¡£

»Ø¸´ ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......

sql ´æ´¢¹ý³Ì

ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡

Óû§ÃûÊÇΨһµÄ
±íA  ×Ö¶Î
Óû§Ãû£ºName  ,ÓÊÏ䣺Ema ......

sql º¯ÊýÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô

select parsen ......

vbÖÐÈçºÎʵÏÖ¶ÔÏóÊôÐԵĶ¯Ì¬ÉèÖà - VB / »ù´¡Àà

±¾ÈËʹÓõÄÊÇVB6.0°æ±¾
¼ÙÉèÓÐÒ»¸ö¶ÔÏóA£¬AÄÚÓÐÀàÐÍΪBµÄ¶ÔÏóÊôÐÔ¡£ÏÖÔÚµÄÎÊÌâÊÇ£¬ÐèÒªÌí¼ÓÈô¸É¸öB¶ÔÏó×÷ΪA¶ÔÏóµÄÊôÐÔ¡£È磬
 A.B1,A.B2,...
µ«¾ßÌåÌí¼Ó¶àÉÙ¸öB¶ÔÏó×÷ΪA¶ÔÏóµÄÊôÐÔÔòÊÓ¾ßÌåÇé¿ö²»Í¬¶ø²»Í¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ