Click here to Skip to main content
15,921,941 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How to call Java Web Services (wsdl) in .net Pin
Vimalsoft(Pty) Ltd27-Mar-08 0:27
professionalVimalsoft(Pty) Ltd27-Mar-08 0:27 
GeneralRe: How to call Java Web Services (wsdl) in .net Pin
C.Shivashankar27-Mar-08 0:55
C.Shivashankar27-Mar-08 0:55 
GeneralRe: How to call Java Web Services (wsdl) in .net Pin
C.Shivashankar27-Mar-08 2:11
C.Shivashankar27-Mar-08 2:11 
GeneralHelp Pin
Kartik Rathi24-Mar-08 19:10
Kartik Rathi24-Mar-08 19:10 
GeneralRe: Help Pin
Christian Graus24-Mar-08 19:28
protectorChristian Graus24-Mar-08 19:28 
GeneralRe: Help Pin
Vimalsoft(Pty) Ltd25-Mar-08 10:59
professionalVimalsoft(Pty) Ltd25-Mar-08 10:59 
QuestionHow can I add a new column in an excel file correctly? Pin
ATC24-Mar-08 16:34
ATC24-Mar-08 16:34 
AnswerRe: How can I add a new column in an excel file correctly? Pin
Dave Kreskowiak25-Mar-08 3:52
mveDave Kreskowiak25-Mar-08 3:52 
ATC wrote:
cmd.CommandText = "ALTER TABLE EmployeeData ADD NewInfo VARCHAR(20) NULL"

cmd.ExecuteNonQuery()
conn1.Close()


Might someone show me what is wrong?


The Excel driver doesn't support the "ALTER TABLE" SQL statement. You have to add the columns using the Excel object model.



A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007




GeneralRe: How can I add a new column in an excel file correctly? Pin
ATC25-Mar-08 4:18
ATC25-Mar-08 4:18 
GeneralRe: How can I add a new column in an excel file correctly? Pin
Dave Kreskowiak25-Mar-08 4:55
mveDave Kreskowiak25-Mar-08 4:55 
GeneralCookies not working - help! Pin
Member 397274924-Mar-08 14:32
Member 397274924-Mar-08 14:32 
GeneralRe: Cookies not working - help! Pin
Eduard Keilholz25-Mar-08 3:07
Eduard Keilholz25-Mar-08 3:07 
QuestionRe: Cookies not working - help! Pin
Member 397274925-Mar-08 8:07
Member 397274925-Mar-08 8:07 
AnswerRe: Cookies not working - help! Pin
Member 397274925-Mar-08 8:14
Member 397274925-Mar-08 8:14 
GeneralRe: Cookies not working - help! Pin
nlarson1125-Mar-08 10:49
nlarson1125-Mar-08 10:49 
GeneralProblem with Form and network access Pin
Cory Kimble24-Mar-08 4:31
Cory Kimble24-Mar-08 4:31 
GeneralRe: Problem with Form and network access Pin
Dave Kreskowiak24-Mar-08 5:44
mveDave Kreskowiak24-Mar-08 5:44 
GeneralRe: Problem with Form and network access Pin
Cory Kimble24-Mar-08 6:56
Cory Kimble24-Mar-08 6:56 
GeneralRe: Problem with Form and network access Pin
Dave Kreskowiak24-Mar-08 9:28
mveDave Kreskowiak24-Mar-08 9:28 
GeneralRe: Problem with Form and network access Pin
Luc Pattyn24-Mar-08 9:55
sitebuilderLuc Pattyn24-Mar-08 9:55 
GeneralRe: Problem with Form and network access [modified] Pin
Cory Kimble24-Mar-08 10:02
Cory Kimble24-Mar-08 10:02 
GeneralRe: Problem with Form and network access Pin
Dave Kreskowiak24-Mar-08 10:43
mveDave Kreskowiak24-Mar-08 10:43 
GeneralRe: Problem with Form and network access Pin
Luc Pattyn24-Mar-08 9:59
sitebuilderLuc Pattyn24-Mar-08 9:59 
GeneralRe: Problem with Form and network access Pin
Cory Kimble25-Mar-08 3:34
Cory Kimble25-Mar-08 3:34 
GeneralRe: Problem with Form and network access Pin
Dave Kreskowiak25-Mar-08 4:08
mveDave Kreskowiak25-Mar-08 4:08 

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.