Visual Basic

Re: Can .NET replace Win API 32?

22-Oct-06 12:02

Hi there,

I am borned with .NET era (I meant that I started coding when .NET came out). I have a need to catch the windows property such as position, layer, side, handle ... I have done some research and see most solution is dealt with WIN API 32 which is a very strange animal to me.

Question: do I realy need to learn Windows API in order to deal with my needs above? or does .NET has any class that I can use instead Win API? I am so sick when I see those API books. they are terribly THICK!!!!!
Any advise is greatly appreciated

If you think that I need to deal with damn API, and you also know where are good sites of API such as API for dummies please give me those links.

Hope yo all have a happy coding.

Paula john

Dave Kreskowiak22-Oct-06 15:37

Dave Kreskowiak

22-Oct-06 15:37

No, it can't. Not yet anyway. The .NET Framework is, amoung other things, a wrapper for the Win32 API.

For what you're asking about, the Win32 API is the only way to go. If you want examples, look at http://www.pinvoke.net[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Can .NET replace Win API 32?

paulajohn23-Oct-06 12:39

23-Oct-06 12:39

Thanks for the advise. Bill is not really doing quite a good job huh? don't you think?

have a good d

[Message Deleted]

Rylogy22-Oct-06 10:48

22-Oct-06 10:48

[Message Deleted]

paulajohn22-Oct-06 12:10

22-Oct-06 12:10

Hi there,

If you add the calendar control into the form, and from there, you can tell if that is a leap year or not.

I may be wrong but I think the calendar control class will return some boolean that states wherether select year is a leap year such as

Messagebox.show(ctrCalendar.selectedate.Isleapyear)

Good luck

Rylogy22-Oct-06 12:19

22-Oct-06 12:19

that will work fine, I forgot to specify that I need to do that with my own codes, only using if, else if in the code and textbox for input and another textbox for output and a button.

Thanks for your help though

Guffa22-Oct-06 13:20

Guffa

22-Oct-06 13:20

You can use the modulo operator to find out if a number is divisible by another. The expression x mod y returns zero if x is divisible by y.

That should be enough to get you started. Smile | :)

---
b { font-weight: normal; }

Rylogy22-Oct-06 14:04

22-Oct-06 14:04

I have something but it's not quite right, because years ending with 00 before de decimal are not leap years (example 1700 1800 1900 or even 2000000 as long as it has 00) I don't know how to do that. Also thanks for your help Guffa.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim y As Integer
y = TextBox1.Text
If y Mod 4 = 0 Then
TextBox2.Text = "is leap"
ElseIf y Mod 400 = 0 Then
TextBox2.Text = "is leap"
Else
TextBox2.Text = "isn't leap"
End If
End Sub

Rylogy22-Oct-06 14:27

PropertyInfo.GetValue and nullable types

22-Oct-06 14:27

Nevermind I got it Big Grin | :-D

Duncan Edwards Jones22-Oct-06 8:38

Duncan Edwards Jones

22-Oct-06 8:38

Hi,

I have a generic class to persist any kind of object to a SQL table using PropertyInfo.GetValue to read the values - but it doesn't work if the property is a Nullable(Of ...) type and the value is not set - I get a "Nullable value must have a value" error.

Any ideas how I can modify

Dim val As Object = PropertyInfo.GetValue(ClassInstance, Nothing)

so it can cope with empty nullable types?

Thanks in advance

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

VB.NET: How to insert datetime into Sql database

Newbie_dydy8522-Oct-06 4:16

Newbie_dydy85

22-Oct-06 4:16

I need help in MYSQL and VB.NET.
How can i insert the datetime of my computer into Sql database?No mater how i convert the date, it does'nt work.

Here is the code:

Dim PurDate As Date
PurDate = Date.Now()

Dim strInsSales As String
strInsSales = "Insert into Testing Values(" & PDate & ")"

And the value store into SQL is "1900-01-01 00:00:00.000" Unsure | :~

Anyone can help me in this problem?

Re: VB.NET: How to insert datetime into Sql database

Guffa22-Oct-06 4:46

Guffa

22-Oct-06 4:46

There are two errors in the code. You have forgotten the apostrophes around the value, and you are not using the same variable as the one that you put the value in. Also, you should specify a format when converting the date to a string, not just using the default format, as that can be juat about anything.

strInsSales = "Insert into Testing Values('" & PurDate.ToString("yyyy-MM-dd HH:mm:ss") & "')"

Better yet, you should use a parameterized query.

---
b { font-weight: normal; }

Re: VB.NET: How to insert datetime into Sql database

Newbie_dydy8522-Oct-06 7:21

Newbie_dydy85

22-Oct-06 7:21

Thanks Guffa, i hv solve d the problem right now.

However, another problem is occured.
After i insert the date into Sql database, then i need to retrieve the date and compare with the user input's date.

Dim SDate as string
SDate = year & "-" & month & "-" & day

Eg: user input is : 2006-10-22
Also, SqlDate is : 2006-10-22 23:59:52.000

SDate = Convert.ToDateTime(SDate).ToShortDateString
SqlDate = Convert.ToDateTime(SqlDate).ToShortDateString
If (SDate = SqlDate) Then
valid = True
End If

However, it give me a false value, even the date are equal.
How should i solve this problem?
Thanks again...

Re: VB.NET: How to insert datetime into Sql database

paulajohn23-Oct-06 12:33