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
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......