|
To simplify date conversion i was adviced to use to integer converted dates i.s.o. the datetime type.
Now i have the integer 37954 which resembles 01-12-2003 (dd-mm-yyyy)
select cast(37954 as datetime) as startdate
But VB6 thinks it is 29-11-2003
?Format(37954, "dd-mm-yyyy")
How is this possible? What am i doing wrong?
Grtz,
Guus
|
|
|
|
|
|
I don't have any Idea.
Sorry but it seems awkward to use integers for dates.
I think youd be better off using normal Date data.
or I suggest ask the one who adviced you.
Marvin N. Guerrero
- Casting More!!
|
|
|
|
|
In any format, dd-mm-yyyy or mm-dd-yyyy 73584 still means December 1st 2003. You have to retrieve the regional settings to get it right. That's why i use integers.
|
|
|
|
|
Have you tried storing dates as strings?
Easy to display in the format you want and easy to convert correctly to date/time format for any calculations that you need to perform on them.
Just be sure to confirm the value is a valid date before storing (use isdate() function)
Jon
|
|
|
|
|
Please give me details or the source code or atleast a logic to decode or analyse the FTP address or parameters from a packet sent through a network. I am doing a LAN sniffer.
|
|
|
|
|
I need some help... Is anyone aware of a product which can reverse engineer a dll-file, so I can understand what it does...
|
|
|
|
|
You are aware that reverse engineering is prohibited by the vast majority of license agreements.
However, if you are entitled to reverse engineer the DLL then it depends if it is a .NET DLL or a native DLL.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
|
Also, you'll get the not-so-easy-to-read assembly code for the .DLL, not C++ or VB...
RageInTheMachine9532
|
|
|
|
|
I created a usercontrol and it has a property that must be modified through a form. lets call the poperty MYpoints
The property is actually an array of points but rather than typing the values of the points I want to show a form.
The form will have a space on which I could draw a polygon.
clicking on a button ont the form will save the points of the polygon
into the Mypoints property.
Ei!! help me with this.
Thanks.
I'm getting dizzy with diz 
Marvin N. Guerrero
- Casting More!!
|
|
|
|
|
You'll have to write a class that derives from UITypeEditor. Lookup UITypeEditor in VS Help to see an example.
RageInTheMachine9532
|
|
|
|
|
ei! thanks
I'll do just that!
just As I thought, The rage never sleeps.
Marvin N. Guerrero
- Casting More!!
|
|
|
|
|
I am having to bind objects from a database onto visual basic. I have already created the database connection, and the DataAdapter, and the dataSet. Now I am suppose to write code to bind them together. I am confused on how to even start. If I knew how to start then I would be able to do it. Do I need to (Filling a DataSet) also? Whoever can help, I would appreciate it?
Thank you,
ibok23
|
|
|
|
|
Use the .fill method of the dataAdapter at load time. Just follow this syntax, 'daInventory.Fill(dsInv1)' You may need to include the table name if there is more then one for your dataset. When your objects on the form are linked you will want to use a Binding ManagerBase to navigate. Then you will use the .Position to change the displayed values. This is all easier if you have some sample code. Is any of this familiar or is all this new? Would you like a code sample?
|
|
|
|
|
Unlike ADO, ADO.NET works in an unbound manner. No real dynamic connection to a database is provided.
use
* ADAPTERx.FILL(DATASETx.TABLES("tblname"))
to load data into the dataset DATASETx.
then
use
* Datagrid1.datasource = DATASETx.tables("tblname") <br />
to display the data in a grid.
use
* textbox1.datasource = DATASETx.tables("tblname") <br />
textbox1.datafield = "a_record_field"
to bind a textbox1
keep in mind the unlike in vb6 datagrid, the datagrid in VB.net is disconnected, the update method of the ADAPTER only executes a SQL command defined in the updatecommand object generated with you adapter. and it not always working.
Use the me.bindingcontext to manipulate binded controls!
its best done MANO a MANO!
-Marvin
Marvin N. Guerrero
- Casting More!!
|
|
|
|
|
I am very new at this. I am confused also. I have a book that is showing me what to do. But i am still confused. Yes, on a code sample.
Thank you,
ibok23
|
|
|
|
|
I have put together a sample which may help. You can download this from my FTP server. You can access by IP address which will change in time so don't wait too long to download. The files are in a folder called "RandysBoundControls Two Tables". It is about 1.7meg. This is a project I did for school. It should be fully functional. The database is in Access and is stored in the Bin folder. If you recreate the dataset, a .vb file will be rewritten and the lines of code I put there for setting a default value will no longer be there. This will cause an error when you add. Default values are needed for Dates(Date Time Picker) and check boxes (more notes are in the project). I suggest you make a copy. You can program bindings but I did the binding at design time. Look at the DataBindings section of properties for the text boxes. There is a text property there for binding textboxes.
The file is at FTP://4.10.187.76
|
|
|
|
|
I am trying to start to write the code for the binding. In my book it says for me to activate the Code Editor for the form named frmMain. (I am not sure where this is. I can not find it.) that is where I am to start the code is in this section. Well I have started the coding underneath the Windows Form Designer generated code. So far I have..
dim partRecords as Integer
partRecords = adbdaParts.fill(dsPart1)
This is giving me an error on the second line saying I need to declare partRecords. partRecords is how many records I have in my database.
Thank you,
ibok23
|
|
|
|
|
I simulated what you said you did and I get an error for partRecords that says "Declaration expected" on the mouse over tip for partRecords, which has the curvy blue line under it. Is that what you got?
If so you need to put that code in a sub. It would most likely go in the form loading sub. To create this sub you can double click the form while in [Design] view. If I'm underestimating your intellegence I don't mean to. I just don't know how much VB you know.
|
|
|
|
|
I have 700x500 canvas.
I have an image.
[b] how can I center the image on the canvas?[b]
If i have: [b]gr.DrawImage(b, 0.0F, 0.0F)[/b]..this draws it on the left hand corner of the canvas..
This is what i have:
[code]
Dim g As Graphics = Graphics.FromImage(b)
Dim gr As Graphics = Graphics.FromImage(Canvas)
Dim imageH As Single = Convert.ToSingle(b.Height)
Dim imageW As Single = Convert.ToSingle(b.Width)
Dim CanH As Single = Convert.ToSingle(Canvas.Height)
Dim canW As Single = Convert.ToSingle(Canvas.Width)
Dim bgBrush = New SolidBrush(System.Drawing.Color.White)
gr.FillRectangle(bgBrush, New Rectangle(0, 0, 700, 500))
gr.DrawImage(b, 0.0F, 0.0F)
[/code]
any ideas?
|
|
|
|
|
|
Hi gurus,
I'm working on a ATL plug-in for MS Outlook, but I would like to make it work on Outlook Express as well. I understand that it's not possilble via COM technology (as OE does not expose any COM interfaces  ), but something with hooks? Any documentation on the subject?
Any help / hint would be much appreciated.
Thanks in advance,
Doru K.
|
|
|
|
|
I am a rookie student and have been asked to use ASCII to make it impossible for the user to key in alpha digits. My problem is I started the class late and have no idea how this is accomplished. If there is a good tutorial around that explains how to do it? Any help would be very much appreciated.
Steve53546
|
|
|
|
|
Steve Leverich wrote:
asked to use ASCII to make it impossible for the user to key in alpha digits.
In what? A TextBox? There are several events you can handle to do this, like KeyDown and possibly TextChanged, but, we won't write your code for you. Better yet, look through the chapters preceding the one you're in now and search for the control your going to use, not the term 'ASCII'.
RageInTheMachine9532
|
|
|
|
|
VB6:
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii < 48 Or KeyAscii > 58 Then KeyAscii = 0
End Sub
this prevents the user from writing anything but digits.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
