Click here to Skip to main content
15,885,790 members
Home / Discussions / C#
   

C#

 
AnswerRe: code behind Pin
Christian Graus19-Oct-09 14:15
protectorChristian Graus19-Oct-09 14:15 
GeneralRe: code behind Pin
EliottA19-Oct-09 14:30
EliottA19-Oct-09 14:30 
GeneralRe: code behind Pin
Christian Graus19-Oct-09 15:35
protectorChristian Graus19-Oct-09 15:35 
GeneralRe: code behind Pin
Luc Pattyn19-Oct-09 16:19
sitebuilderLuc Pattyn19-Oct-09 16:19 
AnswerRe: code behind Pin
Pete O'Hanlon19-Oct-09 22:35
mvePete O'Hanlon19-Oct-09 22:35 
QuestionNo value given for one or more required parameters. Pin
Kevin Marois19-Oct-09 13:12
professionalKevin Marois19-Oct-09 13:12 
AnswerRe: No value given for one or more required parameters. Pin
Luc Pattyn19-Oct-09 13:41
sitebuilderLuc Pattyn19-Oct-09 13:41 
AnswerRe: No value given for one or more required parameters. Pin
_Maxxx_20-Oct-09 19:12
professional_Maxxx_20-Oct-09 19:12 
I really have no idea with excel, but:

If the Select * works fine, then examine the datarow(s) returned and find the name(s) of the columns returned - that will show you what names of columns you need to use in your select statement.

Try reducing the first Select to just returning one column - if that works add the next column and keep going until it breaks.

My suspicion is that the excel data provider is not using the first row for column names, hence it can't find them in your first query - so you need to find out how to tell it to treat the first row as names of columns.

Good Luck

Max

___________________________________________
.\\axxx
(That's an 'M')

QuestionWindows application Pin
or or19-Oct-09 11:34
or or19-Oct-09 11:34 
AnswerRe: Windows application Pin
Eddy Vluggen19-Oct-09 11:54
professionalEddy Vluggen19-Oct-09 11:54 
GeneralRe: Windows application Pin
or or19-Oct-09 20:24
or or19-Oct-09 20:24 
AnswerRe: Windows application Pin
Not Active19-Oct-09 13:15
mentorNot Active19-Oct-09 13:15 
QuestionRe: Windows application Pin
or or20-Oct-09 0:06
or or20-Oct-09 0:06 
QuestionMagical thread? [modified] Pin
Scalee19-Oct-09 10:42
Scalee19-Oct-09 10:42 
AnswerRe: Magical thread? [modified] Pin
Luc Pattyn19-Oct-09 11:39
sitebuilderLuc Pattyn19-Oct-09 11:39 
GeneralRe: Magical thread? Pin
Scalee19-Oct-09 12:23
Scalee19-Oct-09 12:23 
AnswerRe: Magical thread? Pin
Luc Pattyn19-Oct-09 12:43
sitebuilderLuc Pattyn19-Oct-09 12:43 
GeneralRe: Magical thread? Pin
Scalee19-Oct-09 21:39
Scalee19-Oct-09 21:39 
GeneralRe: Magical thread? Pin
Luc Pattyn20-Oct-09 1:36
sitebuilderLuc Pattyn20-Oct-09 1:36 
QuestionVisual Studio managing my project files Pin
LimitedAtonement19-Oct-09 9:59
LimitedAtonement19-Oct-09 9:59 
AnswerRe: Visual Studio managing my project files Pin
Not Active19-Oct-09 10:08
mentorNot Active19-Oct-09 10:08 
GeneralRe: Visual Studio managing my project files Pin
LimitedAtonement19-Oct-09 10:14
LimitedAtonement19-Oct-09 10:14 
GeneralRe: Visual Studio managing my project files Pin
Not Active19-Oct-09 10:25
mentorNot Active19-Oct-09 10:25 
GeneralRe: Visual Studio managing my project files Pin
LimitedAtonement19-Oct-09 10:52
LimitedAtonement19-Oct-09 10:52 
GeneralRe: Visual Studio managing my project files Pin
Not Active19-Oct-09 11:03
mentorNot Active19-Oct-09 11:03 

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.