Spreadsheetgear Form But When Change Its Values And Do Some Calculations On Differed Tabs
Aug 14, 2009
I've got a spreadsheetgear form but when I change its values and do some calculations on differed tabs. I want to be able to save all the data and tabs at it curent state so when I open the application it is at the saved state. I'm not worried about the values before I saved.
View 3 Replies
ADVERTISEMENT
Jan 1, 2012
I have a form with 3 tabs: one tab is for user entry and computations, a second tab shows values that will be used for computations which are read from one database (I call it settings in that the values are constants for calculations but it's not application settings in the way people think of it, to be clear) and the third displays a table from another database. The second tab has a table adapter interface for the dataset that contains values used for calculations that can be changed (to do different scenarios.) Those numbers are read from a single record in a database that has 20 fields and was read once when the data is loaded into the second tab to be displayed.
The problem I am having is that I would like to use the numbers from the second tab (the constants) in computations to be shown on the first tab. I have tried declaring the variables on the second tab as public but they are already "friends" with the form event. However, when I go to use them in calculations, it's like they don't exist.
For example, one calculation I am doing is fuel cost. The user enters miles and this is stored as a variable called mileage. To calculate the result fuelcost, I have to use two other fields that are shown in the second tab: MPG (miles per gallon) and fuelprice (the price of gas). So fuelcost = (mileage/mpg)*fuelprice. These are read from a datatable called testdata which is actually part of the project. I want to be able to use these variables throughout the program but declaring them as public isn't working.
How do I make the variables from one tab usable elsewhere in the program? The other thing I noticed is since the values of the variables are loaded into textboxes and assigned variable names by naming the textboxes, using val([variablename].text) isn't solving the problem either. For example, saying milespergallon = val(mpg.text) is not doing the trick because I am getting a message that 'text' is not an integer when I declare milespergallon.
Update Here the code that is being used:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim mileage = Int32.Parse(Miles.Text)
Dim rate = 0
Dim baserate = 0
[code]....
TabPage2 is where the variables are displayed that I want to use in TabPage1.
Private Sub TabPage2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TabPage2.Click
End Sub
View 2 Replies
Mar 15, 2010
I have a template form with a tab control. How do I change tabs on the form that it inherits from? Do I need a different technique?
View 7 Replies
Feb 28, 2009
i used this code to assign the brand dbs to a value of 200
[code]Private Sub xModelComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles xModelComboBox.SelectedIndexChanged
If xModelComboBox.Text = "DBS" Then
[code].....
View 5 Replies
Jul 22, 2011
Im creating an application that allows me to enter a product with a cost. I want all the costs to be saved in an array and then calculate the total cost and display it in a label. I looked for hours in my textbook and cant seem to get this part.
[Code]...
View 3 Replies
Mar 22, 2011
I am trying to put together a simple form with prices assigned to Radio buttons and check boxes.
I started by creating a simple form with four Windows Form control, two check boxes and two radio buttons, there is also a NumberUpDown Control for quantity but I have not added that yet.
Basically the user make selections, the price is calculated with total and subtotal and displayed on a label.
I am trying to start as basic as possible then work my way up to more complex calculations as I progress.
Here is my Screw up version: :)
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
View 4 Replies
Jul 2, 2009
In the discussion in this thread: [URL] it was reveiled to me that vb.net, using double, could only calculate values up to 18 digits after decimal.... so I started thinking and came up with this class
Public Class LargeNumber
Private pNumber As String
Public Sub New()
[CODE].............
I want to split the string into a series of doubles.... and than combine them into a large number.... The size of each double component should be 18 digits on a 32 bit computer... so that I will have room to add the last carrier...
View 3 Replies
Jan 23, 2009
I'm trying to find a way to force my calculations to round up currency values to the nearest whole pence/cent.By default, rounding will round to the nearest pence/cent, whether this is up or down.I need it to always round up regardless.[code]My client's back office system rounds in this manner which is rather peculiar to say the least, however the prices on his website need to match and to to this they need to be rounded up.The built in ASP.NET Math.Round function only offers the regular rounding(and banker's rounding) and not an option to force rounding up or down.
View 3 Replies
Apr 24, 2009
I am trying to change values in all the objects on my form.
First off I call my function when the form loads
SetFonts(me)
Public Sub SetFonts(ByRef Frm As Form)
For Each Ctr As Object In Frm.Controls
[Code].....
View 3 Replies
Feb 20, 2010
How do I automatically update the values of a listview in form 1 with the values inputted in form 2? I've already declared a few global variables.
View 2 Replies
Dec 23, 2010
i am currently making a project which is to make a cinema screen booking system. My main problem is that although i have most of what is working i need to find a formula to give the full result (overall price) in a label. My other problem is the fact that when i interact with my form certain things dont auto refresh when i change certain values e.g i change number of seats but it doesn't auto refresh the price or anything OR i click one discount then another but nothing changes and it keeps the old value.
Okay in my menu i have a CombBox (ComboBoxScreen) for choosing the film and there are 3 films to choose from in the drop menu each with their own price. I also have a Textbox (NumberSeats) for inputting a number of seats you want to book for chosen film. And lastly there are 3 radio buttons each with different discounts. e.g No discount, 10% off and 25% off. A formula to work out the overall price uses all three functions/tools above. [Code]
View 1 Replies
Jul 11, 2010
I'm trying to change the values of some of the controls in the ASPxGridview Edit Form, however they are not changing. It seems to be resetting? How can I do this and in which event would I do this in?
View 2 Replies
Apr 2, 2009
Change tabs in the IDE using keyboard?
View 3 Replies
Sep 3, 2009
I need to change the shape of my tabs... untitled.JPG
View 2 Replies
Aug 13, 2009
I have loaded an Spreadsheetgear Form with 5 Taps (Sheets) in a Windows Form Application (Form2). I also have anouther windows Form Application (Form1) with 5 Buttons on it but I can't work out how to make each button open the Windows Form Application (Form2) with a different Tab (Sheet) open?
View 3 Replies
Sep 5, 2010
when the page loads (I cant use WebBrowser1.Navigated because im using tabs)
i want it to change TextBox1.Text to the Selected Tabs URL
I tried
TextBox1.Text =
CType(TabControl1.SelectedTab.Controls.Item(0),
WebBrowser).Url.ToString()
But i keep getting an error message
View 8 Replies
Aug 3, 2010
How can I change the color of the tabs of a tabcontrol? I tried to search the forum but everytime I hit the search button I get an "Bad Gateway" error.
View 2 Replies
Sep 19, 2008
I am creating an application for Windows Mobile 6 in Visual Studio 2005. I have a TabStrip on the main form. There are 2 buttons i want at the top of the tab strip, but i don't want them to be part of it. I need the same buttons to show when the tabs change. I used to use the ZOrder function or Parent function but can't see how to do it in the new version. Any ideas?
View 4 Replies
Nov 3, 2010
When I load an xls file, which is created by the user, to SpreadSheetGear workbook it changes date format from dd/mm/yyyy to mm/dd/yyyy. How can I prevent this?I use the code below (VB.NET) to load xls file:
WorkbookView1.ActiveWorkbook =
SpreadsheetGear.Factory.GetWorkbookSet.Workbooks.OpenFromMemory(xlsFile)
xlsFile is a Byte array.
View 1 Replies
Jul 5, 2010
I have this code that changes the title of Tab only when it is selected see this code
[Code]...
View 6 Replies
Apr 17, 2009
I have a web browser with tabs, and I wanted to know the following:
1. When yougo to a webpage the Tab name will be the websites title, if the title is over
2 5 characters, then it ends with a "..."
2. how do I make the adress bar URL change when switching tabs?
View 10 Replies
Mar 16, 2009
I was wondering if there was a solution to replacing the tab control's tabs with custom tabs made in Photoshop. I know there are plenty of super expensive programs that can do it, but I was wondering if there was a way to do it programmatically. I was thinking that maybe it could linked in some way with a .DLL?
View 1 Replies
Mar 6, 2009
My code is basically a file parser/editor and it handles most files fine as they hold a handful of records concerning family members. However there are a few files that crash when trying to deal with them. Here is the problem.Each family member record creates 3 tabs that hold an average of 3 group boxes each. Each group box holds an average of 3 text boxes.So each member record creates 3x3x3 = 27 text boxes and some files get up to 289 family members which = 7803 text boxes.
The problem is the rare file with 400+ member records = 10,800 text boxes which causes a crash due to using up all the window handles. Each member has a separate tab page (with 3 subpages) but really only a dozen or so member pages are visible in the GUI with scroll arrows to move through them so I was thinking of somehow making the GUI a scrollable window so the tabs get built, displayed and disposed as the user scrolls left and right through the member tabs.
The files are parsed into a 3d list DataList(x,y,z) where x is the page number, y is the group box number and z is the text box number. So all the data is available. The code then traverses MyList and builds GuiList(x,y) where x is the page number and y is the groupbox number with all the textbox.text linked to MyList(x,y,z) locations so all text changes are reflected in the MyList.
I already have a memberCount variable and I am thinking of building, say, the first 30 member tabs with the middle 10 being visible in the GUI. If the selected tab > 20, then dispose of the first 10 tabs and create tabs 30-40.I am thinking I will keep all the member tab pages so I don't have to deal with inserts and indexing problems but just dispose all the group boxes and text boxes for tab pages out of view. I already have a deep clone sub that clones members when the user wants to add a new family member and I am thinking I will have to add something similar when a tabpage is passed in for disposal, it traverses and disposes each text box, then disposes the group box for each group box on the tab page.Additionally, another routine will rebuild the group boxes from the data held in MyList(x,y,z) when a tabpage(x) is passed in.
View 2 Replies
Jul 14, 2009
I am using Visual Basic express edition 2008.I am trying to know if a value in a single dimensional array is repeated in the array. If yes, then multiply one of them by 100. For example:
MyArray (14) = 12, 15, 18, 15, 18, 11, 15, 18, 16, 14, 18, 8, 12, 17, 10
In the above example:
MyArray (1) = MyArray (3) = MyArray (6) = 15
MyArray (2) = MyArray (4) = MyArray (7) = MyArray (10) = 18
MyArray (0) = MyArray (12) = 12
[Code]...
View 8 Replies
Apr 5, 2010
I have two tabs on a form, and I would like to know how can I display the second one when a button is clicked? The name of my tab control is tabSurvey.
View 5 Replies
Sep 23, 2011
I have buttons a few text boxes etc on a form, however I want to move it all to a tab (as in the tab control). I add a new tab control, cut all the buttons and textboxes, paste them into the tab control on tab 1. All good so far. When I run it, and click the buttons, they dont do anything. Do I need to move all the code to somewhere else or something?
View 5 Replies
Jan 14, 2010
I start my program with a splashscreen and as soon as the mainform is loaded, databases are loaded and data is crunched it shows the form with everything on it. All very nice. But now comes the trick. The form has a strip of 5 tabs on it. The active tab is shown and directly accesible but as soon as i click on the other tabs it needs time to draw everything and calculate its content. And when i have clicked through all of them everything is finally up to speed. How can i speed things up in such away that all this predrawing etc is done in the background just as i got it to work with my mainwindow and its first tab?
I have this in the load sub:
For i = 0 To TabControl1.TabCount - 1
TabControl1.TabPages.Item(i).Invalidate()
Next
But some how this does not do the trick.
View 3 Replies
Feb 28, 2011
I am working on a project that requires the use of multiple tabs, but the problem is all my codes/layouts so far has been on a single form. How easy would it be to transfer the existing codes and layouts on a single form to a multi-tabs environment ?
View 4 Replies
Jan 13, 2010
I'm working on a simple base form in which all the other forms in the project will inherit. This base form only adds 5 properties (at the moment) dealing with painting a gradient background. The problem I'm facing right now is when I change a property on Form1 (the test form) and click run it doesn't show that change. I also checked the .designer.vb file and when I make a change it's not added to the code behind file, I'm at a loss right now to why.
[Code]...
View 5 Replies
Aug 10, 2010
I have a GridView and by RowDataBound event I change the values of my last column. I want my last column to have as values the sum of each row.
Below is my code
If e.Row.RowType = DataControlRowType.DataRow Then
'total of row
Dim i As Integer
Dim total As Integer = 0
Dim dt As DataTable
[Code]....
View 4 Replies