Click here to Skip to main content
15,891,033 members
Home / Discussions / C#
   

C#

 
AnswerRe: enumeration was modified operation may not execute Pin
malharone11-Feb-06 7:31
malharone11-Feb-06 7:31 
GeneralRe: enumeration was modified operation may not execute Pin
Colin Angus Mackay11-Feb-06 13:41
Colin Angus Mackay11-Feb-06 13:41 
GeneralRe: enumeration was modified operation may not execute Pin
malharone11-Feb-06 18:14
malharone11-Feb-06 18:14 
GeneralRe: enumeration was modified operation may not execute Pin
Colin Angus Mackay12-Feb-06 1:34
Colin Angus Mackay12-Feb-06 1:34 
GeneralRe: enumeration was modified operation may not execute Pin
malharone12-Feb-06 5:27
malharone12-Feb-06 5:27 
GeneralRe: enumeration was modified operation may not execute Pin
spirit_of_pak12-Feb-06 17:28
spirit_of_pak12-Feb-06 17:28 
QuestionError Pin
NaNg1524111-Feb-06 3:54
NaNg1524111-Feb-06 3:54 
AnswerRe: Error Pin
perlmunger11-Feb-06 7:15
perlmunger11-Feb-06 7:15 
You either need to set the insert command's command text or you need to use parameters. Change your code to do this instead:
string selectCommand = "SELECT COUNT..."; // ... for brevity
objDA = new OleDbDataAdapter( selectCommand, connection );
objDA.InsertCommand.CommandText = string.Format("Insert into tblProjects(SProjID, SProjName) Values('{0}', '{1}')", ProjID, ProjName);
objDA.InsertCommand.ExecuteNonQuery();

Alternatively, you can use parameters like this:
string selectCommand = "SELECT COUNT..."; // ... for brevity
objDA = new OleDbDataAdapter( selectCommand, connection );
objDA.InsertCommand = new OleDbCommand( "Insert into tblProjects(SProjID, SProjName) Values( ?, ?)", connection );
objDA.InsertCommand.Parameters.Add( "@SProjID", OleDbType.VarChar, 30, "SProjID" ).Value = ProjID;
objDA.InsertCommand.Parameters.Add( "@SProjName", OleDbType.VarChar, 30, "SProjName" ).Value = ProjName;
objDA.InsertCommand.ExecuteNonQuery();

Hope that helps.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
GeneralRe: Error Pin
NaNg1524111-Feb-06 8:13
NaNg1524111-Feb-06 8:13 
GeneralRe: Error Pin
NaNg1524111-Feb-06 9:36
NaNg1524111-Feb-06 9:36 
GeneralRe: Error Pin
perlmunger11-Feb-06 11:09
perlmunger11-Feb-06 11:09 
QuestionCreate list with Grid and getting Process info in C#. Pin
Yanshof11-Feb-06 1:37
Yanshof11-Feb-06 1:37 
AnswerSome one can help me with this question please ? Pin
Yanshof11-Feb-06 9:02
Yanshof11-Feb-06 9:02 
AnswerRe: Create list with Grid and getting Process info in C#. Pin
Dave Kreskowiak11-Feb-06 10:51
mveDave Kreskowiak11-Feb-06 10:51 
QuestionHow to browse SQL server from a network? Pin
bouli10-Feb-06 21:46
bouli10-Feb-06 21:46 
AnswerRe: How to browse SQL server from a network? Pin
perlmunger11-Feb-06 6:34
perlmunger11-Feb-06 6:34 
QuestionI need Help Pin
BestArtemis10-Feb-06 21:22
BestArtemis10-Feb-06 21:22 
AnswerRe: I need Help Pin
Wayne Phipps10-Feb-06 21:35
Wayne Phipps10-Feb-06 21:35 
QuestionDLL Problem Pin
Expert Coming10-Feb-06 14:06
Expert Coming10-Feb-06 14:06 
AnswerRe: DLL Problem Pin
Dave Kreskowiak10-Feb-06 14:28
mveDave Kreskowiak10-Feb-06 14:28 
GeneralRe: DLL Problem (How?) Pin
Expert Coming10-Feb-06 14:33
Expert Coming10-Feb-06 14:33 
GeneralRe: DLL Problem (How?) Pin
Dave Kreskowiak10-Feb-06 14:56
mveDave Kreskowiak10-Feb-06 14:56 
GeneralRe: DLL Problem (How?) Pin
kourvoisier10-Feb-06 14:59
kourvoisier10-Feb-06 14:59 
GeneralRe: DLL Problem (How?) Pin
Expert Coming10-Feb-06 15:09
Expert Coming10-Feb-06 15:09 
GeneralRe: DLL Problem (How?) Pin
Dave Kreskowiak10-Feb-06 16:50
mveDave Kreskowiak10-Feb-06 16:50 

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.