VB-С問題請½Ì
Private Sub Form_Load()
Call WorkBusying
strRST_SQL = "select PD002 from DGMOCPD where PD001 like '%Í£機%' and PD005=0 group by PD002 order by PD002"
Call SetRSTReadOnly(strRST_SQL)
Combo5.Clear
If Not (rst.BOF And rst.EOF) Then
rst.MoveFirst
Do While Not rst.EOF
Combo5.AddItem CH_STR(rst.Fields(0).Value)
rst.MoveNext
Loop
End If
Combo5.ListIndex = 2
If Combo5.Text <> "" Then
strRST_SQL = "select pf011 from dgmocpf inner join dgmocpd on pf010=pd002 and pd002='" & Combo5.Text & "'"
Call SetRSTReadOnly(strRST_SQL)
If rst.RecordCount > 0 Then
txt1(9).Text = Trim(rst.Fields(0).Value)
Else
txt1(9).Text = ""
End If
Else
txt1(9).Text = ""
End If
Call WorkNormal
End Sub
Òò為Combo5.text為¿É選擇µÄ£¬ txt1(9).TextĬ認為°µÉ«²»¿É選擇¼°Ð޸ģ¬
¸ù據Combo5.text選µÄÖµ帶³öÏà應µÄ說Ã÷(txt1(9).Text)£¬
現ÔÚ´ú碼執ÐÐÖ®ááCombo5.text選擇ÆäËû選項µÄ時ºòtxt1(9).Text沒Óиú༐
Ïà¹ØÎÊ´ð£º
"insert into user1(name,age) values('" & Text1.Text & "','" & Text2.Text & "' )"
ÎÊÌ⣺¶ÔsqlÓï¾äÖе¥¡¢Ë«ÒýºÅÄ£ºý¡£¼ÈÈ» Text1.Text¾Í±íʾ ......
vbÖÐÔõôͨ¹ýxmlÀ´½âÎöÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ¡£
û°ì·¨ÓÃXML½âÎöÊý¾Ý¿âµÄ×Ö¶ÎÖµ£¬³ý·ÇÊý¾Ý¿âÖб£´æµÄÊÇXML¸ñʽµÄ×Ö·û´®Îĵµ¡£
XMLÓÃÀ´Õ¹Ê¾²ã´ÎµÄÊý¾Ý¡£
Êý¾Ý¿âÒ»°ãÊǶþάÊý¾Ý¡£
Êý¾Ý¿âÖб£´æµÄÊÇXML×Ö·û´®¸ñʽ£ ......
ÔÚvbÕâ±à³ÌÀïËÆºõÓкܶàµÄ¶«Î÷ÊÇÏàÁªÏµµÄ£¬ÎªÊ²Ã´ÓÐЩÈ˶ÔvbµÄ±à³ÌÃþ²»µ½Í·ÄÔ°¡£¡²¢ÇÒÓÐЩʺÜÈÝÒ׵쬵«ÊÇÈ´°ÑËüÃǵĴúÂë±ä³É¸´ÔÓ£¬Ò²È¥ÏëһЩ²»ÄÜʵÏֵĶ«Î÷°¡£¡
û·ÖÁË£¬Â¥Ö÷¶àÀ´µã·Ö£¡
À´½Óµã·Ö
......
¾ÍÊÇÉè¼ÆÒ»¸ö¼ÆËã»úÄ£Ä⿼ÊÔϵͳ£¬´øÓÐѧÉúºÍ¹ÜÀíÔ±£¬ËùÒԵǼ´°ÌåºÍÖ÷´°ÌåÏë·Ö¿ª£¬µÇ½ѧÉúµÄÏÔʾѧÉúµÄÖ÷´°Ì壬µÇ½¹ÜÀíÔ±ÏÔʾ¹ÜÀíÖ÷´°Ì壬ÎÒÖ»»áÒ»¸ö´°ÌåÓÃÒ»¶Ñ¿Ø¼þ£¬ÏÖÔÚÏíÓжà¸öÖ÷´°Ì壬²»ÖªµÀÔõô×ö£¬Ï£ÍûÇë´ó ......