|
Thanks for the quick reply,
I have looked at that and it works great on a per file bases.
I am looking at doing about 700 small files at any given time and combining them into one large one to do queries and reporting.
Do you know of a mass convert utility? or have any coding help you can extend?
Thanks
|
|
|
|
|
suppose sql server is installed in a network server(or a network attached computer running XP)
and another computer wish to connect to that server through a vb application, what is the connection string
that we need to provide.
Or does it have a different approach????
raamay
|
|
|
|
|
|
hello,
I'm programming app to change the system time, but everytime I run this it only resets the time to "31/12/2007, 00:00"
can anyone take a look at my code and tell me where's my mistake?
Imports System.Runtime.InteropServices<br />
Public Class Form1<br />
Private Structure SYSTEMTIME<br />
Dim wYear As Integer<br />
Dim wMonth As Integer<br />
Dim wDayOfWeek As Integer<br />
Dim wDay As Integer<br />
Dim wHour As Integer<br />
Dim wMinute As Integer<br />
Dim wSecond As Integer<br />
Dim wMilliseconds As Integer<br />
End Structure<br />
<br />
Private Declare Function SetSystemTime Lib "kernel32" _<br />
(ByVal lpSystemTime As SYSTEMTIME) As Boolean<br />
<br />
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
Dim NewTimeDate As SYSTEMTIME<br />
NewTimeDate.wYear = 2006<br />
NewTimeDate.wMonth = 10<br />
NewTimeDate.wDay = 4<br />
NewTimeDate.wHour = 5<br />
NewTimeDate.wMinute = 5<br />
NewTimeDate.wSecond = 5<br />
NewTimeDate.wMilliseconds = 5<br />
If SetSystemTime(NewTimeDate) = True Then<br />
MsgBox("Done")<br />
End If<br />
End Sub<br />
End Class
thanks.
|
|
|
|
|
Hi,
the SetSystemTime() prototype states:
BOOL SetSystemTime(const SYSTEMTIME *lpSystemTime);
which means it needs a pointer to a SYSTEMTIME structure, hence passing "ByVal"
is wrong.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
didn't notice that
I tried now with ByRef, same result 
SetSystemTime() is really called, but time changes to 31-12-2007 00:00 which means that it's not passing parameters to the function?
|
|
|
|
|
Where did you get your SYSTEMTIME Structure? It is completely wrong.
Check the documentation, stop your trial-and-error methods.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
You should be passing the structure in ByRef AND you've defined all the fields in the structure as Integers (32-bit signed). They should be Shorts or Int16, 16-bit signed numbers:
Private Structure SYSTEMTIME
Public wYear As Int16
Public wMonth As Int16
Public wDayOfWeek As Int16
Public wDay As Int16
Public wHour As Int16
Public wMinute As Int16
Public wSecond As Int16
Public wMilliseconds As Int16
End Structure
WORD types in the documentation convert to Int16's (Short). DWORD's convert to Int32's (Integer).
|
|
|
|
|
thank you very much, works as a charm now
I'm not too much into winAPI programming just started to learn.
tnx for the help.
|
|
|
|
|
hi frnds,
i am using VB 6.0 (classic) and i want to get the amount of space remaining on my HDD including partitions.
the out put should be like
C: = 2 GB
D: = 7 GB
how can i do ....?
should i use WINAPI32 ....
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Hi,
you probably need to call function GetDiskFreeSpaceEx() in kernel32.dll
Another question by VIP Commando, right above this one, would show you how
these things can be done.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
thankx buddy for reply,
but the real problem is it returns the free space in Numbers of Bytes if there is HDD capacity more than 200GB then VB 6.0 fails to accept the range and throws the exception as "Sunscript outof range OVERFLOW"
what should i do ?
i have tried with "Long" and "Double" Type
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
koolprasad2003 wrote: what should i do ?
show the code.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Hi koolprasad2003,
I found this (put in in a new form ...)
Private Declare Function GetDiskFreeSpaceEx Lib "kernel32.dll" Alias _
"GetDiskFreeSpaceExA" (ByVal lpDirectoryName As String, _
lpFreeBytesAvailableToCaller As ULARGE_INTEGER, lpTotalNumberOfBytes As _
ULARGE_INTEGER, lpTotalNumberOfFreeBytes As ULARGE_INTEGER) As Long
Private Type ULARGE_INTEGER
LowPart As Long
HighPart As Long
End Type
Private Sub Form_Load()
Dim result As Long
Dim x As ULARGE_INTEGER
Dim y As ULARGE_INTEGER
Dim z As ULARGE_INTEGER
result = GetDiskFreeSpaceEx("c:\", x, y, z)
Debug.Print result
Debug.Print x.HighPart, x.LowPart
Debug.Print y.HighPart, y.LowPart
Debug.Print z.HighPart, z.LowPart
End Sub
Greetings, Thomas
|
|
|
|
|
hi all,
can i launch my application by pressing a key or key combination(mean define hot key) in visual basic 6.0 ?
Please guide me or provide me some link
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
You normally define a hotkey to launch your application in the shortcut to the application, not in the application itself.
|
|
|
|
|
hi all,
i want to determine total number of account(user) in system & current user which is logged in using visual basic 6.0
can anybody guide me or provide some link ?
any help will be appreciated.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
You can list the local accounts using most of the code from this[^] script.
|
|
|
|
|
Hello everyone!
I am interested in building a gantt chart component in vb .net. I've been around and saw alot of third-party components that are really good but the problem is I dont want to buy them but instead I would want to build one myself. It wouldn't have to be as great, just a basic one will do.
Given that there is many third party components out there, im conviced that it can be done! So in order to go ahead and build one, I assume i'll have to build a custom control, acquire knowledge in GDI+ and inherit and manipulate the datagrid component?
In my opinion, the Gantt Chart component should have the elements of rows and columns; rows so that bars can be in placed accordingly, the bars will be representing the duration for each task and the columns to represent a timeframe. The bars may consist of lines that will connect these bars with one and another to represent dependencies. Thus suggesting a line to be drawn thru GDI+ i suppose?
So with the basics of what im trying to create here, im pretty much clueless on how I'm going to go ahead and build one as I never build a custom control before.
I really want some suggestions on this...is there another way of building a Gantt Chart? Or am I heading off the wrong direction? Or have I got it all just plain wrong. =(
Hope someone can assist me! Thanks in advance!
Jensen
Here are some links to those third party components I was refering to;
http://dlhsoft.com/DeveloperTools/ProjectDataControlLibrary/Samples.aspx
http://www.ilog.com/products/ganttnet/
http://www.howtoselectguides.com/dotnet/charting/
|
|
|
|
|
jensenx wrote: So in order to go ahead and build one, I assume i'll have to build a custom control, acquire knowledge in GDI+ and inherit and manipulate the datagrid component?
So far, so good. Though, I'd forget the DataGrid stuff and just draw the entire control using GDI.
jensenx wrote: So with the basics of what im trying to create here, im pretty much clueless on how I'm going to go ahead and build one as I never build a custom control before.
You've picked a very LARGE one to start with. I'd recommend not doing this until you've gone through some smaller controls to get the basics of how controls work, drawing, managing your controls state, managing data, databinding support, and the relationship between your data model and drawing it.
Your control is going to have to track a bunch of data and do a ton of math to figure out how it's going to draw itself, positioning text, bars, grid lines (if any), ... Start small and work your way up.
|
|
|
|
|
Hi frnds.
i am new for the dotnet.
i m moving from vb 6.0 to vb.net
Is there any way to use the crystal report available with VS 2003/2005 in VB 6.0
Thanks in advance
«·´`·.(*·.¸(`·.* *.·´)¸.·*).·´`·» ©
*.¸¸.·´¨` »*Vicky*«´¨`·.¸¸ .*
«·´`·.(*.·´(¸.·* *·.¸)`·.*).·´`·»
|
|
|
|
|
You're going to have to try adding the COM components to the toolbox in VB6 and try it yourself. Usually, once people go to VB.NET, they don't go back to VB6 (unless absolutely forced to.)
|
|
|
|
|
in my project, i use toolbar toolbar in my buttons...i used case structure for the functions of each buttons in the toolbar but theres an error in it...
my codes goes like this:
Select Case<br />
Case 0<br />
Dim subjects As New subjects<br />
subjects.Show()<br />
Me.Hide()<br />
Case 1<br />
Dim file_maintenance As New file_maintenance<br />
file_maintenance.Show()<br />
Me.Hide()<br />
Case 2<br />
Dim grade_entry As New grade_entry<br />
grade_entry.Show()<br />
Me.Hide()<br />
End Select
is this code correct???
or this:
dim keyin as integer <br />
Select Case keyIn<br />
Case 0<br />
Dim subjects As New subjects<br />
subjects.Show()<br />
Me.Hide()<br />
Case 1<br />
Dim file_maintenance As New file_maintenance<br />
file_maintenance.Show()<br />
Me.Hide()<br />
Case 2<br />
Dim grade_entry As New grade_entry<br />
grade_entry.Show()<br />
Me.Hide()<br />
End Select<br />
in the first code, there is an error so i can't run my program...
in the other code, the 1st button is only functioning...
what is the really correct code for this???
|
|
|
|
|
in the first case statement:
Rharzkie wrote: Select Case
This should be Select Case myVariable where myVariable is the variable you are referencing to.
The second one seems fine, there must be an issue in the way the keyIn is changed, it must not be being changed when the other buttons are pressed.
|
|
|
|
|
but when i used the 2nd codes, the first button is only functioning...in the other button, the function also same as the ist button (it should not be the same)...in short, case 1 in only functioning but the others did not...what's wrong with that???
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
