Visual Basic

Re: How Do i Document a Functional Spec for the Functionality

17-Jul-07 1:58

I don't think its much use to ask who's doing this
if that person is really childish anough to vote 1 on every post you do I doubt he/she will be man/women enough to come out and say how he/she is

If I were you I wouldn't pay much attention to it

you're answers have been quite usefull to me in the past so I'd say keep up the good work and thanks for al you're afforts

modified
sorry made a typo Poke tongue | ;-P

Re: Just curious...

originSH17-Jul-07 2:29

originSH

17-Jul-07 2:29

And as if by magic alot of your 1 posts have returned to 3 Smile | :)

Re: Just curious...

Colin Angus Mackay17-Jul-07 3:13

Colin Angus Mackay

17-Jul-07 3:13

Thanks.

Vimalsoft(Pty) Ltd19-Jul-07 20:34

Vimalsoft(Pty) Ltd

19-Jul-07 20:34

Thanks

Vuyiswa Maseko

sum experssion

Mr.Kode16-Jul-07 21:16

Mr.Kode

16-Jul-07 21:16

i have one datatable contains price column
i need to calculate the sum of the prices
and then delete all the rows from the table

my code is :

dim total as decimal
total=dataset.tables("sourcetable").columns("price").experssion="sum(price)"

but when the code executed it generate exception
can not use experssion in an circual function

second:

i need to know how to delete all rows from datatable at run time

regards to all

Re: sum experssion

Tom Deketelaere16-Jul-07 21:20

Re: sum experssion [modified]

16-Jul-07 21:20

don't know about the first question but for the second:

dataset.tables("sourcetable").clear

(I didn't test it but it should work)

about the first question if you have a db backhand why not do that in sql?? (just a suggestion)

Mr.Kode16-Jul-07 21:54

Mr.Kode

16-Jul-07 21:54

the clear method clears the dataset table only and when i call update method nothing happen

i know that i can get sum from SQL and use stored procedure to execute the statments
but i need to di it through VB experssion method

thanks for help

-- modified at 6:17 Tuesday 17th July, 2007

Re: sum experssion

Dave Kreskowiak17-Jul-07 3:53

Dave Kreskowiak

17-Jul-07 3:53

What you did was try to put the expression in the column, which won't work. You have to enumerate the rows in the table, adding up the prices, and you can also delete each row in the datatable, then call the update method on the dataadapter for this datatable/dataset to write the changes back to the database.

A guide to posting questions on CodeProject[^]

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

which book in very useful for vb.net 2005

babusat16-Jul-07 21:04

babusat

16-Jul-07 21:04

i want to buy a book for vb.net 2005 anybody can suggest book for both(beginners and also for high level) tell separate book also

sathish

Re: which book in very useful for vb.net 2005

Sathesh Sakthivel16-Jul-07 21:16

Sathesh Sakthivel

16-Jul-07 21:16

(1) Pro-ASP.NET 2.0 in VB 2005 by Laurence Moroney, edited by Matthew MacDonald by apress publication

(2)ASP.NET 2.0 Web Programming with VB 2005 by Murach Publication.

(3)Professional VB 2005 by Bill Evjen, Billy Hollis, Rockford Lhotka, Tim McCarthy, Rama Ramachandran, Kent Sharkey, Bill Sheldon by wrox publication.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Re: which book in very useful for vb.net 2005

koolprasad200317-Jul-07 1:14

koolprasad2003

17-Jul-07 1:14

Use Microsoft Press Book
or
WROX books VS2005 is also one of the useful book

regards,
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

How to changeIME mode

iprasad00716-Jul-07 17:45

iprasad007

16-Jul-07 17:45

Hi,

Currently I am working on a multilingual application.

1. I willing provide a Button on UI which will toggle IME mode, say from English to Japanese. How can do that ?

2. How can I detect if systems IME mode is changed by user ?

3. As well as above I want to transliterate the inputed text to english. Can I do it ?

Regards

Prasad

Re: How to changeIME mode

Tom Deketelaere16-Jul-07 21:16

Re: How to changeIME mode

16-Jul-07 21:16

I don't exactly know what you want to do nore how to do it but here is what I found in the online help for vb.net

http://msdn2.microsoft.com/en-us/library/aa293621(office.10).aspx[^]

http://msdn2.microsoft.com/en-us/library/ms904378.aspx[^]

http://msdn2.microsoft.com/en-us/library/bb206300.aspx[^]

espacially the last one looked usefull and complete

hope this helps

iprasad00716-Jul-07 21:46

iprasad007

16-Jul-07 21:46

Thanx for ur efforts Dragon,

but it didn't helped me. What u have given dosent carries information about how .NET handles IME things. Thanx allot.

Prasad

listview smallimages disappear

ESTAN16-Jul-07 12:01

16-Jul-07 12:01

Hello, I encounter strange phenomenon with my listview and smallimages. The images disappear and don't come back, even after reboot, run the application on a different machine. If i create a new listview, it works again for a while. Does anyone can help me with this annoying thing.
The imagelist has 2 images and when i replace the listview i reuse it. Here you have my code, first the declaration of the listview, and second, how i add during the program one element.

Thanks for to take a look into this.

Declaration:
'
'ListView2
'
Me.ListView2.AccessibleDescription = resources.GetString("ListView2.AccessibleDescription")
Me.ListView2.AccessibleName = resources.GetString("ListView2.AccessibleName")
Me.ListView2.Alignment = CType(resources.GetObject("ListView2.Alignment"), System.Windows.Forms.ListViewAlignment)
Me.ListView2.Anchor = CType(resources.GetObject("ListView2.Anchor"), System.Windows.Forms.AnchorStyles)
Me.ListView2.BackgroundImage = CType(resources.GetObject("ListView2.BackgroundImage"), System.Drawing.Image)
Me.ListView2.Columns.AddRange(New System.Windows.Forms.ColumnHeader() {Me.clh_1, Me.clh_2, Me.clh_3, Me.clh_4, Me.clh_5, Me.clh_6, Me.clh_7, Me.clh_8, Me.clh_9, Me.clh_10})
Me.ListView2.Dock = CType(resources.GetObject("ListView2.Dock"), System.Windows.Forms.DockStyle)
Me.ListView2.Enabled = CType(resources.GetObject("ListView2.Enabled"), Boolean)
Me.ListView2.Font = CType(resources.GetObject("ListView2.Font"), System.Drawing.Font)
Me.ListView2.FullRowSelect = True
Me.ListView2.GridLines = True
Me.ListView2.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.Nonclickable
Me.ListView2.ImeMode = CType(resources.GetObject("ListView2.ImeMode"), System.Windows.Forms.ImeMode)
Me.ListView2.LabelWrap = CType(resources.GetObject("ListView2.LabelWrap"), Boolean)
Me.ListView2.LargeImageList = Me.ImageList1
Me.ListView2.Location = CType(resources.GetObject("ListView2.Location"), System.Drawing.Point)
Me.ListView2.Name = "ListView2"
Me.ListView2.RightToLeft = CType(resources.GetObject("ListView2.RightToLeft"), System.Windows.Forms.RightToLeft)
Me.ListView2.Size = CType(resources.GetObject("ListView2.Size"), System.Drawing.Size)
Me.ListView2.SmallImageList = Me.ImageList1
Me.ListView2.TabIndex = CType(resources.GetObject("ListView2.TabIndex"), Integer)
Me.ListView2.Text = resources.GetString("ListView2.Text")
Me.ListView2.View = System.Windows.Forms.View.Details
Me.ListView2.Visible = CType(resources.GetObject("ListView2.Visible"), Boolean)

Add element with imageindex set on 0
Dim item As New ListViewItem("") ' 0
item.ImageIndex = 0
item.SubItems.Add("-") ' 1
item.SubItems.Add("-") ' 2
item.SubItems.Add("-") ' 3
item.SubItems.Add("-") ' 4
item.SubItems.Add("-") ' 5
item.SubItems.Add("0") ' 6
item.SubItems.Add("0") ' 7
item.SubItems.Add("0") ' 8
item.SubItems.Add("No") ' 9
Me.ListView2.Items.Add(item)

Tom Deketelaere16-Jul-07 21:06

16-Jul-07 21:06

I don't immidiatly know why you're images disapear but I'd start by trying to figure out when exactly they disapear
(after a specific action or time)

also try triming you're code to the minimum (perhaps even rewrite some in a differant project and see if the same happens there)

since I'v never encountered this before (and I'v used listviews with images a few times before) I would think that somewhere in you're code there is a mistake that clears the images from the listview or the images from the imagelist

so I'm afraid this might be one of those trial and error debugging things

ESTAN17-Jul-07 1:45

17-Jul-07 1:45

Do you think that all these lines are normal? For example: CType(resources.GetObject("ListView2.Dock"), System.Windows.Forms.DockStyle)

It is referring to the resources file, I am a C# programmer, but I have to make something in vb.net and in .NET 1.1, so I am using VS2003. I never saw this before.

Another, if I change the listview, i have images for a while and than it falls back to its old habit.

This sucks. I'll try to figure out what is causing this problem.

Tom Deketelaere17-Jul-07 2:11

17-Jul-07 2:11

did you import you form or did you start from scratch, added the listview, set its properties,...?

it is possible that you get strange code like that from the designer when importing a form or when copying a control (I don't know why or how but it doesn't always work)

if you did copy it or import it I would suggest you make a new project and start from scratch there (not you whole prog just the bit with the lisview code) and see if you still have the behavior you described if so then something is probebly wrong with the code if you don't get that behavior and you copyed it or imported it then that is probably the reason

if you could providy more detail about all this I might be able to reproduce the behavior and help you further

ESTAN17-Jul-07 4:49

17-Jul-07 4:49

Well what i do is i drag a listview from the toolbox on the form, set the options that i like one by one, and between I run my code in order to see where it goes wrong. And the conclusion is that i arrive to what I would like to have and the images are there.

In the meanwhile i am creating other classes, not really working on that form, and on a sudden debugging the images are disappearing. Pff, I don't know what is going on.

Tom Deketelaere17-Jul-07 5:00

17-Jul-07 5:00

Then I'm afraid I'm at a lose aswel the code you pasted above shouldn't have been generated if you draged it from the toolbox (there should have been a very differant looking code)

all I can think of is recoding that part Sigh | :sigh:

(delete the listview and put it back set its properys, name it the same as before so that you're code still works)

sorry I couldn't be more helpfull

ESTAN18-Jul-07 22:28