Visual Basic

4-Sep-09 2:14

First, this is entirely a database question, not VB.NET. You're looking for this[^] forum.

Next, if your data in the table was normalized when it was inserted into the table, this little problem would never have come up. Now, on retrieval, your making the database engine do a lot more work and slowing down the process of retrieving your data.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

duplicate a toolstip

valkyriexp3-Sep-09 14:01

valkyriexp

3-Sep-09 14:01

Hi
Is there a way to duplicate a toolstrip from a form to another?

I tried New_Contextmenu.Items.AddRange with the items i want to duplicate and it removed those items from the original strip, then tried to make a new ToolStripMenuItem for each item, and expecting to create a completely new instance of the items by using the "NEW" keyword, But seems I can't get it right and j's are still referencing the original i items and generates error by removing items from the original toolstrip.

Public Sub MakeNewStrip(ByVal DropDown As System.Windows.Forms.ToolStripDropDown)
    For Each i As System.Windows.Forms.ToolStripItem In DropDown.Items
        Dim j As New System.Windows.Forms.ToolStripMenuItem
        j = i
        Me.Clock_Contextmenu.Items.Add(j)
    Next
End Sub

Re: duplicate a toolstip

Dave Kreskowiak3-Sep-09 17:03

3-Sep-09 17:03

I can't say that I've ever had to do that. But, I would probably create a method that returns a built default toolstrip instead of trying to copy an exiting one. But, have you tried myMenuItem.MemberwiseClone()?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: duplicate a toolstip

valkyriexp4-Sep-09 7:06

valkyriexp

4-Sep-09 7:06

I solved the problem by using
Me.ToolStripMenuItem1.Items.AddRange(New System.Windows.Forms.ToolStripItem() {....})
in the Opening event of each menu strip.
That way I don't have to handle the events of the items separately and a single code works for both.
But I still don't understand why the first code didn't work, I even created a new list of the items and populated the list with "New" instance of the items but adding the list to the new menu would remove them from the original one WTF | :WTF:

.

Thanks anyway

Re: duplicate a toolstip

Dave Kreskowiak4-Sep-09 10:02

Using VB.Net 2008 with Access 2007 database on Windows Server 2008

4-Sep-09 10:02

All UI controls can only haev one parent container. You tried to have the same control have two parent containers. Doesn't work that way.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

abiemann3-Sep-09 9:25

abiemann

3-Sep-09 9:25

This code, to open and read a local access 2007 database, works perfectly fine on my (Vista) development station:

<br />
        'open the Access 2007 database without a password<br />
        Dim DBconnection As OleDbConnection<br />
        Dim DBcommand As OleDbCommand<br />
        Dim DBdataReader As OleDbDataReader = Nothing<br />
        Dim strProgramPath As String = System.AppDomain.CurrentDomain.BaseDirectory()<br />
        Dim strDBfullPath As String = strProgramPath + "labs.accdb"<br />
        DBconnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + strDBfullPath + ";Persist Security Info=False;")<br />
        DBconnection.Open()

However, once I copy my program to the Windows Server 2008 machine as well as the same database I used for development: 1) the code above takes a long time to execute 2) .Open fails

Why does it work fine on Vista, but fails on Server 2008 eventough the database on both machines are the same ?

Re: Using VB.Net 2008 with Access 2007 database on Windows Server 2008

abiemann3-Sep-09 13:21

abiemann

3-Sep-09 13:21

so the problem here seemed to exist because the compilation was set to "any CPU".
Once I set the compilation option to x86, the application was able to open the database on the Server 2008 machine too (64bit machine).

So it seems there's no 64bit driver to access an Access 2007 DB ?

I'm glad it's at least working now, however, on my (32bit) Vista development station the data access is very fast and on the (64bit) Server 2008 station data access is very slow; instant vs. 30 secs

Re: Using VB.Net 2008 with Access 2007 database on Windows Server 2008

εїзεїзεїз3-Sep-09 13:38

εїзεїзεїз

3-Sep-09 13:38

Best Of Regards,
SOFTDEV
Sad like books with torn pages, sad like unfinished stories ...

Re: Using VB.Net 2008 with Access 2007 database on Windows Server 2008

Dave Kreskowiak3-Sep-09 13:42

Unsure of phrasing, Subproperty?

3-Sep-09 13:42

abiemann wrote:
So it seems there's no 64bit driver to access an Access 2007 DB ?

True, at this time there is no 64-bit drivers for a Jet database (Access). Since you cannot mix 64 and 32 bit code in the same process, you have no choice but to compile your app forced down to 32-bit only. If you used any of the SQL Servers, including SQL Server Express Edition, you wouldn't have this problem.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

EliottA3-Sep-09 5:32

3-Sep-09 5:32

I wish to create a property which has sub properties (sorry if this is the wrong wording) similar to the Size property each control already implements..

Control.Size returns System.Drawing.Size
whereas you can still access
Control.Size.Width returns an Integer

I suppose sub property would be the best word to describe the 'Width' property

Any ideas how to implement this hierarchy of properties on your own custom properties?

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Henry Minute3-Sep-09 5:57

Henry Minute

3-Sep-09 5:57

You need to apply a TypeConverter attribute, specifying either an ExpandableObjectConverter, or one derived from it.

Using PropertyGrid Part-I[^] has an example (and googling might find others that more directly address this), search for ExpandableObjectConverter for the relevant bit.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

N a v a n e e t h3-Sep-09 5:57

N a v a n e e t h

3-Sep-09 5:57

Not sure what problem are you facing. Nested properties (not sure this wording also correct) are trivial to implement. Here is a C# implementation as my VB is poor.

class Employee
{
    Address homeAddress = /* .. */
    public Address HomeAddress
    {
        get
        {
            return homeAddress;
        }
    }
}

class Address
{
    string street;
    public string Street
    {
        get
        {
            return street;
        }
    }

    string city;
    public string City
    {
        get
        {
            return city;
        }
    }
}

Now you can write,

Employee chuckNorris = new Employee();
chuckNorris.HomeAddress.Street = "Set the street here";
chuckNorris.HomeAddress.City = "set the city here";

Navaneeth

How to use google | Ask smart questions

EliottA3-Sep-09 6:00

3-Sep-09 6:00

This, I all understand.

My problem lies specifically within the Size property, as I'm trying to overload it, along with the properties that the Size property has (specifically height and width).

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

N a v a n e e t h3-Sep-09 6:09

N a v a n e e t h

3-Sep-09 6:09

So you need to expose a property that has all the properties of Size available and your own custom properties. Is that right? If yes, you need to create a completely new type. Also I just noticed that Size is a structure and you will get a compiler error if you write

control.Size.Width = some value

If you are creating new type, I would consider a class over a struct.

Smile | :)

Navaneeth

How to use google | Ask smart questions

EliottA3-Sep-09 6:12

3-Sep-09 6:12

Thanks I'll look into that, but out of curiousity are you saying that if I have a button, I cannot do..

button1.Size.Width = 60

I must have misunderstood your post, I think I'm going to tackle this another way..

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

N a v a n e e t h3-Sep-09 6:37

N a v a n e e t h

3-Sep-09 6:37

Since struct is a value type, button1.Size returns a copy of original size. Changing a property value on it won't affect the original size instance which is in the control. So you need to do

button1.Size = new Size(width, height)

Hope that is clear Smile | :)

Navaneeth

How to use google | Ask smart questions

Luc Pattyn3-Sep-09 6:55

Luc Pattyn

3-Sep-09 6:55

... or button1.Width=width;

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

EliottA3-Sep-09 7:02

Using VB.NET 2005 With MySQL

3-Sep-09 7:02

My memory seems to be fading away from me here, you are both correct. My mistake.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Pasan1483-Sep-09 5:10

Pasan148

3-Sep-09 5:10

How to . Which data provider can use to implement that.

Re: Using VB.NET 2005 With MySQL

EliottA3-Sep-09 5:15