vbÖÐsqlÓï¾äÒýºÅÎÊÌâ
"insert into user1(name,age) values('" & Text1.Text & "','" & Text2.Text & "' )"
ÎÊÌ⣺¶ÔsqlÓï¾äÖе¥¡¢Ë«ÒýºÅÄ£ºý¡£¼ÈÈ» Text1.Text¾Í±íʾ×Ö·û´®ÁË£¬ÎªÉ¶»¹Òª & ºÍ "ÄØ£¿²»ÊǶà´ËÒ»¾Ùô£¿
"insert into user1(name,age) values('Text1.Text','Text2.Text')"
ÕâÑù²»ÐÐÂð£¿ÎªÊ²Ã´£¿
ÄãÊÇÒª°ÑText1.textµ±³É¸ö×Ö·û´®Ð´µ½Êý¾Ý¿âÀ»¹ÊÇÒª°ÑText1.textÀïµÄÄÚÈÝдµ½Êý¾Ý¿âÀ²âÊÔһϲ»¾ÍÖªµÀÊDz»ÊǶà´ËÒ»¾ÙÁË
Text1.Text ?="Text1.Text"
¸ÅÄîû¸ãÇå³þ
&ÊÇ×Ö·û´®Á¬½Ó·û,SQLÓï¾äµÄÁ½µ¥ÒýºÅ¼äÊÇ×Ö·û´®(ËäÈ»ÊÇд×÷Text1.Text¿Ø¼þµÄÎı¾ÊôÐÔ,µ«Êµ¼ÊÊÇ×÷ΪText1.Text×Ö·û´®ÓõÄ.LZÔËÐÐÏÂÁдúÂëÄã¾ÍÄÜ¿´³öÎÊÌâËùÔÚ.
VB code:
Private Sub Command1_Click()
Dim sql
sql = "insert into user1(name,age) values('" & Text1.Text & "','" & Text2.Text & "' )"
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL&nb ......
±ÈÈç½ø³Ì¼ÓÔØÐµijÌÐò¡£
ÔÚÆäÔËÐÐ֮ǰ×èÖ¹¡£
È»ºóÔÊÐíºó·ÅÐС£
±ÈÈç³ÌÐòÖ÷Îļþ·¾¶ÊÇc:\test\test.exe£¬½¨Á¢ÄÚÈÝÈÎÒâµÄÎļþc:\test\test.exe.manifest¡£
¾ÍÊDz»ÖªµÀ³ÌÐòÎļþ·¾¶¡£
ÉèÖ ......
Ï£Íû´ó¼ÒÄܹ»°ïÎÒÏÂ.¸ÐлÁË..
Ô´Âë´«ÔÚ´óÃ×ÅÌ VB6 µÄÔ´Âë http://www.damipan.com/file/3wNoKLW.html
תΪVB.NETÔ´Âë.
СµÜÍêÈ«ÊÇÐÂÊÖ ²»¶®µÄ˵.Âé·³¸÷λ°ïæһÏÂ
ÎÒµÄEMAILÊÇ:4452 ......
VBżѧµÃ²»´í£¬ÏÖÔÚ´óÒ»£¬¸ßÈýµÄʱºò¾ÍѧVBÁË£¬ÏÖÔÚѧУÀï¶¼ÊÇѧC#ºÍVB.NETµÄÐֵܶࡣ¡£¡£
żҪתÐÐVB.NETÁË~µ±ÄêѧVBѧÁË2Ä꣬¶ÔVBÀïÃæµÄ³£Óú¯Êý¶¼Ê®·ÖÁ˽⡣
Select¡¢If½á¹¹¡¢For NextÑ»·¡¢µÈ¶¼Á˽⡣¡£¡£ ......