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

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²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

DbgridÁ¬½ÓaccessÍ϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......

c# µ¼³ö´¿Õæip¿âµ½sqlserver

ÎÒÏë°Ñ´¿Õæip¿âµ¼³öµ½sqlserver£¬ÎÒÓÃϱߵĽéÉÜ·½·¨£¬£¨ËüÖ÷ÒªÊǵ¥¸öIP²éѯµÄ£©
http://www.cnblogs.com/njnudt/archive/2007/04/08/704524.html
¸ÄÁËÒ»ÏÂÄܹ»µÃµ½ËùÓеĹú¼ÒºÍµØÇøÐÅÏ¢£¬µ«ÊDz»Äܵõ½ipµØÖ·µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ