Visual Basic

17-Jun-04 11:50

That's Intellisense doing that. Smart Tag support will show up in VS.NET 2005...

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

Returning a unique value

Vicetta15-Jun-04 4:01

Re: Returning a unique value

15-Jun-04 4:01

I have a script which inserts a new record into a sqlserver database.

I have ListID as the primary key (autonumber). I need to find a way of returning this number once I have saved the first part of the record, as on the next page I save some other fields of the same record.

Does anyone have any ideas?

Cheers, V

VenkatFor.NET15-Jun-04 4:18

VenkatFor.NET

15-Jun-04 4:18

Insert the record into DB using a Stored Procecure with one Out parameter. This will have the value @@Identity set in the stored procedure as follows.

SET @OutParam = @@Identity

Bhaskara

Re: Returning a unique value

Vicetta15-Jun-04 22:43

Re: Returning a unique value

15-Jun-04 22:43

Thanks I have it returning my value now,

Cheers, V

Robert M Greene18-Jun-04 11:09

Robert M Greene

18-Jun-04 11:09

http://www.databasejournal.com/features/mssql/article.php/10894_3307541_2[^]

.............................
There's nothing like the sound of incoming rifle and mortar rounds to cure the blues. No matter how down you are, you take an active and immediate interest in life.

Fiat justitia, et ruat cælum

How to ...?

Cheng Zhong15-Jun-04 2:42

Cheng Zhong

15-Jun-04 2:42

I'm using VB.NET, I wonder...

1. How can I capture a specified area of screen ? User must be able to select the area they want to capture by mouse.

2. How can I set "Compressed" or "Encrypted" attribute to a file ?

3. How can I get the Icon List in an EXE or a DLL file ?

Thank you for helping!

How to shutdown computer in WinXP?

Cheng Zhong15-Jun-04 2:27

Cheng Zhong

15-Jun-04 2:27

I wonder how we can shutdown / restart / sleep down / suspend our computer using VB.NET? Confused | :confused:

Please don't tell me to use SHUTDOWN.EXE, it doestn't support sleep computer!

Thank you!

Re: How to shutdown computer in WinXP?

Dave Kreskowiak15-Jun-04 6:14

Re: How to shutdown computer in WinXP?

15-Jun-04 6:14

You would have to P/Invoke the SetSystemPowerState function in Kernel32. But! 8) You can't force the system to suspend or sleep whenever you want. The system and applications can deny your request, even if you set fForce to True.

Declare Auto Function SetSystemPowerState Lib "kernel32" ( _
   ByVal fSuspend As Boolean, ByVal fForce As Boolean) As Boolean

The docs for SetSystemPowerState are here[^].

Alternatively, you could use SetSuspendState:

Declare Auto Function SetSuspendState Lib "PowrProf" ( _
   ByVal Hibernate As Boolean, ByVal ForceCritical As Boolean, _
   ByVal DisableWakeEvent As Boolean)

The docs for SetSuspendState are here[^].

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

Cheng Zhong15-Jun-04 17:05

Cheng Zhong

15-Jun-04 17:05

Thank you!

E-mail: zc_djx@hotmail.com

I'm learning VB, you are always welcome to help me!

question

ahmad_yossef15-Jun-04 2:06

ahmad_yossef

15-Jun-04 2:06

how to merge a server file with another file using visual basic
i want merge it with a lot of extension exe , mp3 , wav , mid , bmp , jpg and other extensins

Lost & Forgotten

Dave Kreskowiak15-Jun-04 2:40

15-Jun-04 2:40

What do you mean by "merge"? Copy the files to another location? Or append one file to another? ...?

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

ahmad_yossef15-Jun-04 13:41

ahmad_yossef

15-Jun-04 13:41

append one file to another like the servers merging to exe files or bmp files

Lost & Forgotten

Dave Kreskowiak15-Jun-04 14:56

15-Jun-04 14:56

The resulting file would not be usable until you took the files apart and put them back into the directory structure. You would need a method to sort out where the file boundries are in the composite file so you can determine where one file stops and the next begins.

Servers don't merge files together. Where did you get an idea like that?

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

ahmad_yossef15-Jun-04 20:52

ahmad_yossef

15-Jun-04 20:52

i mean when we create a server file in hacking program we find a button that make merge to server file with another file to deceive the one will take the server
like in sub7 program there is an option to bind server with exe file

Lost & Forgotten

Dave Kreskowiak16-Jun-04 2:23

Formatting to 2 decimal places

16-Jun-04 2:23

Sub7 is an hacker "tool" (Trojan horse, really) that allows someone to take over your computer, without you knowing about it.

Your talking about installing code into another .EXE. This requires in-depth knowledge of the PE executable format and how the Windows Loader works. Since this technique is used nearly exclusively by hackers and virus writters, no, I'm not telling you how to do it.

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

Vicetta15-Jun-04 0:57

Re: Formatting to 2 decimal places

15-Jun-04 0:57

I have some figures which i store in label and textbox controls. I have used cstr(system.math.round(figure, 2)) to get it to round to 2 decimal places. What I can't find out how to do is to make it have 2 decimal places whether it needs them or not i.e. £ 24 would become £24.00.

Does anyone know a quick way that i can so this? Confused | :confused:

Cheers, V

Serge Lobko-Lobanovsky15-Jun-04 1:18

Serge Lobko-Lobanovsky

15-Jun-04 1:18

Hi,

Try this one:

<br />
Dim num As Decimal = 24<br />
MsgBox num.ToString("##,##.00")<br />

Regards,
Serge (Logic Software, Easy Projects .NET site)

Re: Formatting to 2 decimal places

Vicetta15-Jun-04 1:47

Re: register Ocx while setup project

15-Jun-04 1:47

Thank you very much - that works a treat Big Grin | :-D

Cheers, V

Anonymous14-Jun-04 22:23

Anonymous

14-Jun-04 22:23

hi all,
i would like to register OCX while setup of vb.net project running ,can any one tell me the way

thank you

anom2m15-Jun-04 9:06

anom2m

15-Jun-04 9:06

try to use property called register for that ocx and make it comselfregister

VB6 DAO Class Reference

xfitr214-Jun-04 18:07

xfitr2

14-Jun-04 18:07

Does anyone know where I might be able to find a good reference that explains all the properties, functions, and classes of the DAO Reference Library? I am trying to learn how to use the Parameter Class and would like to read up on the rest. I have search google multiple times, but can not come with anything. I can't even find a good reference book at B&N. Thanks in advance.

Re: VB6 DAO Class Reference [EDITED]

Dave Kreskowiak15-Jun-04 2:38

Re: VB6 DAO Class Reference

15-Jun-04 2:38

That's because DAO has been obsolete for years now. The replacement is ADO inside the Microsoft Data Access Components. Since I can't get to MSDN now (DNS is failing), go to http://msdn.microsoft.com/data[^] and look through the docs there.

[EDIT]
You might also find the docs for DAO in the MSDN Library Archives. Go to http://msdn.microsoft.com/archive/[^] to see if they still have the docs...

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

Mekong River15-Jun-04 4:38

Mekong River

15-Jun-04 4:38

Yes, there a is a little bit difficult for a people who want to learn DAO in the .NET technology era. I would like to recommend you a book, but it might be old for you to learn and it might be difficult to find it in the bookstore. As I remember, try to find the books titled “Programming DAO” published by Microsoft Press. I forgot its author name, but I think this one is the good one. Try to learn VBA books in Access 97 also teach you about DAO technology. If you have MSDN Library January 2000, then there is also a section teaching you to learn DAO Reference. Office Developer documentation also the best place for learning DAO and ADO technology.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

Re: VB6 DAO Class Reference

xfitr215-Jun-04 5:22

xfitr2

15-Jun-04 5:22

Thanks for the information. I will try to find those books. I have had a lot more success with DAO over ADO and it seems to run faster, therefore I have been using DAO. I found some information about using the parameter class from Microsoft last night and it helped. I would just like to find a good reference for the whole object library. Thanks guys.

Re: VB6 DAO Class Reference

Dave Kreskowiak15-Jun-04 5:33