|
Search for "Code: Reading Excel Data into a Dataset [Visual Basic]" in VB's help or on the Web. The rest of the solution is left to the student.
If "to err is human", programmers must be superhuman...
|
|
|
|
|
Hi there guys.
Am using the VSI to create an MSI package for some ocx's. AM able to get them all to install correctly, and register etc, but unfortunately, I need to create my directory structure in the root of the C: drive. (For reasons too long winded to go into here, that I don't necessarilly agree with  )
I seem to be unable to specify the default install dir to be here - only in a subdirectory of the Program files dir - does anyone know how to do so?
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Have you read the Platform SDK help on the Directory table in Setup/Installer Database/Installer Database Reference/Tables/ in the SDK help?
This explains how to set the target directory in a number of different ways. Might help, might not....
Cheers
Steve S
This developer for hire
|
|
|
|
|
Aha - seems a bit inpenetrable though...
So am I correct in assuming that I would need to follow the following steps:
1. Create my MSI with the incorrect default dir
2. Write an app that opens it, changes the default dir, saves changes then closes it
3. Run the MSI...
Or is it more convoluted than that? Think that I can see what it's saying, but may probably be simpler to just take the hit...
Have tried Installshield / Wise, and they both seem to suffer from the same problem...guess that they're all based on the same thing...
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
More simplistically, have you verified that overriding TARGETDIR will give you what you want?
eg:
msiexec /i mypackage.i TARGETDIR=C:\
(This works in most instances, for example, a well-known GIS company uses a variant of same to install COM+ components in known locations  )
Steve S
Developer still for hire
|
|
|
|
|
Have given that a bash, and it does indeed default to where I want it to be...
Question is, how do I actually go about overriding TARGETDIR? Am very puzzled by this one!!
(Thanks for all the help Steve!!)
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
You could write a simple wrapper for the installer (or get someone to do it for you!) which uses CreateProcess or similar to run MSIEXEC with those arguments, or you should also be able to use something like ORCA to modify the MSI itself as per the comments in the Platform SDK.
You do have a current Platform SDK, don't you Rich?
What you really need, of course, is a highly paid (if somewhat egocentric) colleague who can do all this stuff, yet still manage to reflect enough glory to let you impress your boss... 
Steve S
Developer for hire
|
|
|
|
|
Dear All,
Is # a keyword in VB. If it is then wot is its significance?
____________________________________________________________
rishabhs
I think therefore I am.
|
|
|
|
|
Tends to be used (in VB6 at least) in the following:
<br />
Open "C:\SomeFile" for Input as #1<br />
May be other uses, but not seen them myself...
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Yes, you could call it a reserved word. The '#' character has the following uses:
As a Double type specifier. These two statements are identical:
Dim myDbl As Double
Dim myDbl#
and this will denote the number should be treated as a Double:
myDbl = 123.45#
As the prefix to a compiler directive:
#Const Version = "1.0"
#Region "This is a Region directive"
#EndRegion
RageInTheMachine9532
|
|
|
|
|
Hi,
I want to make some of the Text of RichTextBox i have used in my project, readonly or non editable, can anyone please help me
thanks
Be Humble in Victory and Strong in Defeat. -Het
|
|
|
|
|
Try setting it's Enabled property to false...
Can still set and get text through code, but the user can't do anything with it at runtime.
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Yes thats what i want, i want to only make some text to be enabled false and user will not be able to edit it at runtime, rest all text he can edit and make changes. have got those text which are to be make readonly by highlighting it with different color no just have to make it non-editable.
thanks
Be Humble in Victory and Strong in Defeat. -Het
|
|
|
|
|
In that case, you'd have to derive a new RichTextBox control and supply your own code for tracking which sections of text are ReadOnly. With the current RTB control, this isn't possible. The problems I see are how your going to track the sections of text that are ReadOnly and where this information is going to be stored with the document. Another problem is that a user can simply open the entire document in WordPad and your ReadOnly information will no loner be ReadOnly.
RageInTheMachine9532
|
|
|
|
|
i already have those words which are to be enabled false, as they will be delimited by special characters which will not be used by the user when he will be writing that template in RichTextBox, other thing is i will b storing that file in database henceforth it will not be opened in any other editor except mine, then fields which i am making enabled false will be dragged from say listbox to the richtextbox. its just like mail merge sort of application, in MS.Word. i am not able to write the Readonly Property for RichTextBox. if i can get a start.
thanks
Be Humble in Victory and Strong in Defeat. -Het
|
|
|
|
|
The more I think about it ...
You can't use the RichTextBox control for this. You'll have to write your own control, POSSIBLY inheriting from the RichTextBox control. Your going to have to supply your own code for determining exactly where the cursor is and when the cursor is in a ReadOnly field or not. You WILL essentially be writing your own editor control. I don't know of, and can't find, a control with the support your looking for, so it looks like you'll be writing it from scratch.
RageInTheMachine9532
|
|
|
|
|
If this "read only" text is a header or footer, you can use a borderless label to hold the non-editable text. You will have to parse the RTF file to extract the text but you must be doing that if you are highlighting it.
The remaining text will go to the RichTextBox. The RichTextBox will also be borderless and both will be in a "frame" to make them appear as one.
If "to err is human", programmers must be superhuman...
|
|
|
|
|
hello, i am a student studying in one college in malaysia. now i facing one problem in my project that is how can i control or write an simple system to control the network bandwidth?? or the vb.net it self have the build in function or libraries that we can use it to control the bandwidth in the network enviroment? i mean that when you are the server, then you can control the bandwidth in your network workstation( mean sender to receiver)
thanks
|
|
|
|
|
soon hoo wrote:
simple system to control the network bandwidth
This will be anything but simple. You would probably have to write a filter driver to get the kind of control you want. Brush up on the Windows DDK, kernel debugging, writing and testing drivers, ... There is no Windows API to do this. Your driver will have to sit between the protocol driver and the network card driver. Here you could control the pacing of what is sent out to the network card. You would have to include some kind of DeviceIoControl interface so you can tell your driver what to do, like at what speed you want packets to be sent.
RageInTheMachine9532
|
|
|
|
|
Another place to look is the "Quality of Service" layer in Windows.
(Got the correct thread this time!)
If "to err is human", programmers must be superhuman...
|
|
|
|
|
sorry for the cheesy topic name....
Anyway, i have project with a fairly low data-volume. I am running it off of an access database at the moment.
I believe this makes it less portable as the user must have access to use it that way (right???). would i be better off just using a flat file? we're talking about three small tables with a an average of about 6-7 complete records.
thanks
serenity now, insanity later - lloyd braun
|
|
|
|
|
Hi there. Access .mdb files are actually very good for low volume, desktop (i.e. non-shared) databases. Your code just needs the Jet provider installed on the client machine - which is a standard part of MDAC (as opposed to a full copy of Access). So you're probably just fine using it.
Of course, with only six or seven complete records you may do just fine to use an XML file to store your data. If you're using .Net, you could read the file into an XmlDataDocument and treat it as either an XML document or a DataSet.
|
|
|
|
|
Another place to look is the "Quality of Service" layer in Windows.
If "to err is human", programmers must be superhuman...
|
|
|
|
|
OOPS... Wrong thread! (See thread above)
If "to err is human", programmers must be superhuman...
|
|
|
|
|
How do I open the Dos window and run a batch file within a VB6 application. I have found code that runs batch files, but it does not show the Dos prompt. I need to somehow in VB6 open the Dos console and run a batch file where they have a chance to enter a password for sftp. Anyone have any ideas?
I am using OpenSSH sftp and so far have built a batch file they have to access from their desktop and enter a password and run a whole bunch of other commands. It is very confusing to them because they do not have much computer experience.
-Garrett
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
