Click here to Skip to main content
       

C#

 
GeneralRe: pls help learn c# need someone to guide me thru PinmemberEddy Vluggen5-Oct-12 10:08 
GeneralRe: pls help learn c# need someone to guide me thru PinmvpRichard MacCutchan5-Oct-12 22:19 
GeneralRe: pls help learn c# need someone to guide me thru PinprotectorPete O'Hanlon5-Oct-12 22:28 
Questionhow can i delete data from sql database on select the item from listbox in window form in asp.net PinmemberRanjeet69315-Oct-12 7:23 
AnswerRe: how can i delete data from sql database on select the item from listbox in window form in asp.net Pinmemberkamalkss5-Oct-12 8:00 
GeneralRe: how can i delete data from sql database on select the item from listbox in window form in asp.net PinmemberRanjeet69315-Oct-12 8:15 
QuestionPrinting Persian Words Pinmembermohammadkaab5-Oct-12 2:19 
AnswerRe: Printing Persian Words PinmemberEddy Vluggen5-Oct-12 5:01 
GeneralRe: Printing Persian Words PinmentorKeith Barrow5-Oct-12 6:17 
GeneralRe: Printing Persian Words PinmemberEddy Vluggen5-Oct-12 9:43 
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 
AnswerRe: Assistence required with this spacific Program PinmvpRichard MacCutchan4-Oct-12 23:04 
AnswerRe: Assistence required with this spacific Program PinmemberV.5-Oct-12 0:41 
QuestionHow to configure post-build events for setup/deployment projects in Visual Studio PinmemberTridip Bhattacharjee4-Oct-12 21:25 
AnswerRe: How to configure post-build events for setup/deployment projects in Visual Studio PinmvpRichard MacCutchan4-Oct-12 21:50 
GeneralRe: How to configure post-build events for setup/deployment projects in Visual Studio PinmemberTridip Bhattacharjee6-Oct-12 7:07 
GeneralRe: How to configure post-build events for setup/deployment projects in Visual Studio PinmvpRichard MacCutchan6-Oct-12 7:18 
QuestionBasic Polymorphism Problem PinmemberAmbiguousName4-Oct-12 18:54 
AnswerRe: Basic Polymorphism Problem PinmentorDaveyM694-Oct-12 20:29 
AnswerRe: Basic Polymorphism Problem PinmemberAmbiguousName4-Oct-12 20:56 
GeneralRe: Basic Polymorphism Problem PinmentorDaveyM694-Oct-12 21:35 
AnswerRe: Basic Polymorphism Problem PinmemberAmbiguousName4-Oct-12 21:45 
GeneralRe: Basic Polymorphism Problem PinmentorDaveyM694-Oct-12 22:18 
AnswerRe: Basic Polymorphism Problem PinmemberBobJanova5-Oct-12 0:52 
GeneralRe: Basic Polymorphism Problem PinmentorDaveyM695-Oct-12 1:19 
GeneralRe: Basic Polymorphism Problem PinmemberBobJanova5-Oct-12 3:04 
QuestionC# linq group by Pinmemberrachel_m4-Oct-12 17:43 
AnswerRe: C# linq group by PinmvpOriginalGriff4-Oct-12 23:19 
GeneralRe: C# linq group by Pinmemberrachel_m5-Oct-12 2:48 
GeneralRe: C# linq group by PinmvpOriginalGriff5-Oct-12 3:29 
QuestionCrystal Reports : Database Login Prompt Issue PinmemberQuam Chang4-Oct-12 16:36 
AnswerRe: Crystal Reports : Database Login Prompt Issue PinmemberAmbiguousName4-Oct-12 20:00 
QuestionAggregate data into 5 min interval PinmemberMember 94707244-Oct-12 11:59 
QuestionC# linq Pinmemberrachel_m4-Oct-12 9:36 
AnswerRe: C# linq PinmemberCollin Jasnoch4-Oct-12 10:00 
Question.exe Reference Problem - maybe Pinmemberdirsow4-Oct-12 7:52 
AnswerRe: .exe Reference Problem - maybe PinmemberEddy Vluggen4-Oct-12 9:01 
GeneralRe: .exe Reference Problem - maybe Pinmemberdirsow4-Oct-12 9:27 
GeneralRe: .exe Reference Problem - maybe PinmemberEddy Vluggen4-Oct-12 9:34 
GeneralRe: .exe Reference Problem - maybe Pinmemberdirsow4-Oct-12 9:41 
AnswerRe: .exe Reference Problem - maybe PinmemberBernhard Hiller4-Oct-12 21:00 

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
Web01 | 2.8.140415.2 | Last Updated 17 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid