Visual Basic

Re: Insert/Update statement

11-Nov-09 23:10

Do a SELECT with your UPDATE statement's WHERE clause and you should see the reason why your table is not updated.

loyal ginger17-Nov-09 6:12

loyal ginger

17-Nov-09 6:12

I like your answer.

Re: Insert/Update statement

Shameel17-Nov-09 7:45

Insert formula into a vairable range of cells in Excel from VB

17-Nov-09 7:45

Like it for what ?

nhsal6911-Nov-09 1:22

nhsal69

11-Nov-09 1:22

Hi there,

I have the following code which takes data from SQL and then adds it to a Excel Spreadsheet.

This all works fine, but I need to subtract the column "K" from Column "L" and store it in "M"

It inserts the formula into the required number of rows (dependant of the value   "R2") but the formula shows as =(K & D1)-(L & D1) in each cell and not for example =(K 28)-(L 28) etc....

Can you help??

Thanks

<code>
Dim SQlQuery2 As String = "select * from growth where Name <> '[Files]'order by FullPath"
            Dim SQLCommand2 As New SqlCommand(SQlQuery2, myConn)
            Dim SQlReader2 As SqlDataReader = SQLCommand2.ExecuteReader
            Dim R2 As Integer = 27
            While SQlReader2.Read
                  R2 = R2 + 1
                  osheet.Range("I" & R2).Value = SQlReader2.GetValue(0).ToString
                  osheet.Range("I" & R2).BorderAround(8)
                  osheet.Range("J" & R2).Value = SQlReader2.GetValue(1).ToString
                  osheet.Range("J" & R2).BorderAround(8)
                  osheet.Range("K" & R2).Value = SQlReader2.GetValue(2).ToString
                  osheet.Range("K" & R2).BorderAround(8)
                  osheet.Range("L" & R2).Value = SQlReader2.GetValue(3).ToString
                  osheet.Range("L" & R2).BorderAround(8)
            End While
            SQlReader2.Close()
            SQlReader2 = Nothing

            Dim D1 As Integer = 28

            Do Until D1 = R2

                  osheet.Range("M" & D1).Formula = "=(""K"" & D1)-(""L"" & D1)"
                  D1 = D1 + 1
            Loop
</code>

Re: Insert formula into a vairable range of cells in Excel from VB

John M Bundy11-Nov-09 2:36

John M Bundy

11-Nov-09 2:36

The below works, you just have to build the string, yours is a common issue. Everything in the formula should be in parenthesis, then go back and replace all numbers with " & D1 & "

osheet.Range("M" & D1).Formula = "=(K" & D1 & ")-(L" & D1 & ")"

Re: Insert formula into a vairable range of cells in Excel from VB

nhsal6911-Nov-09 2:58

nhsal69

11-Nov-09 2:58

Hi there,

Thats great, working fine now...

Ta v much.....

Running Command Line Files

EvanSaunders10-Nov-09 23:18

EvanSaunders

10-Nov-09 23:18

Good Day All

I created 2 batch files to run a command line program...the first runs the actual program and accepts in a parameter, and the second batch file runs the first batch file with the parameters I give it.

I now need to get some information from this process, the first is the time taken to complete the process, and the second is to get the memory used.

I am trying to create a VB console application (not sure if on the right track) to run the executable, the same way I did in the batch files (sending parameters to a command line program).

Getting the time taken is no problem. my problem is getting the VB console to call the executable (not sure how to do that), and the other problem is getting the amount of memory used running the VB program.

The memory used, is not so important at this point (I can work on that later). I would like to know if anyone could help me with running the executable within my newly created program.

Thanks in advance! Thumbs Up | :thumbsup:

Johan Hakkesteegt11-Nov-09 0:40

Johan Hakkesteegt

11-Nov-09 0:40

Look into the Process class (Process.Start("SomeApplication.exe"), Process.HasExited, Process.ExitTime, etc) to launch the app you want to monitor.

My advice is free, and you may get what you paid for.

EvanSaunders12-Nov-09 22:45

EvanSaunders

12-Nov-09 22:45

Thanks for the assistance. The first bit helped, now I just have to look into it in more depth to extract some further information from the process.

Thanks again! Thumbs Up | :thumbsup:

Shameel11-Nov-09 23:12

11-Nov-09 23:12

Have a look at System.Diagnostics.Process class.

EvanSaunders12-Nov-09 22:46

EvanSaunders

12-Nov-09 22:46

I will look into this. Thanks! Thumbs Up | :thumbsup:

ComboBox BUG!!!???

huamala10-Nov-09 23:07

10-Nov-09 23:07

Hello.
The problem is this: I have two tables:
Requirements(ID_doc, Name_doc, ID_DeliveryType) and
DeliveryTypeCodeList(ID_DeliveryType, DeliveryType_doc).

I put the form fields from the table ‘Requirements’ where the column ‘ID_DeliveryType’ is ComboBox type-a. For ComboBox DataSource I put table ‘DeliveryTypeCodeList’ where column ‘DeliveryType_doc’ is DisplayMember and column ‘ID_DeliveryType’ column is ValueMemeber.

Requirements
--- ID_doc - Name_doc - ID_DeliveryType
________________________________________
-----1--------doc1----------23----------
-----2--------doc2----------23----------
-----3--------doc3-----------2----------
-----4--------doc4-----------3----------

DeliveryTypeCodeList
--- ID_DeliveryType - DeliveryType_doc
________________________________________
---------2--------------poste-----------
---------3---------------fax------------
--------23---------------mail-----------

My wish now is that when I run the program, in the ComboBox it print (descriptive)values from the column 'DeliveryType_doc' (mail, fax, post)!
But it just does not happen?!???

If you have time, there is also the source code of the program: http://rapidshare.com/files/305140006/BugComboBox.rar
or if you want you can see the video where I show that I have tried all combinations: http://www.youtube.com/watch?v=5VK-c39eL-4
THANK YOU!

Dave Kreskowiak11-Nov-09 7:19

Dave Kreskowiak

11-Nov-09 7:19

Noone is going to download your entire project. You have to post the relevant code that sets up the ComboBox and do a better job of explaining what you want. I'm not entirely clear on what the problem is.

A guide to posting questions on CodeProject[^]

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

huamala11-Nov-09 22:53

11-Nov-09 22:53

Watch the video http://www.youtube.com/watch?v=5VK-c39eL-4
and all will be clear.
By the way, there is no code associated with ComboBox.

huamala11-Nov-09 23:29

11-Nov-09 23:29

Apart for not having any code in the project, the WHOLE thing is 160 KB, so why not download it and try what we did.

The project contains only the part that is relevant to the question, and a dummy database that is needed for it.

It contains no code, since we are trying to program the MS way: clicking, dragging and dropping components, without or at least with minimum code written by hand.

That is why we posted the video (11 MB) on the youtube, so people can see what we are trying to do.

So please, if you have an answer, do post it, otherwise, thank you for reading our question.

Dave Kreskowiak12-Nov-09 3:49

Dave Kreskowiak

12-Nov-09 3:49

huamala wrote:
so why not download it and try what we did.

Because I don't run code I do not trust.

You post the relevant code here in your post in PRE tags...

A guide to posting questions on CodeProject[^]

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

huamala12-Nov-09 4:07

How to disable numeric characters? Please help.

12-Nov-09 4:07

use Total Comander to see the files or you can look at the VIDEO.

MarkSquall10-Nov-09 21:41

MarkSquall

10-Nov-09 21:41

Dear codeproject.com administrators and members,

A greeting of peace. I hope everyone is doing fine upon reading this forum.

Well, it's really my first time to try Visual Basic .NET, then I realized that not all my previous experience with VB6 will work smoothly in VB.NET. I am creating a simple program that will enter a name in the TextBox and will greet them by using the MessageBox class. But I wonder, since the TextBox that I'll be using is for inputting a name, I want to "trap" all numeric keys in my keyboard, I just don't know how to do it. This is fair easy in VB6, using the Text1_KeyPress(KeyAscii As Integer) subroutine.

Thank you and more power to all administrators and members. God bless. Blush | :O

Respectfully yours,

MarkSquall

Re: How to disable numeric characters? Please help.

Johan Hakkesteegt10-Nov-09 22:47

Johan Hakkesteegt

10-Nov-09 22:47

Fortunately it is pretty much equally easy in VB.NET, and in some ways even easier:

This example will actually do the opposite of what you are trying to do, but it is easy to adapt to your needs, and I think it shows how .NET makes certain operations even easier than VB6.

Private Sub Text1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Text1.KeyPress
        Try
            If Not (Char.IsNumber(e.KeyChar) Or Char.IsControl(e.KeyChar)) Then e.Handled = True
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub

A nice little added advantage can be found in the Handles bit: here you can actually add other textboxes, if you want them to behave the same way. (Handles Text1.KeyPress, Text2.KeyPress, Text3.KeyPress)

My advice is free, and you may get what you paid for.

Delete a node with double-clicking on it

Milad.Biroonvand10-Nov-09 19:35

Milad.Biroonvand

10-Nov-09 19:35

How can I when double click on a node, I can edit it?
I mean the node is a treeview.
Thank you before answering.
I am waiting for your answer.

Christian Graus10-Nov-09 19:36

Christian Graus

10-Nov-09 19:36

Handle the double click event, it will presumably be passed the node, so delete it from the Items collection in there.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Mycroft Holmes10-Nov-09 21:28

Mycroft Holmes

10-Nov-09 21:28

Handle the double click event on the treeview
use hittest to see if there is a node under the click
Get the node from the hittest
get the parent node from the node
get confirmation from the user
delete the node from the parents node collection

Milad.Biroonvand11-Nov-09 1:19

Milad.Biroonvand

11-Nov-09 1:19

Dear Friends Thank you very much gave the answer
Especially Christian Graus and Mycroft Holmes.
Code is very good. I hope you succeed

Milad.Biroonvand11-Nov-09 3:36

Milad.Biroonvand

11-Nov-09 3:36

You want an example,Or a project for me to upload in this field.
thanks!

Shameel11-Nov-09 23:18