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 ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂ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µØÖ·µ ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3
A B C
D E F
......