Visual Basic

Henry Minute4-Sep-09 10:08

4-Sep-09 10:08

The only thing I can think of, and then only because I have seen it in the InitializeComponent method, is:

o.ResumeLayout(false);
o.PerformLayout();

I know nothing! Smile | :)

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.”

Luc Pattyn4-Sep-09 10:43

4-Sep-09 10:43

You hide your Barcelonian accent pretty well, at least in writing.

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.

Henry Minute4-Sep-09 10:52

4-Sep-09 10:52

Si Senor!

Luc Pattyn4-Sep-09 11:14

4-Sep-09 11:14

so you're a fake after all, a real Manuel would write "¡Si Senor!" as exclamation and question marks also appear upside down before the sentence.

Sigh | :sigh:

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.

Henry Minute4-Sep-09 11:25

4-Sep-09 11:25

¡No he aprendido cómo hacer eso todavía! Blush | :O

Luc Pattyn4-Sep-09 12:19

4-Sep-09 12:19

¡Usted todavía tiene que aprender mucho!

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.

Henry Minute4-Sep-09 12:38

Re: Awaiting the language police

4-Sep-09 12:38

Ése es el sino de nosotros todo, si somos afortunados.

Luc Pattyn4-Sep-09 12:52

Re: Awaiting the language police

4-Sep-09 12:52

El destino real es la más aprendemos, más nos damos cuenta de que no saben nada (como usted ha dicho antes).

WTF | :WTF:

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.

Henry Minute4-Sep-09 13:22

4-Sep-09 13:22

¡Verdad, verdad! Mein Herr.

DaveAuld4-Sep-09 10:17

DaveAuld

4-Sep-09 10:17

I don't know about the width bit, but i would move the suspend and resume operations to outside the loop, only need to do them once each, rather than for every control being modified in the loop.

Dave
Who am I?: http://www.bebo.com/daveauld/
or http://www.dave-auld.net/

Luc Pattyn4-Sep-09 10:45

4-Sep-09 10:45

Hi,

IMO the Suspend/ResumeLayout is useful for controls holding lots of data (such as a TreeView), so you can modify its content step by step without it being recalculated every time.
Now if you want to modify dimensions of a collection of controls, it is their container you would have to tell not to recalculate itself all the time.

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.

Update db in ADO.NET

TheMrProgrammer4-Sep-09 7:19

TheMrProgrammer

4-Sep-09 7:19

I have a database in which I put data by using ADO.
The database is .mdb

When i run the sub which puts the data in the database everything goes fine.

I add about 30k rows.

But when i run the same sub again,ie when i update the database, it tries to put the data, but in that data some old data is also present
and there comes a msgbox saying that duplicate entries and much more.

How to avoid this?

one more Q:
the size of the mdb file reaches to 50MB.
is there a way to have the size less?

TheMrProgrammer
http://www.icbse.com/2009/funny-exam-answers-school-students
http://download.cnet.com/TheCalcMan/3000-2094_4-10958266.html

Henry Minute4-Sep-09 8:37

4-Sep-09 8:37

TheMrProgrammer wrote:
But when i run the same sub again,ie when i update the database, it tries to put the data, but in that data some old data is also present
and there comes a msgbox saying that duplicate entries and much more.

Without seeing the relevant parts of your code, any one who attempts an answer is simply guessing.

TheMrProgrammer wrote:
one more Q:
the size of the mdb file reaches to 50MB.
is there a way to have the size less?

Again without knowing more about the Database it is almost impossible to tender a cogent reply.

Kschuler4-Sep-09 9:34

Kschuler

4-Sep-09 9:34

We're going to need more information to help you. How are you adding these records. What error messages are you getting? Are you using a DataAdapter or just straight insert commands? Are your tables constrained to be unique?

Also,

TheMrProgrammer wrote:
one more Q:
the size of the mdb file reaches to 50MB.
is there a way to have the size less?

Access database files will retain their size even after records have been deleted. (If you had a .mdb file with thousands of records, then deleted the records, the .mdb file will still be very large in size.) If this is what you are referring to, Yes. You can reclaim what is no longer being used by the file. I think I used one of these articles[^] when I needed to accomplish this goal.

Hope this helps.

TheMrProgrammer4-Sep-09 20:51

TheMrProgrammer

4-Sep-09 20:51

well....

partially you were correct to guess.
what you suggested was not the Q i asked.
But I am glad for the links of these articles.
Thanks.

My initial problem is solved.
It was a case of index.

Let me explain my 2nd Q.

Suppose i have new database D.
In it i write about 20 MB of data.
so the size of D is 20 MB.

What I wish is compress D so the 20MB reduces to a less value.
Is it possible?

TheMrProgrammer
http://www.icbse.com/2009/funny-exam-answers-school-students
http://download.cnet.com/TheCalcMan/3000-2094_4-10958266.html

Kschuler8-Sep-09 2:43

Kschuler

8-Sep-09 2:43

You can create a zip file. Here are some articles[^] about how to do that in code. But I'm not sure this is exactly what you are looking for either. In order to use a zipped file you'd have to convert it back to the file type it was before, which would increase it back to it's original size as well. But if you are looking to compress it as a means of archiving or backing up this may work for you.

Good luck!

Steven J Jowett4-Sep-09 12:12

Steven J Jowett

4-Sep-09 12:12

I suspect that you are not clearing or reinitialising the variables holding the data after the data is added to your database, therefore some of the data would be written to the database again, on subsequent writes to the database.

Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Share (or import/export) a ComboBox between 2 forms?

TheMrProgrammer4-Sep-09 20:46

TheMrProgrammer

4-Sep-09 20:46

No No

This was not the case.
thanks anyway for trying to help.

TheMrProgrammer
http://www.icbse.com/2009/funny-exam-answers-school-students
http://download.cnet.com/TheCalcMan/3000-2094_4-10958266.html

Hurricane30004-Sep-09 6:06

Hurricane3000

4-Sep-09 6:06

Hi all,

I have a little problem and I hope to find some help:

I'm developing a program (C.F.2-V.B.)that have multiple forms.
I need that when I switch from Form1 to Form2, I can continuing to use some of controls builded in Form1.
For example, if in Form1 I have a ComboBox1 populated with its appropiate items, when I switch on Form2, I need to have the same ComboBox1 (without the need to build a new ComboBox and re-populate it with same values).
Is it possible?
This to avoid to do 2 time the same work, and to save precious memory of device.

Thanks

Ignazio

Re: Share (or import/export) a ComboBox between 2 forms?

Henry Minute4-Sep-09 8:38

Re: Share (or import/export) a ComboBox between 2 forms?

4-Sep-09 8:38

Hurricane3000 wrote:
I need to have the same ComboBox1 (without the need to build a new ComboBox and re-populate it with same values)

Why?
How much work is involved?

Hurricane30004-Sep-09 9:20

Hurricane3000

4-Sep-09 9:20

Hi,

I want avoid to have a duplicate of the same ComboBox in memory for 3 reasons:

1 - because application is for devices (Compact Framework)where memory must be used with parsimony. It can contain also 20,000 items

2 - To make more fast application avoiding to populate 2 times 2 different Combobox with the same data.

3 - Because to have 2 ComboBox with same items in the same program not sounds to be an "efficent" solution.

Re: Share (or import/export) a ComboBox between 2 forms?

Henry Minute4-Sep-09 9:34