Click here to Skip to main content
15,886,518 members
Home / Discussions / C#
   

C#

 
QuestionPrinting Persian Words Pin
mohammadkaab5-Oct-12 2:19
mohammadkaab5-Oct-12 2:19 
AnswerRe: Printing Persian Words Pin
Eddy Vluggen5-Oct-12 5:01
professionalEddy Vluggen5-Oct-12 5:01 
GeneralRe: Printing Persian Words Pin
Keith Barrow5-Oct-12 6:17
professionalKeith Barrow5-Oct-12 6:17 
GeneralRe: Printing Persian Words Pin
Eddy Vluggen5-Oct-12 9:43
professionalEddy Vluggen5-Oct-12 9:43 
AnswerRe: Printing Persian Words Pin
Keith Barrow5-Oct-12 6:08
professionalKeith Barrow5-Oct-12 6:08 
GeneralRe: Printing Persian Words Pin
mohammadkaab5-Oct-12 7:18
mohammadkaab5-Oct-12 7:18 
GeneralRe: Printing Persian Words Pin
Keith Barrow5-Oct-12 9:06
professionalKeith Barrow5-Oct-12 9:06 
QuestionOleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] Pin
Paramu19735-Oct-12 0:45
Paramu19735-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.

C#
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] Pin
Eddy Vluggen5-Oct-12 1:34
professionalEddy Vluggen5-Oct-12 1:34 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] Pin
Paramu19735-Oct-12 2:10
Paramu19735-Oct-12 2:10 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] Pin
Eddy Vluggen5-Oct-12 2:13
professionalEddy Vluggen5-Oct-12 2:13 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] Pin
Paramu19735-Oct-12 2:23
Paramu19735-Oct-12 2:23 
GeneralRe: OleDbException : SQL: Column 'Q0P2' is not found [update dbf free tables from oledbdataadapter] Pin
Eddy Vluggen5-Oct-12 2:24
professionalEddy Vluggen5-Oct-12 2:24 
QuestionAssistence required with this spacific Program Pin
Cihangir Giray Han4-Oct-12 22:01
Cihangir Giray Han4-Oct-12 22:01 
AnswerRe: Assistence required with this spacific Program Pin
Richard MacCutchan4-Oct-12 23:04
mveRichard MacCutchan4-Oct-12 23:04 
AnswerRe: Assistence required with this spacific Program Pin
V.5-Oct-12 0:41
professionalV.5-Oct-12 0:41 
QuestionHow to configure post-build events for setup/deployment projects in Visual Studio Pin
Tridip Bhattacharjee4-Oct-12 21:25
professionalTridip Bhattacharjee4-Oct-12 21:25 
AnswerRe: How to configure post-build events for setup/deployment projects in Visual Studio Pin
Richard MacCutchan4-Oct-12 21:50
mveRichard MacCutchan4-Oct-12 21:50 
GeneralRe: How to configure post-build events for setup/deployment projects in Visual Studio Pin
Tridip Bhattacharjee6-Oct-12 7:07
professionalTridip Bhattacharjee6-Oct-12 7:07 
GeneralRe: How to configure post-build events for setup/deployment projects in Visual Studio Pin
Richard MacCutchan6-Oct-12 7:18
mveRichard MacCutchan6-Oct-12 7:18 
QuestionBasic Polymorphism Problem Pin
AmbiguousName4-Oct-12 18:54
AmbiguousName4-Oct-12 18:54 
AnswerRe: Basic Polymorphism Problem Pin
DaveyM694-Oct-12 20:29
professionalDaveyM694-Oct-12 20:29 
AnswerRe: Basic Polymorphism Problem Pin
AmbiguousName4-Oct-12 20:56
AmbiguousName4-Oct-12 20:56 
GeneralRe: Basic Polymorphism Problem Pin
DaveyM694-Oct-12 21:35
professionalDaveyM694-Oct-12 21:35 
AnswerRe: Basic Polymorphism Problem Pin
AmbiguousName4-Oct-12 21:45
AmbiguousName4-Oct-12 21:45 

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

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