Search results for query: *

Maybe I'm asking for too much here. Can anyone help me out with just the first question. When I use the statement AAA = New Excel.Application - I receive the error "New cannot be used on an interface" I see this statement in almost all the treads I've read that are reading Excel. Any...

Hello, I'm trying to figure out how to read and write to an excel spreadsheet. I found a prevoius post and had the following example to read an excel spreadsheet. Have found other examples also, which all have had the following statement (XXXX = NEW Excel.Application). I have referenced...

Very useful. I'm new at vb.net and this is what I've been looking for. Thanks

Thanks! Tried it in both vb.net 2003 and 2005. Received the same results in both versions.

Hi, I have a datetimepicker control on my form and when I run the app and select the drop down arrow to pick a date on the datetimepicker control and then try and select a different month, the app starts repeating the DateTimePicker1_ValueChanged event over and over each time incrementing the...

Thanks lingsn for the help you provided. It took me several days to be able to figure out how to do what you were asking, but I finally got it to work using parameters and stored procedures. Actually, you helped me twice as I posted another thread on another topic. Happy Holidays

Thanks, changing output to input did the trick. Thanks so much.

Hi again to anyone reading this post: I found in some documentation about adding some logic to catch the error and give a little more detail on what the error is. The error I was getting is becasue my parameter in my code did not match my parameter in my stored Procedure. Opps... By the...

Hi, I'm trying to write my first vb.net program to update a date/time field in a SQL database. I'm trying to update the table by using passing a date parameter to a stored procedue and then run the stored procedure to update my table. I'm receiving the following error message: First, my...

The link on the site you directed me too no longer works. Can you please tell me what you mean by "typed parameters, using SqlParameter" or direct me to a another link. Thanks again

Hi, I'm new at vb.net and am trying to write a program to update a sql server 2000 database datetime field using ado.net. I'm pulling my date (Dec 12, 2006) from a datetimepicker control. I've tried to format the date to be "yyyy-mm-dd" which updates the sql table with a date value of June...