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

SQL²åÈëÓï¾ä

string ConStr = "provider=Microsoft.jet.oledb.4.0;data source =" + Application.StartupPath + @"\Database.mdb";
            OleDbConnection Olecon = new OleDbConnection(ConStr);
            Olecon.Open();
            string strInsert = "INSERT TNTO ѧÉúÐÅÏ¢(ѧºÅ, ÐÕÃû ,ÐÔ±ð ,°à¼¶ ,³É¼¨) VALUES £¨" + textBox1.Text + ", '" + textBox2.Text+ "', '" + textBox3.Text+ "', '" + textBox4.Text + "'," + textBox5.Text+ "£©";
            OleDbCommand inst = new OleDbCommand(strInsert,Olecon);
            inst.ExecuteNonQuery();
            Olecon.Close();
            Olecon.Dispose();
±¨´í£ºSQLÓï¾ä´íÎó
Ôõô¸Ð¾õ¶ººÅµÄÊäÈëÕâô¹ÖÄØ£¬Ã»¿´³öÀ´

°ÑÄãµÄSQLÓï¾ä·ÅÔÚSQLµÄÖ´ÐÐÆ÷ÀïÖ´ÐÐÏ£¬¿´¿´ÊÇÄÄÀïµÄÎÊÌâ

ÄãµÄ¶ººÅºÍµ¥ÒýºÅд³ÉÈ«½ÇÁ衃 ¸Ä°ë½Ç²ÅÐÐ

string strInsert = "INSERT TNTO ѧÉúÐÅÏ¢(ѧºÅ, ÐÕÃû ,ÐÔ±ð ,°à¼¶ ,³É¼¨) VALUES £¨" + textBox1.Text + ", " + textBox2.Text+ ", " + textBox3.Text+ ", " + textBox4.Text + "," + textBox5.Text+ "£©"; Óï¾äд´íÁË


string strInsert = "INSERT TNTO ѧÉúÐÅÏ¢(ѧºÅ, ÐÕÃû ,ÐÔ±ð ,°à¼¶ ,³É¼¨) VALUES £


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%, 
ÀýÈç:TABLE a
columnA
'222'
'33%44'
ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'
лл
select * from a
where columna like '%/%%' escape '/'

UP

SELECT * from a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ