Re: Multiple access to Single Database - Visual Basic Discussion Boards

Dave Kreskowiak26-Oct-04 6:37

26-Oct-04 6:37

It's called "bootstrapping". You can't include the .NET Redistributable in the .MSI that contains your application because one of the pre-launch conditions for install is that the .NET Framework already be installed! So, you must use a non-.NET managed application as a Setup program to check for the required software that must be installed, and unpackage and launch the appropriate installers for them, then, lastly, launch the .MSI setup for your application.

See this[^] excellent article on CodeProject for an example and explanation.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Building Wizards

shevi202726-Oct-04 2:55

shevi2027

26-Oct-04 2:55

Hello

I want to make a wizard like the once in Access where we can find the path and select a database then the table and then the fields we want to work with..Is it possible? D'Oh! | :doh:

Like is there any kinda ActiveX controll or some software Confused | :confused:

I really would like to know..So if you know please tell me..
Thank you very much.. Big Grin | :-D

Have a nice day! Smile | :)

Remote COM invoking vb.net

Kumar0926-Oct-04 2:40

Kumar09

26-Oct-04 2:40

hi,
Can anyone provide me an example ..on how to invoke COM objects remotely..in three tier environment. (what are the command that i should issue in my vb program for invoke the dll rather than using a manuall add reference.)

Meaning i need to issue a command telling my program where is the dll reside..on other words add runtime reference in my program in order to invoke the COM (dll) file.

thank you

kumar

Display in List View

Member 146985226-Oct-04 2:21

Member 1469852

26-Oct-04 2:21

Still new to programming. I have a form with a Check box and a combo box. I want to be able to display the Name of the checkbox (ie. Hamburger) and the quantity displayed in the combobox over in the ListView box.

Check Box = chkHamburger
Combobox = cboHamburger (field contains 1,2, 3, 4)
Example

1 Hamburger

msscript.ocx

iambhushan26-Oct-04 1:15

iambhushan

26-Oct-04 1:15

hello friends,
i am new to the forum as well as development field.
can anybody help me out with using msscript.ocx for running scripts?i want to make a COM object utilising msscript.ocxwhich will be provided with the cript and language of it(javascript,vbscript) and it will run that.
pls help.

Re: msscript.ocx

Dave Kreskowiak26-Oct-04 4:14

Dave Kreskowiak

26-Oct-04 4:14

?????????? What kind of problem are you having? What you said amounts to "I want my component to run a script using msscript.ocx". Are you talking about adding scripting support to your application?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Multiple access to Single Database

payal sheth25-Oct-04 23:52

payal sheth

25-Oct-04 23:52

hello all...

i have a database in Access 2000...i want to access single database from multiple location...how can i do in VB .net...i have tried accessing the database by Imports System.Data.OleDb...its giving error saying "The Jet microsoft database is already exclusively opened by another user...or you may not have rights to access it.."
if accessing the single database on server through multiple exe then giving above error....let me know if anybody has solution how to do it....

thanks in advance

Re: Multiple access to Single Database

J4amieC26-Oct-04 0:40

J4amieC

26-Oct-04 0:40

An exclusive lock is only placed when somebody has it open on the desktop. Multiple OleDb connections are ok, just no combination of desktop user and OleDb user.

Re: Multiple access to Single Database

Dave Kreskowiak26-Oct-04 4:10

Dave Kreskowiak

26-Oct-04 4:10

If someone has the database open in Access it will be locked exclusive. Also, make sure your application is running under an account that has Read and Write rights to the folder where your database resides. If you don't have Write access, then your database will appear locked.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Building Wizards

shevi202725-Oct-04 22:51

shevi2027

25-Oct-04 22:51

Hello.
Can someone tell me if it is possible to build my own wizards and if yes how ??

Thank you.
Shavonne.
shevi2027@msn.com
Smile | :)

Re: Building Wizards

MohammadAmiry26-Oct-04 0:14

MohammadAmiry

26-Oct-04 0:14

Yep! you sure can.
The main idea is to make a form, with the buttons 'Back', 'Next' and 'Cancel'
then pacing a frame array on that: Frame1(n) that all have their Visible property set to False.
each frame is presenting the face of a wisard step.
(the frames must all be of the same size and must overlap each other completely.
then simply in the click events of next and back buttons, try showing the propper frame (makeing it's visible property True and the Visible property of the previous Frame to False)

now try designing each step on it's own Frame!
so simple yeah?

(VB Wisard Manager helps you do the same thing in VB6 but the idea is still the same.)

Re: Building Wizards

shevi202726-Oct-04 2:00

shevi2027

26-Oct-04 2:00

Thank you. I want to build a wizard like where you can select the database and then select the table(like access)...Is there any kinda activex control or software i can use for this ???

Thank you.

Windows Service

maykut209925-Oct-04 13:34

maykut2099

25-Oct-04 13:34

How can I deploy a Windows Service to Remote Computers on my network by selecting either the IP ot their Computer name.
Cry | :((

dataset basic navigation / traversing

JenniferH25-Oct-04 12:38

JenniferH

25-Oct-04 12:38

Hi, Please forgive me for the simplicity of the question, and the redundancy. I have searched the forum and believe my answer is out there amongst the multiple dataset question/responses, but I am such a newbie that I am having trouble putting together the information I need...Ok, enough, here's what I am trying to do:

I am making a call to a third party API that returns a dataset. I need find out if there are any rows returned, and if so pull out the data from a couple of the columns...

More specifically, I get the dataset. Each row contains many columns, the three I need to get are BuySell, ControlValue, and Price.

Can someone toss out to me the simple code for traversing through the dataset and pulling out the values from these columns.

Many Thanks -
Jennifer

control array for addins

shinay25-Oct-04 10:25

shinay

25-Oct-04 10:25

I am trying to add dynamic drop down menu in my office com addin
toolbar. I use control array for drop down menu, but
I can only get the event for the first one instead of each menu item

how can I fix this so that events can be generated in each menu item

Dim WithEvents cbeButton As Office.CommandBarButton
Dim cbcButton() As Office.CommandBarButton

private sub CreateMenu()

for i = 0 to 3
ReDim Preserve cbcCatalogButton(i)
cbcButton(i).caption = i
set cbeButton = cbcButton(0)
next i

end Sub
Private Sub cbeCatalogButton_Click(ByVal Ctrl As Office.CommandBarButton, _
CancelDefault As Boolean)

msgbox "hello"
end Sub

Com Interop & Deployment

Geopsaros25-Oct-04 7:04

Geopsaros

25-Oct-04 7:04

I have added a reference for sqldmo.dll to my project and i am succesfuly using the com interop to script my database objects. But, when i am deploying the project to another pc with win2000 i receive the following
error :

"COM object with CLSID {xxxx-yyyy-......} is either not valid or not registered"

What am i doing wrong?

thanks in advance.
G.

Simple String Question

cwayman25-Oct-04 5:40

cwayman

25-Oct-04 5:40

Hey

I need to trim 4 characters off the right hand side of my string and am having a little trouble doing so.

For example "Hello.doc" becomes "Hello"

I could use split at "." but this wont stay constant if there is a "." in the filename itself

Thanks for your time

chris

Re: Simple String Question

Mike Ellison25-Oct-04 6:17

Mike Ellison

25-Oct-04 6:17

Hey, Chris. You could try:

dim s1 as string = "Hello.doc";
dim s2 as string = Left(s1, Len(s1) - 4)

Or, if you're dealing with file/path names and want to extract portions of it (say just the filename, or just the extension, that sort of thing) have a look at the System.IO.Path class.

Re: Simple String Question

Mekong River25-Oct-04 21:18

Mekong River

25-Oct-04 21:18

Hi, I might have the similar question too. I use an OpenFileDialog for user to select the file and they select TheFile.doc, How could I know that user select file extension with .doc? Can you help that? Because I want to check the 4 character from the right side.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Re: Simple String Question

cwayman25-Oct-04 21:45

cwayman

25-Oct-04 21:45

Hey,

Thanks Mike, i will try that.

The man from .... you have to store the filename from teh openDialogBox and use the code that mike has said.

Hope this helps

Thanks

Chris

data grid control in visual basic.net

Kumar0925-Oct-04 4:28

Kumar09

25-Oct-04 4:28

Hi, I'm KUMARAN KALIDAS Smile | :)

First I would like thank to all the ppl behind the codeproject, coz it really help me in terms developing a .net application with various examples..thank you again..since i'm new developer for the .net environment.

I need a help, in order for me to use a datagrid control in my visual basic.net project. I would like to use datagrid as a data input screen rather than using it to display data.

How can use datagrid control as transaction input screen which contain validation as well.

I would appreciate if anyone could help to provide me with a sample source code..I hv search tru msdn for .net but the sample was almost for data display purpose only.

thank you guy's for code project

kumar

Re: data grid control in visual basic.net

Desi Bravo31-Oct-04 3:05

Desi Bravo

31-Oct-04 3:05

First of all you must consider the following:
are you using sql connection or an OleDbDataAdapterconnection.
The difference with the two is the coding and where the port is located.
I am thinking that you're on the MSAccess database which you will need to use the OleDbDataAdapterconnection for your project.

Using the MSAccess database you must first create a blank database through Access. Open your Access database, click on Blank Table, and click on the design view this will take you to the tables configuration. You will see a number of fields. In the Field Name you will input all your information about what you want to create in a datagrid. E.G. Addresses in the Field Name you will input "First Name, Last Name, Address, City, State, Zip Code, Telephone Number." For each field you will single click to select them then you will go down and validate your entry. Email me to give a good perspective of how to create the database and use the datagrid in vb.net.

bravo659

Network drive in a TreeView

Brad Fackrell25-Oct-04 2:52

Brad Fackrell

25-Oct-04 2:52

Can anybody tell me how to list a network drive in a TreeView?

I currently list my drives this way:

Dim driveList() As String<br />
driveList = System.Environment.GetLogicalDrives()<br />
treeDirStructure.BeginUpdate()<br />
Dim x As Integer<br />
For x = 0 To driveList.Length - 1<br />
    Dim tvn As New TreeNode<br />
    tvn.Text = driveList(x)<br />
    Select Case GetDriveType(driveList(x))<br />
        Case DRIVE_REMOVABLE<br />
            tvn.ImageIndex = 0<br />
            tvn.SelectedImageIndex = 0<br />
        Case DRIVE_FIXED<br />
            tvn.ImageIndex = 1<br />
            tvn.SelectedImageIndex = 1<br />
        Case DRIVE_CDROM<br />
            tvn.ImageIndex = 2<br />
            tvn.SelectedImageIndex = 2<br />
        Case Else<br />
            tvn.ImageIndex = 0<br />
            tvn.SelectedImageIndex = 0<br />
    End Select<br />
    treeDirStructure.Nodes.Add(tvn)<br />
Next x<br />
treeDirStructure.Nodes.Add("C:\Targets")<br />
treeDirStructure.EndUpdate()

..but I can’t figure out how to list a network drive or other things like ‘My Computer’.

Thanks.
Brad

How to combine VB6.0 and C++ ???

john_tran24-Oct-04 19:33

john_tran

24-Oct-04 19:33

I want to create an application that using VB6.0 for the GUI, and using C++ for the source. How can i do that?
Show me step-by-step to create an application like that.
(Assume that i have a file "exm.cpp" that contain all contents that my application need (contain include statements, Functions statements, and main statement), do i need to change my source to use with VB ? And how to change?)
Thanks

Ask More - Learn More
JohnJone

Re: How to combine VB6.0 and C++ ???

incubusfan24-Oct-04 23:58

incubusfan

24-Oct-04 23:58

Hi
In short, you can't. The languages aren't interchangeable, and the nearest you could get is to wrap your c++ routines into a dll that can be used from within VB.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.