c# 2005²Ù×÷Access,Êý¾ÝÖ´ÐÐΪʲô²»ÄÜÁ¢¼´Íê³É£¿
ÎÒÖ´ÐÐÒ»¸öinsertºóÂíÉÏÖ´ÐÐÒ»¸öselect£¬·¢¾õÊý¾Ý»¹Ã»¼Ó½øÈ¥£¬Èç¹ûµÈ1£¬2ÃëÔÙselectµÄ»°Êý¾Ý¾ÍÓÐÁË¡£
ÄÇÎÒÓ¦¸ÃʲôʱºòÔÙselectÄØ£¿²»¿ÉÄÜÿ´Î¶¼¼Ó¸ö¶¨Ê±Æ÷À´¸ã°É£¬¶àÂé·³£¿
commit
?????????????
°ÑÄãµÄÓï¾äÌù³öÀ´¿´Ò»ÏÂ
Ò²²»»áÑÓ³ÙÕâô¾Ã°¡£¬Ìù´úÂë
Ê×ÏÈ Ìí¼ÓÉÌÆ·£º
C# code:
private void addNewProduct()
{
string select = "select Max(ProductID) from Products";
product.ProID = Convert.ToInt32(DataAccess.Narnu.GetObjectByOleDbString(select)) + 1;
product.ProName = "н¨ÉÌÆ·";
product.CategoryID = (int)Narnu.GetCategoryID(this.listBox_bigCat.Text.ToString().Trim());
product.DetailCategoryID = (int)Narnu.GetDetailCategoryID(this.listBox_smallCat.Text.ToString().Trim(), product.CategoryID.ToString());
product.SupplierID = 1002;
product.UnitCost = 0;
product.UnitPrice = 0;
product.Units = 1000;
product.Description = " ";
product.CreateTime = DateTime.Now.ToString();
//product. = this.tb_gg.Text.ToString().Trim();
try
{
product.InsertProduct();
stateBarMsg("²úÆ·Ìí¼Ó³É¹¦£¡");
}
catch
{
stateBarMsg(&quo
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
delphi 2007 + access 2007 +odbc +TADODataset,TADOConnection,TADOCommand
//ɾ³ýÊý¾Ý
procedure TCDSSelectTools.DeleteMachine(byMachineID: string);
tmpCmd := TADOCommand.Create(ni ......
ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
mdb.OleFunction("Create", ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......