Visual Basic

Create small size PNG file

28-Jun-07 5:17

A GroupBox is a pretty lightweight control. It'll work for what you want it to do. Just don't expect a lot of customization options with it.

A guide to posting questions on CodeProject[^]

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

Rupesh Kumar Swami28-Jun-07 4:10

Rupesh Kumar Swami

28-Jun-07 4:10

hi,
i create simple png file which draw user specified string. i accept input from user through Text box(here name is txtString).However following code create Png file but size is more(above 1 KB) for simple string which contains few character(here string contains "aaa").

Dim g As Drawing.Graphics = Nothing<br />
        Dim bm_width As Integer = 170<br />
        Dim bm_height As Integer = 200<br />
<br />
        Dim newBitmap As Bitmap = New Bitmap(bm_width, bm_height, Imaging.PixelFormat.Format24bppRgb)<br />
        g = Drawing.Graphics.FromImage(newBitmap)<br />
        g.PageUnit = GraphicsUnit.Pixel<br />
        g.DrawImage(newBitmap, 0, 0, bm_width, bm_height)<br />
<br />
        g.FillRectangle(Brushes.White, 0, 0, bm_width, bm_height)<br />
        Dim b As Font<br />
        Dim a As New FontDialog<br />
        If a.ShowDialog = Windows.Forms.DialogResult.OK Then<br />
            b = a.Font<br />
        End If<br />
      <br />
        Dim str As String<br />
        str = txtString.Text.Trim  <br />
        g.DrawString(str, b, Brushes.Black, 0, Ypos)<br />
        newBitmap.Save("c:\Drawing\" & txtString.Text.Trim & ".png", Imaging.ImageFormat.Png)

how can we reduce size of PNG file.
any help will be appreciated

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

Re: Create small size PNG file

Dave Kreskowiak28-Jun-07 5:15

Re: Create small size PNG file

28-Jun-07 5:15

PNG is already a compressed format so you're not going to get a smaller size file. Who cares what the text is. On a pixel-by-pixel basis, the more complex the image is, the less "compressible" the image is going to be and the bigger the resulting file.

A guide to posting questions on CodeProject[^]

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

Paul Conrad28-Jun-07 6:35

Paul Conrad

28-Jun-07 6:35

I agree. I've noticed his code has a fixed bitmap size and have wondered if he should set the bitmap depending on the text size (unless he's forced with a 170x200 image)...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Dynamic button + dynamic code.

Barbarus28-Jun-07 3:57

Barbarus

28-Jun-07 3:57

Hi all,

A problem takes me back once again to the code project.

Right now I'm working on a small project in which I would like to generate my buttons, textfields etc dynamicly (I have an xml file and when it encouters < control type= button name = btn1/> it creates a button called btn1 and its added to the page (its possible to set the size etc.)
The reason why I'm doing this is that from time to time you just want to add a simple button but don't feel like recompiling the whole project or a client wants an extra button/image and would like to add it himself.... (with some sort of wizard typed thing)

this is all working. buttons and controls are created without a problem. I can retrieve info from my textboxes etc no problem. But well lets say I want to create a button but it needs a new "function" while clicking on it so I would need to add a handler to the button but I don't know what the code is going to be so I added in my xml file: <control type= button name = btn1 handler= btn1_handler/>
This function is then coded in an external file (simple notepad for exemple)

now where I dont really know how to do it is associate this function btn1_handler with my btn1 so that it handles an onclick event... the whole thing without recompiling but using for example vbscript or ICodeCompiler.....

Would this be possible to do? or? because well I dont know what will be in the function nor which button it corresponds to except in my xml file....

any help would be greatly appreciated Smile | :)

Cheers
jozef

its our widgets that make us men

Re: Dynamic button + dynamic code.

Dave Kreskowiak28-Jun-07 5:09

Re: Dynamic button + dynamic code. [modified]

28-Jun-07 5:09

It's possible. I don't exactly know how, but it is.

I'm figuring that you would have to load the button handler text into a CodeDom and compiler it into an in-memory assembly. This assembly would then have to be loaded into the AppDomain, kind of like plugin functionality. You'd then have to wire up the event handler yourself after the code is loaded.

Don't ask for example on this one for I don't have any. This is all just speculation. I've given you enough keywords to Google on to get the smaller parts of the problem solved though. After that, it's a matter of stringing those smaller solutions together to get this to work.

A guide to posting questions on CodeProject[^]

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

Barbarus28-Jun-07 5:51

Barbarus

28-Jun-07 5:51

Okay, thanks alot, I think I will find a way with the different info you have given me and its good to know it's possible to avoid searching the internet for days and finally realising it isn't possible Smile | :)

Thanks again, and well if I find it I'll be sure to share it in here

Cheers
jozef

-- modified at 12:15 Thursday 28th June, 2007

its our widgets that make us men

Dataset Tables

Brendan Vogt28-Jun-07 3:14

Brendan Vogt

28-Jun-07 3:14

Hi,

If I have a dataset with a couple tables, is it possible to take one of these tables and copy it over to another dataset? I just want one table in my dataset.

Regards
ma se

Re: Dataset Tables

nlarson1128-Jun-07 3:55

nlarson11

28-Jun-07 3:55

use clone - copy the structure

you can either copy the rows manually or use writexml/readxml to transfer the rows.

Import XML to a Dataset

Brendan Vogt28-Jun-07 2:48

Brendan Vogt

28-Jun-07 2:48

Hi,

My XML format looks like this:

<?xml version="1.0" encoding="utf-8"?>
<Products>
<Product>
<ID>5555</ID>
<ProductName>My Product</ProductName>
<Price>50</Price>
</Product>
</Products>

I need to know how to get this into a dataset, then I will have more control of the data. I know there is a function that saves the XML into a datast, but how does it know that I want the fields in the <Product></Product> hierarchy?

Or how should this be done?? I just want the <ID>, <ProductName> and <Price> to be the column names, and the values in tags the values of the fields in the row.

Regards
Brendan

Re: Import XML to a Dataset

kubben28-Jun-07 4:23

kubben

28-Jun-07 4:23

It looks like you have the right structure to just to a ds.ReadXml("c:\temp\filename.xml")
So <Products> would be your dataset
You table would be <Product>
so multiple rows would look like:
<Products>
<Product>
<ID>5555</ID>
<ProductName>My Product</ProductName>
<Price>50</Price>
</Product>
<Product>
<ID>6666</ID>
<ProductName>My Product2</ProductName>
<Price>60</Price>
</Product>
</Products>

So I don't think you will have to do much to get this working.

Ben

SQL Server 2000 backup

magedhv28-Jun-07 1:25

magedhv

28-Jun-07 1:25

How can i backup the database from SQL server 2000 from my application using vb2005
plz this us urgent
thanks

Xandip28-Jun-07 1:53

Xandip

28-Jun-07 1:53

Execute the BACKUP DATABASE Statement from the FrontEnd

The name is Sandeep

SHatchard28-Jun-07 1:55

SHatchard

28-Jun-07 1:55

Just to expand, the syntax is

BACKUP DATABASE myDatabase
TO DISK = 'c:\backup\myDatabase.bak'

magedhv28-Jun-07 1:55

magedhv

28-Jun-07 1:55

thanks for u reply but i don't get it
would u plz give me example ??

Xandip28-Jun-07 2:02

Xandip

28-Jun-07 2:02

Didn't you see the Syntax above? Just try with it and see.

The name is Sandeep

magedhv28-Jun-07 2:30

magedhv

28-Jun-07 2:30

i saw it
but here what i typed

If cn.State = ConnectionState.Closed Then<br />
            cn.ConnectionString = "provider=SQLOLEDB;server=maged;database=ceasr;user id=sa;pwd=magedhv"<br />
            cn.Open()<br />
            cmd.Connection = cn<br />
            cmd.CommandType = CommandType.Text<br />
            cmd.CommandText = "BACKUP DATABASE ceasr to disk = d:\backup\myDatabase.bak"<br />
        End If

but it didn't worked

How can i override a Button property

Steven J Jowett28-Jun-07 3:21

Steven J Jowett

28-Jun-07 3:21

See this posting I made previously [^]

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

anujose28-Jun-07 0:14

anujose

28-Jun-07 0:14

i want to override a button property?is it possible? how can i delete a existing property from a button

sathesh pandian28-Jun-07 1:31

sathesh pandian

28-Jun-07 1:31

dear anujose,

you can add the code like this

btn.attributes.add("OnMouseOver",someCode())

All The Best

Sathesh Pandian

anujose28-Jun-07 1:55

anujose

28-Jun-07 1:55

i want to override a button property in winform not an event

Steven J Jowett28-Jun-07 3:26

Steven J Jowett

28-Jun-07 3:26

Would you not have to inherit the button control into your own class and expand on it from there?

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

Dave Kreskowiak28-Jun-07 5:03