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 £
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......