Click here to Skip to main content
       

C#

 
AnswerRe: Printing Persian Words PinmentorKeith Barrow5-Oct-12 6:08 
GeneralRe: Printing Persian Words Pinmembermohammadkaab5-Oct-12 7:18 
GeneralRe: Printing Persian Words PinmentorKeith Barrow5-Oct-12 9:06 
QuestionOleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] PinmemberParamu19735-Oct-12 0:45 
I try to find a solution from many places, but not yet solved...and hence I have a
different issue for update dbf file [free table -vfp] from C# OleDbDataAdapter.
 
string MyConStr = "Provider=VFPOLEDB.1; Data Source='C:\\Temp'; Persist Security Info=False";  
VFPDAp = new OleDbDataAdapter(); 
VFPDAp.InsertCommand = new OleDbCommand(); 
VFPDAp.UpdateCommand = new OleDbCommand();  
VFPDAp.InsertCommand.CommandText = "insert into my_table1 (my_time,reminder) values(?, ?, ?)"; 
VFPDAp.UpdateCommand.CommandText = "update my_table1 set my_time=?, reminder=? where sl_no=? ";  
VFPDAp.InsertCommand.Connection = OleCon1; 
VFPDAp.UpdateCommand.Connection = OleCon1;   
OleDbParameter Par1 = new OleDbParameter("my_time", -1); 
Par1.DbType = DbType.String; 
Par1.SourceColumn = "my_time"; 
Par1.ParameterName = "my_time";  
OleDbParameter Par2 = new OleDbParameter("reminder", -1); 
Par2.DbType = DbType.String; 
Par2.SourceColumn = "reminder"; Par2.ParameterName = "reminder";  
OleDbParameter Par3 = new OleDbParameter("my_time", -1); 
Par3.DbType = DbType.String; 
Par3.SourceColumn = "my_time"; 
Par3.ParameterName = "my_time";  
OleDbParameter Par4 = new OleDbParameter("reminder", -1); 
Par4.DbType = DbType.String; 
Par4.SourceColumn = "reminder"; 
Par4.ParameterName = "reminder";  
VFPDAp.InsertCommand.Parameters.Add(Par1); 
VFPDAp.InsertCommand.Parameters.Add(Par2); 
VFPDAp.UpdateCommand.Parameters.Add(Par3); 
VFPDAp.UpdateCommand.Parameters.Add(Par4);  
OleCon1.ConnectionString = MyConStr; 
OleCon1.Open(); 
VFPDAp.Update(VfpTbl); //============> SQL: Column 'Q0P2' is not found 
OleCon1.Close();
Thanks For The Helps
AnswerRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] PinmemberEddy Vluggen5-Oct-12 1:34 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] PinmemberParamu19735-Oct-12 2:10 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] PinmemberEddy Vluggen5-Oct-12 2:13 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] PinmemberParamu19735-Oct-12 2:23 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] PinmemberEddy Vluggen5-Oct-12 2:24 
QuestionAssistence required with this spacific Program [modified] PinmemberCihangir Giray Han4-Oct-12 22:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 20 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid