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 ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
ÎÒÏë°Ñ´¿Õæip¿âµ¼³öµ½sqlserver£¬ÎÒÓÃϱߵĽéÉÜ·½·¨£¬£¨ËüÖ÷ÒªÊǵ¥¸öIP²éѯµÄ£©
http://www.cnblogs.com/njnudt/archive/2007/04/08/704524.html
¸ÄÁËÒ»ÏÂÄܹ»µÃµ½ËùÓеĹú¼ÒºÍµØÇøÐÅÏ¢£¬µ«ÊDz»Äܵõ½ipµØÖ·µ ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......