Visual Basic

13-Jan-09 6:44

Hi
I have some code in vb6 and I am unable to convert into into vb.net can some body help me...

UnRGB picImage.Point(r, c), clrr, clrg, clrb

Private Sub UnRGB(ByVal color As OLE_COLOR, ByRef r As Byte, ByRef g As Byte, ByRef b As Byte)
    r = color And &HFF&
    g = (color And &HFF00&) \ &H100&
    b = (color And &HFF0000) \ &H10000
End Sub

where picimage is the picturebox and clrr,clrg and clrb are the variables for RGB please some one help...

Henry Minute13-Jan-09 8:35

13-Jan-09 8:35

Before I attempt to give you an answer, or point you in the right direction.
Please confirm that the VB6 code is meant to take one pixel from the picturebox and get the red, green and blue components for the color in that pixel.

Henry Minute

If you open a can of worms, any viable solution *MUST* involve a larger can.

sarfarazaliqureshi13-Jan-09 9:00

13-Jan-09 9:00

yes it take one pixel from picturebox and plz also tell me how to write the UNRGB method in vb.net

Henry Minute13-Jan-09 9:06

13-Jan-09 9:06

The only thing that I would add to Dave Ks' answer (below)
is that you cannot get the pixel from the picturebox, you have to get it from the PictureBox.Image property and cast it to a Bitmap.

Henry Minute

If you open a can of worms, any viable solution *MUST* involve a larger can.

sarfarazaliqureshi13-Jan-09 9:20

13-Jan-09 9:20

yes I agree you dear that picturebox does not have getpixel property well that problem has solved now I have trouble to perform this code in vb.net

Private Sub UnRGB(ByVal color As System.Drawing.Color, ByRef r As Byte, ByRef g As Byte, ByRef b As Byte)
    r = color And &HFF
    g = (color And &HFF00) \ &H100
    b = (color And &HFF0000) \ &H10000
End Sub

Dave Kreskowiak13-Jan-09 10:19

Dave Kreskowiak

13-Jan-09 10:19

You don't need it! Once you have the Color from GetPixel, you already have everything this code does! Check the R, G, and B properties of the Color you got back.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Dave Kreskowiak13-Jan-09 8:42

Dave Kreskowiak

13-Jan-09 8:42

It's easily done using the methods already built in to the Bitmap class. You don't even need this function. Your're calling this with the color of a pixel already, so you already have the R, G, and B properties of the color.

Dim pixelColor As Color = MyBitmap.GetPixel(x, y)
Dim R As Byte = pixelColor.R
Dim G As Byte = pixelColor.G
Dim B As Byte = pixelColor.B

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

sarfarazaliqureshi13-Jan-09 9:04

13-Jan-09 9:04

but dear what about this code...

Private Sub UnRGB(ByVal color As OLE_COLOR, ByRef r As Byte, ByRef g As Byte, ByRef b As Byte)
    r = color And &HFF&
    g = (color And &HFF00&) \ &H100&
    b = (color And &HFF0000) \ &H10000
End Sub

how i Perform Loggical And operation....

Henry Minute13-Jan-09 9:08

13-Jan-09 9:08

sarfarazaliqureshi wrote:
but dear what about this code...

You have misunderstood.

Dim R As Byte = pixelColor.R
Dim G As Byte = pixelColor.G
Dim B As Byte = pixelColor.B

Is that code

Henry Minute

If you open a can of worms, any viable solution *MUST* involve a larger can.

sarfarazaliqureshi13-Jan-09 9:11

13-Jan-09 9:11

Actually it is part of Steganography project and I need to Perform This And operation so that I can Store data at Random ...

r = color And &HFF
g = (color And &HFF00) \ &H100
b = (color And &HFF0000) \ &H10000

Henry Minute13-Jan-09 9:25

13-Jan-09 9:25

In your VB6 code, all that the UnRGB function did was to extract the red, green and blue values from a color.
and put them into clrr, clrg and clrb

UnRGB picImage.Point(r, c), clrr, clrg, clrb

Private Sub UnRGB(ByVal color As OLE_COLOR, ByRef r As Byte, ByRef g As Byte, ByRef b As Byte)
    r = color And &HFF&
    g = (color And &HFF00&) \ &H100&
    b = (color And &HFF0000) \ &H10000
End Sub

Daves code

Dim R As Byte = pixelColor.R
Dim G As Byte = pixelColor.G
Dim B As Byte = pixelColor.B

does that except he has called clrr R, clrg is now G, and clrb is B.

I explained how to get the pixel in a reply to your earlier post.

You now have enough information to solve your problem.
Do not expect us to write it for you.

Do you realise how complex steganography is? If you are unable to grasp the connection between the answers you have been given here and your VB6 code, then you will not be able to cope with steganography.

You might get a better understanding if you go to the Home page of CP and use the search box to look for steganography. There are loads of articles there. I havn't looked at them all but I would expect there to be some in VB.Net

Good luck!

Henry Minute

If you open a can of worms, any viable solution *MUST* involve a larger can.

sarfarazaliqureshi13-Jan-09 9:32

Re: SQL Query Syntax Issue

13-Jan-09 9:32

Thanks Friend Your Information is Usefull for me and I know Steganography but u r right not enough thx

SQL Query Syntax Issue

tcd6713-Jan-09 5:59

tcd67

13-Jan-09 5:59

I’m new to VB and WPF and struggling with a SQL query that contains a JOIN. This almost works by there is something not right with the JOIN or SELECT statements. If someone can point me to a resource that contains the proper syntax for statements like the one below, I would be very appreciative. Oh...and I'm using VS2008.

Class Window1 

    Private db As New cmaDataContext
    Private UserView As BindingListCollectionView


    Private Sub Window1_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded

        Dim CMAusers = From a In db.tsmContacts _
                       Join b In db.tsdContactDetails On _
                       a.intSystemUserID Equals b.intSystemUserID _
                       Where a.bitDeleted = "0" _
                       Select a.vchFirstName, a.vchLastName, a.vchMiddle, b.vchEmail

        Me.DataContext = CMAusers
        Me.UserView = CType(CollectionViewSource.GetDefaultView(Me.DataContext),  _
                            BindingListCollectionView)

    End Sub

Thanks,
Todd

modified on Tuesday, January 13, 2009 12:15 PM

Wendelius13-Jan-09 6:28

Re: SQL Query Syntax Issue

13-Jan-09 6:28

Have you looked at these:
- Join Clause (Visual Basic)[^]
- Basic Query Operations (Visual Basic)[^]

The need to optimize rises from a bad design.My articles[^]

tcd6713-Jan-09 6:46

tcd67

13-Jan-09 6:46

Thanks Mika. That should do it.

TD

Re: SQL Query Syntax Issue

Wendelius13-Jan-09 7:24

windows service structure/custom actions

13-Jan-09 7:24

No problem. Just a minor correction. It isn't actually SQL you're using but LINQ[^]. Although the syntax is somewhat similar, the concept is very different.

The need to optimize rises from a bad design.My articles[^]

captainmogo13-Jan-09 4:42

captainmogo

13-Jan-09 4:42

I was given a service application that manages (creating/deleting) the partitions on database tables. Currently at the top of every hour, the progam adds a new partition & deletes any partitions that are older than 36 hours. I am being asked to modify this so that on startup the application creates 36 paritions for each of the tables. Then at the top of every hour, it will create a new parition for time + 36hrs and again delete anything older than time-36hrs. A timer is used (with a 30 second interval) to check if it is the top of the hour.

I have 2 questions.....
1. I created a flag and set it to true on startup. Timer tick sub routine checks the flag, if it is True, the app loops through each table and creates 36 paritions, then sets the flag to False. Every time there after, the timer tick routine checks the minute property of the current time and if it is 0, runs the routine to create the new partition and delete the old. Is this the most efficient way to do it. I was reading about custom actions for setup projects and was thinking that maybe the first 36 could be created using this.

2. The timer tick every 30 seconds to check the minute property but I was wondering if there was a better way to check for the top of the hour.

Thanks in advance

Re: windows service structure/custom actions

Wendelius13-Jan-09 6:40

Re: windows service structure/custom actions

13-Jan-09 6:40

I would guess that your timing system is efficient enough considering the task you'r doing. Creating and deleting partitions isn't a small job for the database engine.

Just a question: You didn't say what database you're using, but if it is SQL Server, why wouldn't you create a job under SQL Agent. You could do the programming using T-SQL thus eliminatig roundtrips to database. Also the database wouldn't depend on any service outside the SQL Server itself. For example if your service is stopped, halted etc, your database wouldn't act as expected. Also I believe that both the performance and maintainability would increase.

The need to optimize rises from a bad design.My articles[^]

captainmogo13-Jan-09 8:12

captainmogo

13-Jan-09 8:12

thanks for your response.

To answer your question, I am using Oracle 10g enterprise. Is there something in Oracle like the SQL Agent you were talking of. I do not have much experience using db, i was just handed this so I am kinda shooting from the hip.

Thanks again Wink | ;)

Re: windows service structure/custom actions

Wendelius13-Jan-09 8:57