·¹ýµÄ´óϺÃÇ£¬°ï°ïСµÜÎÒ°É£¬Ò»¸ö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
Ïà¹ØÎÊ´ð£º
Ϊʲô¹¤¾ßÀ¸°´Å¤µÄ¿í¶È¸Ä±ä²»ÁË,ÔÚÊôÐÔÀï¸ÄÁËÓÖ±ä³ÉÔÀ´µÄÊýÖµÁË
´óºú×ÓÕæÀ÷º¦£¬»Ø´ð»ù±¾¶¼ÊDZ¬Áϼ¶µÄ
´óºú×ÓÉý¼¶Õæ¿ì°¡£¬Õâ²Å¼¸Ìì¾Í5Ìõ¶Ì¿ãÍâ¼ÓÔÂÅÅÃûµÚÒ»ÁË
ÏëÏëÎÒÕâ5¸ö¶Ì¿ã»ìÁ˲¶à8Äê²ÅµÃµ½µÄ¡£
»Ø¸´ ......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ ......
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡
Óû§ÃûÊÇΨһµÄ
±íA ×Ö¶Î
Óû§Ãû£ºName ,ÓÊÏ䣺Ema ......
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
±¾ÈËʹÓõÄÊÇVB6.0°æ±¾
¼ÙÉèÓÐÒ»¸ö¶ÔÏóA£¬AÄÚÓÐÀàÐÍΪBµÄ¶ÔÏóÊôÐÔ¡£ÏÖÔÚµÄÎÊÌâÊÇ£¬ÐèÒªÌí¼ÓÈô¸É¸öB¶ÔÏó×÷ΪA¶ÔÏóµÄÊôÐÔ¡£È磬
A.B1,A.B2,...
µ«¾ßÌåÌí¼Ó¶àÉÙ¸öB¶ÔÏó×÷ΪA¶ÔÏóµÄÊôÐÔÔòÊÓ¾ßÌåÇé¿ö²»Í¬¶ø²»Í¬ ......