Ïîíåäåëüíèê, 10 Ôåâðàëÿ 2014 ã. 20:36
+ â öèòàòíèê
Äîáðûé äåíü. Èìååì VS 2008(.net 3.5 sp1), Office 2007 (x86). Ñàìà ìàøèíà x64
Íóæíî ÷åðåç oledb äîáàâèòü çàïèñè â access. Insert ïðàâèëüíûé, â êîíñîëüíîì îêíå çàïðîñà âûïîëíÿåòñÿ êîððåêòíî. Ñíÿë áëîêèðîâêó ïîäîçðèòåëüíîãî ñîäåðæèìîãî, çàïðåòèë çàäàâàòü âîïðîñû ïðè èçìåíåíèè äàííûõ.
Ñòðîêà êîííåêòà òàêàÿ: Provider=Microsoft.ACE.OLEDB.12.0; Data Source=c:\_Ref\Ref.mdb;Mode=ReadWrite;
Âñå ðàâíî:
IDbCommand cmdDest;
cmdDest.CommandText = "INSERT INTO [Ôåäåðàëüíûå îêðóãà]([FOKR], [KOD], [NAM_FOKR]) values (null,null,'ÍÅ ÓÊÀÇÀÍ');";
cmdDest.ExecuteNonQuery();
âûïîëíÿåòñÿ êîððåêòíî è áåç îøèáîê, íî ñòðîêè â ÁÄ êàê íå áûëî, òàê è íåò. ×òî ýòî çà ìèñòèêà? Èëè åùå ÷òî-òî ãäå-òî íóæíî âêëþ÷èòü/îòêëþ÷èòü???
http://www.sql.ru/forum/1076601/insert-cherez-oledb
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-