Click here to Skip to main content
15,844,011 members
Home / Discussions / C#
   

C#

 
QuestionGraph Disappear Problem vol 2 Pin
StuffyEst10-Mar-09 13:15
StuffyEst10-Mar-09 13:15 
AnswerRe: Graph Disappear Problem vol 2 Pin
Yusuf10-Mar-09 13:25
Yusuf10-Mar-09 13:25 
GeneralRe: Graph Disappear Problem vol 2 Pin
StuffyEst10-Mar-09 13:29
StuffyEst10-Mar-09 13:29 
AnswerRe: Graph Disappear Problem vol 2 Pin
Luc Pattyn10-Mar-09 16:28
sitebuilderLuc Pattyn10-Mar-09 16:28 
GeneralRe: Graph Disappear Problem vol 2 Pin
StuffyEst11-Mar-09 5:25
StuffyEst11-Mar-09 5:25 
QuestionProgrammatically Setting the Application's Privilege Level? Pin
That Asian Guy10-Mar-09 12:33
That Asian Guy10-Mar-09 12:33 
AnswerRe: Programmatically Setting the Application's Privilege Level? Pin
Ravadre10-Mar-09 14:14
Ravadre10-Mar-09 14:14 
QuestionOleDB UPDATE command throws exception Pin
Matthew Klein10-Mar-09 12:03
Matthew Klein10-Mar-09 12:03 
Greetings all! I am trying to run an UPDATE command on an XLS file that I have opened a connection to. However, the RunNonQuery() method throws the exception:
“No value given for one or more required parameters.”
ErrorCode -2147217904

Here is the code:
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\test.xls"";Extended Properties=""Excel 8.0;HDR=NO;""";
OleDbConnection con = new OleDbConnection(connectioinString);
con.Open();

OleDbCommand com = con.CreateCommand();
com.CommandText = "UPDATE [Sheet1$A1:A1] SET F1 = 'True'";
com.ExecuteNonQuery(); //Thows Exception

con.Close();

I’m pulling my hair out trying to figure out what I’m doing wrong… I was following the example from http://support.microsoft.com/kb/316934#12 to the letter, but I can’t figure out what I’m missing.

Can anyone point me in the right direction (or just let me know)?

Thank you all in advance!
AnswerRe: OleDB UPDATE command throws exception Pin
Yusuf10-Mar-09 12:33
Yusuf10-Mar-09 12:33 
AnswerRe: OleDB UPDATE command throws exception Pin
Matthew Klein10-Mar-09 13:23
Matthew Klein10-Mar-09 13:23 
QuestionUpdate Database(ACCESS) from ASP page Pin
daks90610-Mar-09 11:11
daks90610-Mar-09 11:11 
AnswerRe: Update Database(ACCESS) from ASP page Pin
led mike10-Mar-09 11:25
led mike10-Mar-09 11:25 
QuestionRe: Update Database(ACCESS) from ASP page Pin
daks90610-Mar-09 13:08
daks90610-Mar-09 13:08 
AnswerRe: Update Database(ACCESS) from ASP page Pin
Yusuf10-Mar-09 12:38
Yusuf10-Mar-09 12:38 
QuestionDirectsound Sine wave Pin
Eja Beja10-Mar-09 10:33
Eja Beja10-Mar-09 10:33 
AnswerRe: Directsound Sine wave Pin
Luc Pattyn10-Mar-09 10:48
sitebuilderLuc Pattyn10-Mar-09 10:48 
AnswerRe: Directsound Sine wave Pin
Ravi Bhavnani10-Mar-09 14:19
professionalRavi Bhavnani10-Mar-09 14:19 
QuestionHow to prio-hide controls when window gets too small? Pin
ioctl5110-Mar-09 8:44
ioctl5110-Mar-09 8:44 
AnswerRe: How to prio-hide controls when window gets too small? Pin
Luc Pattyn10-Mar-09 8:48
sitebuilderLuc Pattyn10-Mar-09 8:48 
QuestionDataGridView naughty behavior Pin
Muammar©10-Mar-09 8:39
Muammar©10-Mar-09 8:39 
AnswerRe: DataGridView naughty behavior Pin
musefan10-Mar-09 8:41
musefan10-Mar-09 8:41 
AnswerRe: DataGridView naughty behavior Pin
Muammar©10-Mar-09 8:50
Muammar©10-Mar-09 8:50 
QuestionHow Can I Hide String Key Pin
dataminers10-Mar-09 8:18
dataminers10-Mar-09 8:18 
AnswerRe: How Can I Hide String Key Pin
musefan10-Mar-09 8:31
musefan10-Mar-09 8:31 
GeneralRe: How Can I Hide String Key Pin
dataminers10-Mar-09 11:48
dataminers10-Mar-09 11:48 

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.