Search:

But I get a syntax error on my first example, if I omit the "With". e.g. like this:



Dim InputParameters(1) As SqlParameter
InputParameters(0) = New SqlParameter("@report", SqlDbType.VarChar)...

I must have missed something there! It looks like both those examples use the "With" keyword. Since I have an example that works without the keyword, I'm trying to understand when the keyword is...

yes. but that is not what I want to know. I really want to know why sometimes the keyword "With" is required in this context and sometimes not.

Hi -- I see that I can do this:


Dim InputParameters(1) As SqlParameter
InputParameters(0) = New SqlParameter("@report", SqlDbType.VarChar) _
With {.Value =...

I'm maintaining an old program that has patterns like this


dim d as double
dim i, j as integer

d = cdbl(i/j)

' or

I'm getting the error below trying to open a new workbook in Excel:



Imports Microsoft.Office.Core
...
Dim myExcel As New Excel.Application
myExcel.Visible =...

Yeah its not about managing the files in VS. That part is easy. The problem is using Server Explorer. If you expand the Tables or Stored Procedures branches, it shows you all of them (hundreds or...

I have a few projects that include two major components:

1. vb.net programs

2. SQL Server stored procedures

Ideally I'd like to be able to work on both from one IDE. So far, I haven't been...

I agree. I was just curious. The Regex timings didn't really surprise me

Well, I'm not permitted to refactor the code or split up larger methods. I have been moving the larger subroutines to their own files which leaves things as they are but makes them easier to edit. ...

Good question! The original program was a single module (static class, right?) No, I don't try to instantiate objects from it, except for the one object created when at program startup (which...

Well, no, but that was not the point of my question.



as is the Regex library



Dim isMatch As Boolean = Regex.Match("foo", "f.*o", RegexOptions.IgnoreCase).Success

Interesting. Note that I am not working on a GUI app. It does SQL queries and builds reports in Excel. What about a class that has many methods and that grows to many thousands of lines? Still...

I've been handed an old vb6 program to update to vb.net. So far, so good. The new version runs and produces equivalent results. Now, I'm looking for ideas on how to better manage the beast. It's...

Thanks for the tip! I changed to using StopWatch and I like it!

I don't think they are that different. They can both be used to achieve similar goals. Even though InStr returns an integer. It's a small step from an integer to a Boolean. In any case, I reran it...

Hey Shaggy. Yes, I have a test app, though not forms-based. I just can't get interested in VB GUIs at the moment. It's what I use to test out new concepts -- and for me as a VB newbie, loads of...

I got curious about these two different ways of checking if a string has some substring. So, I set up a little test:



Sub Main()
Dim foo As String = "foo"
Dim start_time...

did some reading...I have to forget it for the moment since my VS is 2008. It doesn't play nicely with Excel 2010 (or play at all)

Yes I have a reference to Microsoft.Interop.Office.Excel. Is there a tutorial on PIAs someplace I can go to?

Oh, but I don't want to modify the registry (I didn't get that from your earlier post). I want to be able to choose at runtime which version to launch w/o modifying and possibly restoring registry...

Thanks! The refs are helpful for discovering the versions of Excel installed (but I know what I have installed). What I need is a programatic way from vb.net to force this line:



Dim myExcel...

I have two versions of Excel on my desktop: 2003 and 2010. I have this code:



Dim myExcel As New Excel.Application
myExcel.Visible = True
Dim myBook As Excel.Workbook...

I have an application that reads data from a SQL query into a list corresponding to the rows of the query. So, I have something like this:



class myrow
public foo
public bar
......

Perfect! These are just the ideas I'm looking for!!

I agree but that's not the point. I'm looking for a general solution here and just responding to the idea of passing array elements into the subroutine.

Well, suppose the array is large (millions of items). Passing elements is not really an option for that.

I'd like to know if it is possible to refer to section of an array. e.g.



dim a(10) as integer
foo(<reference to array a starting at item 2>) 'only use items 2 to 9 of the array
...
sub...

yeah. I'm using something like that. Funny thing is the Transpose function returns a 1-based array in VB. I didn't know that was possible! OTOH, Excel seems happy if the array is 1- or 0-based,...

Bumping

PS -- I'm talking to Excel 2003

I'm working on pasting arrays into excel ranges. Suppose I have a range: A1:A5
and an array a = {1,2,3,4,5}. I can set up the problem like this:



Dim myExcel As New Excel.Application...

Cool! Just what I need!!

i is the new value for aa.ab.bc.cx

Using Visual Studio 2008, I see that it is possible to connect to a SQL Server instance and work with stored procedures found there. That is nice! Now, I have a project that includes some stored...

This is a follow up to my thread about Func(Of T). Here I've trimmed back the problem to bare bones. (I wrote this up at home where I don't have access to a VB compiler so I apologize for syntax...

OK -- but here I need to be able to modify the contents of objrpt

objrpt is an instance of a large class. Not so sure passing it by val is appropriate

Dim DelCol = Function(col As Integer) _
DeleteColumn(objrpt, col)


gives the error message:

Now I have:



Private Function DeleteColumn(ByRef objrpt As ExcelReport, ByVal col As Integer) As Boolean
Dim objrng As Excel.Range
objrng = objrpt.objXLSheet.Columns(col)...