Click here to Skip to main content
15,843,322 members
Home / Discussions / C#
   

C#

 
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 
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 
Oh my... After running some trial and error testing by isolating each step I realized that my connection string had "HRD=NO" instead of the correct "HDR=NO"... so the connection was taking the first row as the header and that was causing the conflict.

For everyone else that may want to use this technique, it does work. If you want to read/write to cell B2 on worksheet MySheet you can use:
"SELECT * FROM [MySheet$B2:B2]"
"UPDATE [MySheet$B2:B2] SET F1 = 'Value'"

But you need to specify HDR=NO in the connection string.
See http://support.microsoft.com/kb/316934#12[^] for a step by step walkthrough.

Hope this helps someone.
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 
AnswerRe: How Can I Hide String Key Pin
0x3c010-Mar-09 8:53
0x3c010-Mar-09 8:53 
GeneralRe: How Can I Hide String Key Pin
dataminers10-Mar-09 11:53
dataminers10-Mar-09 11:53 

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.