I would like to pass a value and add to it with the previous value thats what I want.The below code doesn't work...I can't understand the problem..Actually its for rdlc - total purpose I need it.My Code
public MyValue as Decimal=0
public Function AddToSum(ByVal quantity as Decimal) as Decimal
MyValue=AddToSum+quantity
AddToSum=MyValue
return AddToSum
[Code]...
In my report I want to display the dollar amoumt in textboxs.So I set the textbox property Format as currency.My question is that I want to reports show brackets for negative dollar values. It works out except "$" sign being showing whenever there''s an amount showing. I want to remove this "$" sign from the report.
View 1 RepliesHow do I code the total cost to give me a pound sign with the total cost at the moment when the total comes up for an example it gives me 3.6 when I need it to show £3.60 here is the code I have so far. [code]
View 2 RepliesI have a custom business object which overloads the .ToString() function. It also implements IFormattable.ToString, so I can define my own custom formats.This approach seems to work everywhere in my app, except .rdlc reports. For example, I have a text field on a report with the following expression:
=Fields!MyField.Value.ToString("lr")
"lr" is a custom format I have created. When running the report I always get #Error as the output. I've placed breakpoints in my .ToString function and stepped through the code as the report is running, and I know the function is returning the correct value, but the report just doesn't seem to be capable of receiving and displaying it.
I am developing a small application with VB 2008 and MS SQL 2005. For reporting using RDLC reports. Everything is going well except page wise total.I need page wise total on each page and each(all) page wise total should be displayed on last page. I need the report output like this.
SrNo. Amount
1. 200
2. 200
3. 200
[code]....
Note : No. of rows/page are not fixed.For group Total I have used Sum function of rdlc table with scope table_Group2 & for Grand total I have used Sum function of rdlc in table footer with dataset scope.For page wise total I have used textbox in Report footer (=Sum(ReportItems!amt.Value). How to get page wise totals on last page again.
I am trying to implement a function for my SSRS report which will return a color value depending on the values of three dates.
[Code]...
I am using following code in rowdatabound fn.
Protected Sub gvwMileStone_RowDataBound(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
[code]...
ddlEProjectLevels is dropdownlist in edititemtemplate.Whwn i click edit in 1st row ddlEProjectLevels gets loaded with data from database.But in 2nd row dropdownlist does not contain values.Again in 3rd it gets loaded from db.Means in alternate rows,when i click edit dropdownlist(ddlEProjectLevels) doesnot load values.Can anybody help?
I have an RDLC report that I am rendering directly to the Response Stream as PDF (rather than using the ReportViewer). In the code that renders the report, it's DataSource is bound to a List(Of ClassA) objects defined in a custom assembly. This seems to work for the most part. My problem is that I can't seem to handle the situation where a nested object is null. For example, given ClassA and ClassB (the nested object) defined as follows:
Public Class ClassA
Public Id As Integer
Public Name As String
[Code]....
the report displays "#Error" if TheNestedObject is null. If TheNestedObject is not null, it correctly displays the Name.
Create an application that calculates the total cost of a stay in a hotel If the check in occurs in November-March the rate is $89/night. April-August is $99/night and September-October is $109/night. $10/night should be added if more than 2 people are in the room. More than 4 people are not allowed in the room, and a traveler can only request 1 room. A 15% tax should be added to the room rate and 10% tax added to all room service and other charges. No tax will be added for phone charges.
The program should use a function to calculate the total charges for the visitor's stay and output it to a label. There should be buttons or menus to calculate the total, clear the form, and exit the application. At least one of the button should call a sub procedure which performs its function. [Code]
This is what I have, but its not working for the total at the end..the IF bit at the subtotal...
Description
Qty
Unit Price
Total
FORMTEXT
[CODE]...
show me the vb code to count total of row in my sql?
View 1 RepliesI have a assignment and I have got to do the total cost and put the total in a label, here is the code. Select Case pizza1
[Code]...
i wrote an application in VB.NET and since i charge by the line, i would like to calculate how many lines i wrote. i have about 100 different vb files with my code. how do i count all the lines?
View 8 RepliesThe pay rates for the project are:
a. Level 1 - $10.00
b. Level 2 - $12.00
c. Level 3 - $14.00
d. Level 4 - $16.00
e. Benefit Deduction Rate - 0.10
f. Overtime Factor - 1.5
For ease of program maintenance, all of the above rates and factors must be stored in module level constants. All references to pay rates in the program must refer to the module level constants.
When the Calculate button is clicked:
a. The value in the Hours text box must be validated to insure that it is numeric value greater than zero.
1. If the value is not valid, a message box must appear as shown below and the user must be offered the option to continue processing or quit the program.
2. If the user chooses to continue processing, the focus must be set to the Hours text box.
3. If the user chooses to quit, the program must close immediately.
b. If the value is valid, the program must calculate and display the total pay in the Total Pay label.
1. The pay rate is determined by which Job Grade radio button is checked.
2. For hours less than or equal to 40, the total pay is the hours times the pay rate.
3. For hours greater than 40, the total pay is 40 hours times the pay rate plus the hours in excess of 40 hours times the pay rate times the Overtime Factor.
4. If the Full Time radio button is selected, the total pay must be reduced by the Benefit Deduction Rate.
5. The value displayed in the Total Pay label must be formatted with a dollar sign and with two decimal
places.
6. The focus must be set to the Hours text box.
Why i get an error when i try to run this code
Code:
Also the message box, both yes and no close the program.....
I am working with VB 2008. I want to be able to run this program say in N: and it will show me in an excel sheet the following:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
where clients contains subfolders and files and the size is the total of all those files within each folder and the count is the total within each folder also.
This works fine as it is but i have to select one by one the top level folders and some of them are huge so it takes forever to give me an answer.
1) I would like to see in my spreadsheet the following by only select the network drive n:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
N:Software 10.7 15430
N:Billing 0.98 105
2) I would also like to know if this is the faster method.
3) I tried adding a progress bar so that the user can have an idea of how much this will take but i had to remove because it was not working.
4) I would like to see the folder name, size of folder and count of files in the listview.
Here is the code:
Imports Microsoft
Imports Microsoft.Win32
Imports Microsoft.Win32.Registry
Imports System.Collections
[code].....
I am using visual basic 2008 amd creatomg a datagrodview format like below [code] Now I wnat to get total balance in total column after less discount in percentage with ENTER EVENT proceedure and get the whole total column balance in a textbox i.e Net BalanceTextBox. Please tell me how to calculate discount in percent % and get total in total column and also tell me how to move cursor in next cell instead of bottom row in datagridview.
View 2 RepliesI have 3 columns in a unbound datagridview, "length" "height" and "Total". Total = length x width and the final total in TextBox outside of the Grid. I found question simalar in this forum and tried the code but i am getting errors.The following is the code i am using
Public
Class Form1
Dim UnboundColumn[code]...
Possible Duplicate:
calling ASP function from javascript
okay running this code :
<script type="text/javascript">
[code].....
I just want to draw some lines between the rectangles in vb.net. I used g.drawstring() method to that.
But now, based on a value I just want to change the opacity of the arrow.
How can i get the string within a parenthesis with a custom function? e.x. the string "GREECE (+30)" should return "+30" only
View 5 RepliesI have a function Process(data, f) where data is a normal parameter and f is a function needed to process the data (passed as a delegate to Process)
The signature of f is int f(a,b,c), with a, b, c supplied by Process when it calls the delegate.
Up until here, standard delegate usage.
Now, I have a special but common case where I would like to call Process with a constant f function. So I would like to write SimpleProcess(data, k) so that the caller does not need to create a delegate in this case, just pass the constant k (the only information needed).
So I need to dynamically create a constant function, g(a,b,c) which takes 3 parameters (which are ignored) and always returns k. This has to be done within the SimpleProcess function, so that I can then simply call Process(data, g) from within that function, without the need to rewrite the whole Process function for this special case.
I wanna make a program that asks the user to enter a dll file path/name & a function in that dll file with args & gets the results
View 6 Repliesi read an article about datacolumn.expression property here [URL]. this is really great. but i was just wondering, for my case i want to use my custom function to use in the expression. basically, on my datatable i added an unbound column AGE. when i display records, i just want the age textbox to be populated with the computation of the person's age based on birthdate.
View 7 RepliesThis is my first time writeing a program and i am stuck. i am just looking for were i should go next. i can't figure out how to write in code for the days in the getDay function.
Write a program that computes the cost of a long-distance call. The cost of the call is determined according to the following rate schedule:
a. Any call started between 7:00 A.M. and 9:00 P.M., Monday through Friday, is billed at a rate of $0.30 per minute.
b. Any call started before 7:00 A.M. or after 9:00 P.M., Monday through Friday, is billed at a rate of $0.15 per minute.
c. Any call started on a Saturday or Sunday is billed at a rate of $0.10 per minute.
The inputs will consist of (1) the day of the week, (2) the start/end time of the call, and (3) the length of the call in minutes. The output will be the cost of the call. Input will come from the user and outputs will be displayed via the console window.
Module program1
Sub Main()
Dim day As String
day = GetDay()
[CODE]...
I'm new to forums as well as new to VB 2008. I'm in process of making a order calculator which will total any values you selected in combo boxes/checkboxes and then display it in a selected area. There are 3 things that I want to achieve: 1. Be able to add another total to an existing total (currently I'm able to see only one total when I hit "Calculate" button)2. Display how many orders I have made so far (new total counts as one order)3. Be able to add up checkboxes selected to an overall total. (when I try to add up one checkbox with another it seems to be stuck on 1.5 pounds which I assigned for each "side order")
View 4 RepliesI am trying to call cetralized class function ONservervalidate for a custom validator, So I don't have to write it on each and every page.
View 1 RepliesDuring a code review I looked at set of repository classes (in vb.net). I am used to seeing these repository classes full of functions that return collections (among other things) of your domain objects. However, this repository had 1 public property and 1 private variable that looked something like this:
Private _item as Collection (of Customer)
Public Item as Collection (of Customer)
Get...
Set...
In the "Get", there is code that gets a the Customers from the DAL and loads it in the private _item. What would the benefits be in using a property (customerRepository.Item) instead of plain old function (customerRepository.GetAllCustomers)? The "Property" way looks odd to me but odd doesn't always mean wrong.
I'm wondering whether its possible to have a function's return type and input arguments as a variable.
For example this function:Private Function MyFunction(ByVal argument1 As VariableType) As VariableType
[Code]...
how to make linq2sql behave like my custom code used to, I want to check to make sure that it isn't already "built" in behavior that I can just use by setting up the relationships right in the designer...
Very simple example: I have two tables: Person and Notes, with a 1 to many relationship (1 Person, many notes), linked by Person.ID->Note.PersonID.
I have a stored procedure (all data access is done via SP's and I plan on continuing that) which makes the Link2SQL a bit more work for me.
sp_PersonGet(@ID int) which returns the person record and sp_PersonNotesGet(@PersonID) which returns a set of related notes for this person.So far so good, I have an object:
Dim myPerson As Person = db.PersonGet(pnID).Single
and I can access my fields: myPerson.Name, myPerson.Phone etc.and I can also do a
Dim myNotes As Notes = db.PersonNotesGet(pnID)
to get a set of notes and I can iterate thru this list like:
For Each N As Note In myNotes
( do something)
Next[code].....
Basically, Linq2SQl would need to call 2 stored procedures each time a Person record is created...Is this doable "out of the box", or is this something I need to code around for myself?
I have a CodeSmith 6 project setup in Visual Studio. I added a class with a shared method (VB), but cannot refer to it in my template. I also tried adding an assembly reference to the project DLL, but that didn't work either. How can I use my own utilities like this?
View 1 Replies
