getting listbox contents.. - Visual Basic Discussion Boards

Re: Why onpaint doesn't work in numericupdown

Aaron Eldreth9-Jun-04 3:02

9-Jun-04 3:02

The reason your OnPaint method doesn't work, is because the Numeric Up/Down control is derrived from the Windows common control, and Windows handles the drawing of the NUD.

To accomplish what you want, you need to derrive from the Control or UserContrl (which you have), and do the painting yourself.

Aaron Eldreth
TheCollective4.com
My Articles

While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy

Re: Why onpaint doesn't work in numericupdown

beifangcc9-Jun-04 17:30

beifangcc

9-Jun-04 17:30

Can you tell me more detail ?
I found in normal form use numericupdown Paint event still cann't draw theme.

Re: Why onpaint doesn't work in numericupdown

10-Jun-04 4:16

Like I said before, the Numberic Up/Down control is simply a .Net wrapper of the Windows common control.

Basically what this means, Windows draws the control. Not the .Net FCL (Framework Class Library).
Since Windows draws the control, you can't override the OnPaint method to allow theming.

What you would have to do, is inherit from the Control or UserControl. I'm going to assume that you will inherit from the UserControl. What you would do, is place two buttons onto the designer, one for the Up button, the other for Down (You could then theme the buttons, I think). You would then make a property for "Value". Each time the user clicks on one of the buttons, the property "Value" would change accordingly. Then you would use GDI+ to draw the value.

dim g as graphics = me.creategraphics
g.drawstring(val(value), me.font, new brush(me.forecolor), xpos, ypos)

Aaron Eldreth

TheCollective4.com
My Articles

While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy

Re: Why onpaint doesn't work in numericupdown

beifangcc10-Jun-04 15:55

beifangcc

10-Jun-04 15:55

Thank you very much.

Re: Why onpaint doesn't work in numericupdown

Aaron Eldreth11-Jun-04 3:20

Aaron Eldreth

11-Jun-04 3:20

Sure. Glad to give you some pointers.

Aaron Eldreth

TheCollective4.com
My Articles

While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy

Dropdownlist

dotnet_cpp8-Jun-04 19:50

dotnet_cpp

8-Jun-04 19:50

my web service returns Xmlnode. I want to read attribute name and populate Dropdownlist.

Here is what I have been trying .. nothing seems to work ... any suggestions please

Dim SearchResult As MyWebservie = ar.AsyncState
Dim node As XmlNode = TicketSearchResult.EndGetEventList(ar)
//Dim ReadNode As XmlNode = node.SelectSingleNode("DATA") //
Dim Reader As New XmlNodeReader(ReadNode)

//Dim mydataset As New DataSet
//mydataset.ReadXml(Reader)

//Dim resultNodes As XmlNodeList = node.SelectNodes("raw") //node i need attributs from this

// Dim iCount As Integer = 0
// Dim aNode As XmlNode
// For Each aNode In resultNodes
// DropDwonLis1.Item.Add /// Console.WriteLine("Node {0} value: {1}", ++iCount, aNode.InnerText)
'ToDo: Unsupported operator
'ToDo: ++ operator not supported within expressions
Next aNode

here is what web service returns

- <root>
- <methodinfo>
<channelname>Search
<methodname>MyWebservice
<parameters>?APP_ID=1
<processtime type="milliseconds">453.1366

-
<row thisid="2" thisname="Beach ST=" "="">
<row thisid="1" thisname="Playhouse" st="GA">
<row thisid="3" thisname="Arena" st="MD">
<row thisid="4" thisname="Park" st="CA">

I want THISNAME IN DROPDOWNLIST and THISID as option Value in dropdownlist

Re: Dropdownlist

Dave Kreskowiak9-Jun-04 0:07

Dave Kreskowiak

9-Jun-04 0:07

Uhhh...What's this?

Dim SearchResult As MyWebservie = ar.AsyncState

This would appear that your defining SearchResult as your WebService, then assigning an AsyncState to it, but after that, you never use it. Also, what is ar? You switch to something called TicketSearchResult and call its EndGetEventList method.

As it is now, this code is completely incomprehensible. On top of that, we don't know what the code for the WebService method looks like, so we don't know if it is indeed returning what it's supposed to.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

getting listbox contents..

JasonRey8-Jun-04 16:54

JasonRey

8-Jun-04 16:54

hi. how do i retrieve the contents of my listbox to the first excel sheet? after that, new sheets will be added and named according to the contents of the listbox. any help would be appreciated. thanks a lot guys!! Big Grin | :-D

Re: getting listbox contents..

Dave Kreskowiak9-Jun-04 6:57

Dave Kreskowiak

9-Jun-04 6:57

You would have to set a Reference to the Microsoft Excel whatever.0 Object Library, then use something like the following code to create an instance of Excel and populate some cells:

Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

'Start a new workbook in Excel
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add


'Add data to cells of the first worksheet in the new workbook
Set oSheet = oBook.Worksheets(1)
oSheet.Range("A1").Value = "Last Name"
oSheet.Range("B1").Value = "First Name"
oSheet.Range("A1:B1").Font.Bold = True
oSheet.Range("A2").Value = "Doe"
oSheet.Range("B2").Value = "John"

'Save the Workbook and Quit Excel
oBook.SaveAs "C:\Book1.xls"
oExcel.Quit

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Code for a Calculator

nofrills138-Jun-04 16:14

nofrills13

8-Jun-04 16:14

Can anybody help me get the code in Visual Basic.net for a simple calculator?

Re: Code for a Calculator

Jim Taylor8-Jun-04 22:15

Jim Taylor

8-Jun-04 22:15

Visual Basic - VB.NET Calculator

Jim

TreeView in run time

Brad Fackrell8-Jun-04 9:16

Brad Fackrell

8-Jun-04 9:16

Does anybody know if a TreeView can be edited during runtime?

I know that I can modify the text in a node but I would like to be able to also add and remove nodes.

Thanks.

Re: TreeView in run time

Dave Kreskowiak8-Jun-04 9:31

Dave Kreskowiak

8-Jun-04 9:31

Sure. The Nodes collection can be modified at any time. You just have to provide a means for the user to select the node(s) and add/delete them.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: TreeView in run time

Brad Fackrell8-Jun-04 9:36

Brad Fackrell

8-Jun-04 9:36

I know you don't want to write the code for me... Roll eyes | :rolleyes:

But do you know of any good resources that will describe the procedures?

Thanks
Brad

Re: TreeView in run time

Dave Kreskowiak8-Jun-04 10:08

Dave Kreskowiak

8-Jun-04 10:08

The procedure is entirely up to you. Weather you use contect menus (right-click) on individual items or by the user clicking on items and then using a couple Add and Delete buttons, or using Menu to do the Add's and Delete's...

You would have to use the TreeView's SelectedNode property to get the node that is currently selected. After that, it's a simple matter of calling the .Add method on that node's Nodes collection to add child nodes, or to call the .Remove method to delete that node.

You might want to take a look at this[^] sample code to see how Remove and Add works.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: TreeView in run time

Brad Fackrell8-Jun-04 10:12

Brad Fackrell

8-Jun-04 10:12

Thanks a million!;)

I also found a good simple example:

http://www.vbdotnetheaven.com/Code/Jun2003/2083.asp

Re: TreeView in run time

Brad Fackrell8-Jun-04 11:48

Brad Fackrell

8-Jun-04 11:48

Hey, we even have a good example right here at The Code Project:

http://www.thecodeproject.com/cs/miscctrl/treedragndropdemo.asp

Re: client/server read and write

fo0lish8-Jun-04 5:45

fo0lish

8-Jun-04 5:45

sorry to keep buging you, but now im thinking WebService.
Would you think this is the way to go?

Re: client/server read and write

Dave Kreskowiak8-Jun-04 6:47

Dave Kreskowiak

8-Jun-04 6:47

From the description of the problem that you gave, it sure is. Very easy to implement too.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: client/server read and write

fo0lish9-Jun-04 14:59

fo0lish

9-Jun-04 14:59

would you be so kind as to point me to a good example on this project

thank you

Re: client/server read and write

Dave Kreskowiak9-Jun-04 15:30

Dave Kreskowiak

9-Jun-04 15:30

A simple Google on "WebService VB.NET Tutorial" turns up a bunch of them...
http://abstractvb.com/code.asp?F=1&P=2&A=1004[^]
http://www.freevbcode.com/ShowCode.Asp?ID=4204[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

adding days to current day being displayed

devgeez8-Jun-04 5:08

devgeez

8-Jun-04 5:08

I have a datagrid where you can click and view form submittions. I am displaying the title of the form and the date the form was submitted. On the original form I had a radio button list that requests the time of the evaluation ie:
<asp:radiobuttonlist id="Time" Runat="server" RepeatDirection="Vertical">
<asp:ListItem Value="Standard (within 90 days)"></asp:ListItem>
<asp:ListItem Value="Escalated (within 60 days)"></asp:ListItem>
<asp:ListItem Value="Urgent (within 30 days)"></asp:ListItem>
</asp:radiobuttonlist>
I have now been asked to display my result page with the date plus what ever the user choose on the radio button.
So something like this 5/01/2004 +30 days = 6/11/2004 (as the day I should display.
or 5/1/2004 +60 days = 7/1/2004 and so on.
Problem is I dont know how to accomplish this.
Can someone guide me...
here is my datagrid
<asp:DataGrid ID="dg" Runat="server" Visible="False" Cellpadding="4" Autogeneratecolumns="false" AllowSorting="true" OnSortCommand="dg_SortCommand">
<columns>
<asp:boundcolumn headertext="DATE SUBMITTED" Datafield="datesubmit" DataFormatString="{0 Big Grin | :-D

}" SortExpression="datesubmit" />
</columns>
</asp:DataGrid>

Re: adding days to current day being displayed

Dave Kreskowiak8-Jun-04 5:38

Dave Kreskowiak

8-Jun-04 5:38

There are several ways of doing this, but the easiest is haveing your database server return the dataset with the number of days already added. You'll have to supply the number of days to add to a function in your data access layer and have that function return the dataset from the database. The function will call the database stored procedure with the number of days to add. The stored procedure will return the records for the function to return in a dataset.

The SQL statement might look something like this:

SELECT DATEADD(day, @DaysToAdd, submitteddate) FROM tablename

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: adding days to current day being displayed

devgeez8-Jun-04 8:16

devgeez

8-Jun-04 8:16

thanks for the feedback. do you have a sample i can go by.

Re: adding days to current day being displayed

Dave Kreskowiak8-Jun-04 8:43

Dave Kreskowiak

8-Jun-04 8:43

Don't tell me you're doing something like this:

Dim sqlComm As New SqlCommand
sqlComm.CommandText = "SELECT god knows what FROM god knows where"
sqlComm.CommandType = CommandType.Text

I would HIGHLY SUGGEST, no, DEMAND (yeah, that's more like it!) that you stop this practice now and rewrite your code to use stored procedures and parameterized queries. I, obviously, can't stress this enough...

Here's[^] a sample of what I'm talking about...and this[^], and whatever you do, don't skip this[^] chapter from Patterns & Practices. I know it's kind of long, but it is THE most important thing your going to read about ADO.NET data access and how to do it properly!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.