-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Insert ÷åðåç Oledb?

Ïîíåäåëüíèê, 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó