Visual Basic

Re: Is it possible to compile against .Net 2.0 and 2.1 framework versions in VS 2008?

18-Nov-08 1:21

Eddy Vluggen wrote:
What version of Visual Studio do you use to compile against 2.1?

Currently using VS 2005 for compiling against both. I have 2 virtual machine environments setup so that I can compile against 2.0 and another for the 2.1 framework library.

Eddy Vluggen wrote:
Do you actually distribute a version with 2.0-framework libraries *and* a version with the 2.1-framework libraries?

Two different library versions get deployed. Win98 gets the 2.0 librarys, while everyone else gets 2.1. If the machine isn't running Win98, they the client has WinXP or higher.

Eddy Vluggen wrote:
I'm using VS2008, Windows XP SP3. Just compiled a form against the 2.0 framework, without problems. I didn't test it under 2.0 SP1 though.

Not sure I'm following you here. Are you saying you compiled a win form app targeting the 2.0 framework, and the app worked in Win98? I thought by default VS2008 installs 2.0 SP1?

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Eddy Vluggen18-Nov-08 2:34

Eddy Vluggen

18-Nov-08 2:34

kissdznuts wrote:
I have 2 virtual machine environments setup so that I can compile against 2.0 and another for the 2.1 framework library.

So you redistribute the framework-libraries with the installer?

kissdznuts wrote:
Are you saying you compiled a win form app targeting the 2.0 framework, and the app worked in Win98?

I'm saying that there is no way to target 2.1 specific. One targets 2.0, 3.0 or 3.5. Microsoft only provides Redistributable Packages for those versions of the framework. You'll have to traverse the registry to find out wether SP1 is installed (or any security-updates for .NET, in case those DLL-versions are important to you)

Take a look at the version-list;
http://en.wikipedia.org/wiki/.NET_Framework_version_list

Re: Is it possible to compile against .Net 2.0 and 2.1 framework versions in VS 2008?

Jon_Boy18-Nov-08 3:41

Re: Is it possible to compile against .Net 2.0 and 2.1 framework versions in VS 2008?

18-Nov-08 3:41

Eddy Vluggen wrote:

So you redistribute the framework-libraries with the installer?

Kinda - we have a custom app that is similar to the click once. We have an exe that starts prior to any other apps, determines what updates need applied and installs them (meaning frameworks, windows installer, other 3rd party software), and then runs the appropriate program (determine by command line sent in).

Eddy Vluggen wrote:

I'm saying that there is no way to target 2.1 specific. One targets 2.0, 3.0 or 3.5. Microsoft only provides Redistributable Packages for those versions of the framework. You'll have to traverse the registry to find out wether SP1 is installed (or any security-updates for .NET, in case those DLL-versions are important to you)

Right, that's what Guffa was stating earlier. Basically, the 2.0, 3.0, 3.5 points to the highest installed version of each.

I check the Net Framework Setup\NDP\v2.0\SP key or system.environment.version

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Eddy Vluggen18-Nov-08 3:52

Eddy Vluggen

18-Nov-08 3:52

kissdznuts wrote:
Basically, the 2.0, 3.0, 3.5 points to the highest installed version of each.

Someone who has 2.0 installed might not have version 1.1 of the framework, so it doesn't point to the "highest installed version".

It simply points to the version of the Framework, regardless of (security) updates and/or service packs.

kissdznuts wrote:
we have a custom app that is similar to the click once

How does it handle the differences now? Does it update an XP installation if SP1 for .NET 2.0 is not installed? If so, do you *overwrite* the old libraries, or do you *add* the new versions to the GAC?

Re: Is it possible to compile against .Net 2.0 and 2.1 framework versions in VS 2008?

Jon_Boy18-Nov-08 4:41

How To assign null value into nullable object

18-Nov-08 4:41

Eddy Vluggen wrote:
Someone who has 2.0 installed might not have version 1.1 of the framework, so it doesn't point to the "highest installed version".

It simply points to the version of the Framework, regardless of (security) updates and/or service packs.

You may have misconstrued what I was explaining. In VS 2008, when you do a target framework, there are 3 options listed: 2.0, 3.0, and 3.5 frameworks.

If you have 2.0 installed, 2.0 SP 1, and 2.0 SP2 installed and you target 2.0 in VS2008, it compiles with 2.0 SP2. Same with 3.0 and 3.5.

The highest installed version of *each* framework when doing a targeted framework.

Eddy Vluggen wrote:
How does it handle the differences now? Does it update an XP installation if SP1 for .NET 2.0 is not installed? If so, do you *overwrite* the old libraries, or do you *add* the new versions to the GAC?

We have a few assemblies that rely on interop, so all files are copied into each program's directory on the client from a shared directory. If the client = Win98 it copies down the 2.0 versions; if XP or higher it copies down the 2.1 versions.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

MehdiMousaviNezhad17-Nov-08 1:14

MehdiMousaviNezhad

17-Nov-08 1:14

I have A TableAdapter and wana To assign
Null value To It's Parameter
I use Dbnull.value But I cant

Dave Kreskowiak17-Nov-08 5:22

Dave Kreskowiak

17-Nov-08 5:22

Without seeing the code that's having the problem and the error messages, it's pretty much impossible to tell you what you're doing wrong.

A guide to posting questions on CodeProject[^]

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

MehdiMousaviNezhad26-Nov-08 1:29

MehdiMousaviNezhad

26-Nov-08 1:29

I have this code in as Procedure in SqlServer

alter PROC Aut.SpGetArshive(@userId Int,@SecID bigint)
AS
BEGIN

SELECT *,str(isnull(a.Row,0))+' '+a.Title+ ' ('+a.Zonkan+')' AS des FROM aut.Archive a
WHERE (a.UserId IS NULL AND a.SecId=@secId) OR (a.SecId IS NULL AND a.UserId=@userId)

END

and have this table adapter in vb.net 2005 dataset

SpGetArshiveTableAdapter.Fill(Me.Ds.SpGetArshive, UserID, SecID)

and I wana pass null value to userId but Icant
I Use
SpGetArshiveTableAdapter.Fill(Me.Ds.SpGetArshive, dbnull.value, SecID)
or
SpGetArshiveTableAdapter.Fill(Me.Ds.SpGetArshive, nothing, SecID)
but there is Error
tanx

Dave Kreskowiak27-Nov-08 4:36

Dave Kreskowiak

27-Nov-08 4:36

How about a couple of examples of SQL stored procedure "optional paramters" -> http://weblogs.asp.net/rmclaws/archive/2004/02/18/75381.aspx[^], and http://sqlserver2000.databases.aspfaq.com/can-i-have-optional-parameters-to-my-stored-procedures.html[^].

The idea is to set the parameter to NULL (default value) inside the procedure, then just set the userID parameter in your code when you need to use it.

A guide to posting questions on CodeProject[^]

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

Strange multiline text control behaviour (VB.NET on VS2005)

MehdiMousaviNezhad28-Nov-08 21:08

MehdiMousaviNezhad

28-Nov-08 21:08

tanx
I changed my procedure .

mottolini17-Nov-08 0:47

mottolini

17-Nov-08 0:47

I'm a newbie with VS 2005.
I'm porting an app from VB6 to VB.NET, writing it from scratch.
I created a multiline text control and it works fine.
If i fill the control with the content from a string (like "txt_control.text = string") I'm not able to add text anymore. The only edit function that works is the delete and backspace key.

Any hint?

marco

Re: Strange multiline text control behaviour (VB.NET on VS2005)

~Khatri Mitesh~17-Nov-08 2:36

~Khatri Mitesh~

17-Nov-08 2:36

Hi Change the max length of the text box and try.
Thanks
Mitesh

~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA

Re: Strange multiline text control behaviour (VB.NET on VS2005)

mottolini17-Nov-08 2:44

mottolini

17-Nov-08 2:44

Thank you so much!
It worked!!!

VB SQL Stored Proc Problem

Paul Unsworth17-Nov-08 0:30

Paul Unsworth

17-Nov-08 0:30

Hi All

I have a stored proc in SQL which I call using VBA from a workbook. Although the App claims to have made the call successfully, it actually only gets to about 80% through the proc. When I run the proc manually, it works fine.
The proc does take a long time to run, so I'm thinking that it may be some crazy timeout that does not get noticed, or is ignored by VB when the ConnectionTimout and CommandTimeout properties are set to 0.

I'm using ADODB.Connection.

Does anybody have any idea's on this? I'm completely stumped. Frown | :(

Thanks

Re: VB SQL Stored Proc Problem

Dave Kreskowiak17-Nov-08 5:27

Dave Kreskowiak

17-Nov-08 5:27

The ConnectionTimeout property only describes how long the Connection object will wait for the connection request to open, not how long a connection will last.

The CommandTimeout proerty describes how long to wait for a request to complete. The default is 30 seconds. Now, there are TWO CommandTimeout's. One on the Connection object, and another on the Command object. Use the one on the Command object to extend the length of time to wait for a request to complete.

A guide to posting questions on CodeProject[^]

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

Re: VB SQL Stored Proc Problem

Paul Unsworth18-Nov-08 21:41

Paul Unsworth

18-Nov-08 21:41

Thats great. Thank you very much.

CrystalReportViewer Tab Control

Member 187686216-Nov-08 21:24

Member 1876862

16-Nov-08 21:24

Hi,

I am using CrystalReportViewer control to display a report in Visual Basic.Net application. My application has unique look and feel like Microsoft Office 2007 themes. I want to customize the CrystalReportViewer control to match my application look and feel. I know that the CrystalReportViewer control consist of 5 controls with PageView control being one of them. The PageView control contains Tab control to display the actual report.

My main concern is the Tab control of PageView control. I want to customize this Tab control to have transparent background color or some other color. I also want to have transparent color background or some other color background for the Tab control.

I hope I made myself clear.

Any help would be appreciated.

Thank You.

File not found

Subjugate16-Nov-08 19:43

Subjugate

16-Nov-08 19:43

I have a question here.. if i wan my application to continue even if it cant found the file tt i wan, wat can i do??

something like tt..

if "C:\Testing" = False
msgbox.show("found")
endif

i not sure if u understand my question i just dun wan my application to stop when the file is not found or not exist.

Anoop Brijmohun16-Nov-08 20:06

Anoop Brijmohun

16-Nov-08 20:06

try using this

If IO.File.Exists("C:\Testing") = True Then
Msgbox("Found")
End If

thanks
Anoop

Subjugate16-Nov-08 20:54

Subjugate

16-Nov-08 20:54

Thanks for the ans.

Jon_Boy17-Nov-08 3:00

17-Nov-08 3:00

could also use "if my.Computer.FileSystem.FileExists(strFilePath) then".

I have found the IO.File method to perform better if checking a large amount of files though.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison