Visual Basic Discussion Boards

skrtbh3-Jan-04 8:31

3-Jan-04 8:31

I'm pleased that you like it.
I'll provide some updates in future, just check:
www.madcode.net/download/quickaccess
from time to time.
[This site isn't available at the moment, but it will
be soon!]

Help Me pleas (i want to draw a sphere )

EmanAli27-Dec-03 11:37

EmanAli

27-Dec-03 11:37

i want to draw a sphere on a form in visual basic.NET
that looks like three D.

What is the way.

Help with DataAdapter.UpdateRowSource

mikasa27-Dec-03 5:37

mikasa

27-Dec-03 5:37

Hello, does anyone know how exactly this Property works for DataAdapters in .NET? Please do not give me MSDN Definitions...I've read all that.

Basically, what I need to know is...if I have set the UpdateCommand of a SQLDataAdapter to a StoredProc that has "Output Parameters", and I want those Output Parameters to then update the DataSet's Values after using the SqlDataAdapter.Update Method...Do I set the UpdateRowSource Property to "Both"?

Also, if the Adapter DOES happen to update the DataSet's values, will it tell me that the RowState has changed? Because I would need to know if the Output Paramters did modify the DataSet!

Comprende? WTF | :WTF:

To generate reusable code

Softtips200426-Dec-03 18:28

Softtips2004

26-Dec-03 18:28

I am retrieving a field from the database into a combobox.I have to retrieve the same data into the combobox in 3 different forms.How can i simplify this.Do i write a common procedure?

Re: To generate reusable code

mikasa27-Dec-03 5:07

mikasa

27-Dec-03 5:07

This all depends on how your Forms are related. Sometimes, if one Form is an Extension of another, simply use "Visual" Inheritance.

Typically, I write individual Sub Routines for each ComboBox (as opposed to one Massive Routine that Refreshes all Data in every control...blech!). If this is your case, and it seems you are using this in more than one Form, place your Routine in a Module and Pass the ComboBox as a Parameter so it can fill the correct one.

'In Module...

Public Sub RefreshCityList(ByRef CboList As ComboBox)
     'Place Logic Here...
End Sub

To display in a label

Softtips200426-Dec-03 18:11

Softtips2004

26-Dec-03 18:11

I have used the following code to display # in a label.But it is getting displayed only once.Why?
Private Sub Command1_Click()
Dim n, i As Integer
n = Val(Text1.Text)
Label2.Caption = ""
For i = 1 To n
Label2.Caption = "#"
Next
End Sub

Re: To display in a label

Dave Kreskowiak26-Dec-03 18:58

Dave Kreskowiak

26-Dec-03 18:58

Softtips2004 wrote:
I have used the following code to display # in a label.But it is getting displayed only once.Why?
Private Sub Command1_Click()
Dim n, i As Integer
n = Val(Text1.Text)
Label2.Caption = ""
For i = 1 To n
Label2.Caption = "#"
Next
End Sub

Your only getting one '#' because your overwritting the value in Label2.Caption 'n' times, your not appending to it. If you want to append to it then you have to do something like this:

Label2.Caption = ""
For i = 1 To n
    Label2.Caption = Label2.Caption & "#"
Next

Or you could simplify it even further and do it this way:

Private Sub Command1_Click()
Dim n as Integer = Val(Text1.Text)
Label2.Caption = new String("#", n)
End Sub

RageInTheMachine9532

Re: To display in a label

27-Dec-03 2:47

hey it is so simple
the code is given here

Private Sub Command1_Click()
Dim n, i As Integer
n = Val(Text1.Text)
Label2.Caption = ""
For i = 1 To n
Label2.Caption = Label2.Caption + "#"
Next
End Sub

Any Problem Contact me
Cool | :cool:

VickyMD a Specialist in Message Digest Security
i think so i m posting it 2 seconds late
sorry for that

Re: To display in a label

mikasa27-Dec-03 5:08

mikasa

27-Dec-03 5:08

You can simplify the "Concatenation" like this...

For i = 1 To n
     Label2.Caption &= "#"
Next

How to Unload a DLL from and Aplication in VB.NET

elRaptor26-Dec-03 10:30

elRaptor

26-Dec-03 10:30

Hello All:
I hope you can helpme whit this, I am not sure if it can be done, but someone knows how to unload a DLL from an aplication in VB.NET, this because I need to update the file or deleted, but when I try to delete the file I get and error, this is because the file is been use by the aplication so I need to remove the reference in runtime, any ideas?.

ElRaptor

Re: How to Unload a DLL from and Aplication in VB.NET

Colin Angus Mackay26-Dec-03 13:35

Colin Angus Mackay

26-Dec-03 13:35

There is a nice article on MSDN that might help. It's at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncscol/html/csharp03122002.asp[^]

The examples on the page are written in C#, but that's okay because it's all .NET Big Grin | :-D

so will work also in VB.NET.

I hope this helps... Smile | :)

--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

Re: How to Unload a DLL from and Aplication in VB.NET

elRaptor30-Dec-03 7:35

elRaptor

30-Dec-03 7:35

Thanks Colin: I am going to try this option, and I will let you know.

Thanks again

Javier Ayala

window name

pnpfriend26-Dec-03 5:17

pnpfriend

26-Dec-03 5:17

Hi all.. I want to know the MS Word and PowerPoint application names.
I want to use FindWindow() to find out whether the application is already exit
I know whether MS Excel application already open or not by using following statement

<br />
hWnd = FindWindow("XLMAIN",0)<br />

XLMAIN is application ID for MS Excel..
Can Anyone tell me what is the ID string for MS Word and PowerPoint?

error message in vb

sandysandeep200225-Dec-03 8:36

sandysandeep2002

25-Dec-03 8:36

from from front end vb 6.0 able to insert the date value into backend MSAccess table, having a single field with a datatype as date/time, using date picker control (project>components>slect file mscomct2.ocx), but i was unable to select a date from the same backend table, from vb 6.0 and received this error msg - "Data type mismatch in criteria expression" kindly provide with solution

regards,
sandeep

Re: error message in vb

Shinde Vikram27-Dec-03 3:41

Shinde Vikram

27-Dec-03 3:41

First up all
tell me what Control you are using to select a date from the database?
and also tell me what kind of technique u r using to get the date?

Mad | :mad:

You Must Specify Your Problem Clearlly

VickyMD A Specialist in Message Digest Security

Date & Time of Server

Manimee24-Dec-03 21:40

Manimee

24-Dec-03 21:40

Hi friends, How do i get the date & time of the server in a client machine. I m using SQL server as backend and VB 6.0 as frontend tool. Pls help me in this regards. Thanks

arutperunjothi thaniperungarunai

Re: Date & Time of Server

Shinde Vikram27-Dec-03 3:34

Shinde Vikram

27-Dec-03 3:34

There are Two Options for it

1)Synchronize the client while logging
2)Create DCOM, Run it on server. Create Object on Client
Write a method in DCOM Class to return Date and Time

i m telling u the technique to get the date and time from the Server
Cool | :cool:

VickyMD A Specialist in Message Digest Security

Error Loading DLL

Sid_smily24-Dec-03 8:31

Sid_smily

24-Dec-03 8:31

Hi,

I have made a DLL in Visual C++, and have been using it in Visual Basic. Now after several updations of my DLL when i try to add the reference of my DLL again it gives a error box "Can't add a reference to the specified file". Now can any one please help me wut can be the problem.

I have created the DLL in Visual C++ using the MFC App Wizard (dll), and the strange thing is that once it was running ok but now it doesnt.. any clues? or further readings suggested?

Siddique Ahmed
Senior Software Engineer
Telelogix Software
(www.telelogix.com)

how generate a file ?

Member 61203224-Dec-03 1:05

Member 612032

24-Dec-03 1:05

hi, i'm looking for an answer but i don't have anything...
i'm trying to make a exe like this:
the user types a value in the textbox and when he/she cliks in OK the exe generate ( make ) a file with that information in a directory. cool isn't it ? i´ve already written the code but i need know about the lib necessary !
" DLL entry point generate "

thanks !!!

Re: how generate a file ?

Dave Kreskowiak24-Dec-03 8:42

Dave Kreskowiak

24-Dec-03 8:42

silveiro wrote:
the user types a value in the textbox and when he/she cliks in OK the exe generate ( make ) a file with that information in a directory. cool isn't it ? i´ve already written the code but i need know about the lib necessary !
" DLL entry point generate "

Ummm...This doesn't make any sense what-so-ever.
What is the value for?
What kind of file is to be generated?
What directory, where?
What is the 'lib' your looking for supposed to do?
And what's with the comment "DLL entry point generate"?
Are you looking to generate a .DLL file for another app?
What's the app you generating for and what's this generated .DLL supposed to contain?
And to top it all off, are you using VB6 or VB.NET to do this?

RageInTheMachine9532

VB and AutoCAD2002

Ritesh Sompura24-Dec-03 0:51

Ritesh Sompura

24-Dec-03 0:51

Hi! All,

I am creating simplified front-end in VB6/VB.NET, which allows very limited facilities to the user. It allows user to view drawings from different angles(3D Orbit), allows to fill surface with different colors or fill the surface with pictures. User is not suppose to have any other facility than this.

Now, I don't want use COM object application, as it opens another instance of Application which allows user to manipulate drawings in many different ways.

Is there any control (OCX) which allows user to preview drawings? or any other approach?

Suggestion is always welcomed.

Thanking You,

Ritesh.

Re: VB and AutoCAD2002

CortPlayer24-Dec-03 9:50

CortPlayer

24-Dec-03 9:50

The OCX you need can be found AT http://www.cadology.com

Regards,

Thunis

VB6 CallByName

Davy Mitchell23-Dec-03 23:18

Davy Mitchell

23-Dec-03 23:18

Hi All,

VB6 CallByName only seems to return a generic Error if one is thrown (ERR.DESCRIPTION : Invalid procedure call or argument). Is there someway of getting my specific custom error messages?

Thanks,

Davy

My Personal Blog - Homepage.
Scottish News - Angus Blog, Perth Blog and Dundee Blog

Re: VB6 CallByName

Dave Kreskowiak24-Dec-03 8:55

Dave Kreskowiak

24-Dec-03 8:55

How are you generating your custom errors?

It's been a long time since I did VB6 so I may be wrong on this. But to generate a custom error, I think(!), you had to something like this:

Err.Raise vbObjectError+(your error number), (Source as String - optional), (Description as String - optional)

RageInTheMachine9532

Why i have Login failed using SQL

jlizardo23-Dec-03 15:57

jlizardo

23-Dec-03 15:57

Hi everyone;

Ok, I finished my application using SQL 2000 server. But when I install in other machine and startup the application a error occur "Login Failed For user 'JLMACHINE\guest'".

I don't know why this error occur because in my machine works. please help me on that.

Johnny Lizardo.

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