Visual Basic

Re: Code for a Calculator

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?

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

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.

Dave Kreskowiak8-Jun-04 9:31

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

Brad Fackrell8-Jun-04 9:36

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

Dave Kreskowiak8-Jun-04 10:08

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

Brad Fackrell8-Jun-04 10:12

8-Jun-04 10:12

Thanks a million!;)

I also found a good simple example:

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

Brad Fackrell8-Jun-04 11:48

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

fo0lish8-Jun-04 5:45

8-Jun-04 5:45

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

Dave Kreskowiak8-Jun-04 6:47

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

fo0lish9-Jun-04 14:59

9-Jun-04 14:59

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

thank you

Dave Kreskowiak9-Jun-04 15:30

adding days to current day being displayed

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

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>

Dave Kreskowiak8-Jun-04 5:38

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

devgeez8-Jun-04 8:16

devgeez

8-Jun-04 8:16

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

Dave Kreskowiak8-Jun-04 8:43

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

client/server read and write

devgeez9-Jun-04 4:45

devgeez

9-Jun-04 4:45

thanks for the feedback...ill make sure and do that.
since all i need to wrap up the project I am hoping that you can share some advice.
This is a display page that already has the values submitted. I am quering the database and bringing the values already submitted on the original form to be display. Where I need the dates +30, 60 or 90 are on my admin page. On this page there are 2 dropdownlist that you can select a topic and the status and then displays the datagrid based on the selection. Lets say I made my selection on the results table it displays rows with the following a row that has the date the form was submitted / name of the form /the department where the form originated from and a link to actually view the form.
ie: <asp:DataGrid ID="dg" Runat="server" Visible="False" Cellpadding="4" Autogeneratecolumns="false" allowSorting="true" OnSortCommand="dg_SortCommand">
<columns>
<asp:boundcolumn headertext="REQUESTED COMPLITED DATE" Datafield="datesubmit" DataFormatString="{0 Big Grin | :-D

}" SortExpression="datesubmit" />
<asp:BoundColumn HeaderText="PRODUCT NAME" DataField="txtProductName" SortExpression="txtproductname" />
<asp:BoundColumn HeaderText="DEPARTMENT" DataField="deptname" SortExpression="deptname" />
<asp:HyperLinkColumn HeaderText="VIEW DETAILS" DataNavigateUrlField="reqid" DataNavigateUrlFormatString="CscReqDetails.aspx?reqid={0}"
Text="View Details" HeaderStyle-CssClass="RedLink"></asp:HyperLinkColumn>
</columns>
</asp:DataGrid>
I need to change the datesubmit based on the selection from the time RadioButtonList id="Time" selection the user makes when he first submits the original form. lets day form was submitted on June 15th, 2004 and they selected that the form needs to be evaluated within 30 days then i need to display on this datagrid July 15th, 2004 as the date. This is what I am trying to accomplish.
thanks for the advice.
I have created the follwing sub function but I am not seing the dates + the time requested for the evaluation.
Sub GetDate()
Dim datesubmit As Date = datesubmit 'System.DateTime.Now.Date
Dim strHold As Date
Dim rdlTime As String
Select Case rdlTime
Case "Standard (within 90 days)"
datesubmit = datesubmit.AddMonths(3)
Case "Escalated (within 60 days)"
datesubmit = datesubmit.AddMonths(2)
Case "Urgent (within 30 days)"
datesubmit = datesubmit.AddMonths(1)
End Select
Response.Write("After : " + datesubmit.ToString())
End Sub

any thoughts?
I am calling this function on the pageload.

fo0lish8-Jun-04 4:52

8-Jun-04 4:52

ok i have searched the web on this and cant find it anywhere,
basicly what i wana do is take info from a textbox on the client side send it to the server, have the server check a access database and return a true of false to the client. My tcpserver is a Console App and my tcpclient is a windows App, also does anyone know of a good book on vb.net, Im ok with vb6 but new to vb.net
thanks
j

Dave Kreskowiak8-Jun-04 5:12

8-Jun-04 5:12

What you describe fits the profile of a WebService perfectly. But if you must use a different remoting option, check out these[^] examples. You might also want to check out a sample that was installed with Visual Studio .NET at <SDK>\v1.1\Samples\Technologies\Remoting\Basic\RemotingHello. This will do about the same thing that you described.

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

fo0lish8-Jun-04 5:20

8-Jun-04 5:20

I think its time to buy a good book about vb.net so i can get the most out of the .net language.....any ideas?

Dave Kreskowiak8-Jun-04 5:30

8-Jun-04 5:30

'Good' is a matter of preference and past experience.
You might want to check out "Professional VB .NET, Second Edition", or "Advanced .NET Remoting in VB .NET". You can find both at Amazon[^].

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

Set Current Directory

Brad Fackrell8-Jun-04 3:48

Re: Set Current Directory

8-Jun-04 3:48

Hi All.

Based on a suggestion that Dave made earlier, I’m trying to ‘set my current directory’ to the value of a variable.

homeDir is a string that holds the current path i.e. c:\current\path

I can’t figure out how to use Directory.SetCurrentDirectoy with this variable. Can anybody help?

Thanks
Brad

Dave Kreskowiak8-Jun-04 3:54