I'm just curious that how a month is calculated in the rest of the world because Differences in Months between two dates are calculated differently. In our Insurance Company, we calculate a month as below:
[Code]...
I changed the date of datetimepicker format to yyyy-mm-dd in custom format...but it displays 2009-00-22...the month part is not showing the month of the exact month..how to change the format of the date?
View 3 RepliesCurrently i have a ReturnSystemDate in a module, so that whenever i need the current date and time i call this method, however my data is saving as in 1 format and displaying in another. I have my variables set up as dateTime to store the current date and time, when calling System.dateTime.now.toString() i get 11/08/2010 Time, however when casting to Date as in CDATE() i get 08/11/2010 time. How can i stop this?
View 13 RepliesI want my game to tick over month by month at a set interval. I would use the timer control to get the interval. But how can I pause it? Say if one "month" is 5 minutes in my game and user hits pause. I would disable the timer but then when they unpause the game the timer would start from 0 again. This would make a "month" 9 minutes if a user paused the game in the 4th minute.
[Code]...
I have a problem in trying to get a list of a date including days in a table start from first day of the month to the last day of the month. This date should not include the satuday and sunday. and I should be able to pick up those date for query match.
[Code]....
I'm developing a finance software and I want the user to enter a bill and pick the due date via month calendar. I getting it to work was the easy part, but now I only want one month calendar, for each time a user enters in a bill and picks a date.every time the user goes to pick a due date I have to call one of the several I have on screen.Here is my code that I have so far:Add due date button:
Me
The month calender:
Me
.TxtDueDate3.Text = MonthCalendar3.SelectionRange.Start.Date.ToShortDateString()Me.TxtDueDate3.Text
= MonthCalendar3.SelectionRange.End.Date.ToShortDateString()[code].....
how to do select statement range from month to month using access database.. previously i use this code below when i'm using to selection those between day's or a week activities.. now, how to do range from month to month... the month format is numeric or 1,2,3,4,5,6,7,8,9,10,11,12 (jan.-dec.) representing month the ttmmonth and ttmyear fields are numeric format also in the database... how to do? look here my code for displaying week activities...
[Code]...
i have data coming from sql server with two columns like total items, total packed items. Now in datagridview i want to show another column to calculate %age.Total Packed Items / Total Items Is it possible to add calculated column in datagridview?
View 4 RepliesThis comparison shows the different values of the known good checksum calculation (c#) as used by my client and what I 'hoped' was the vb.net equivalent. How can I get 405 rather than 513 as I currently do?
For i = 0 To length - 2 Step 1
cksum += sendFrameData(i + 5)
Next i
[Code]....
i have three cells in a datagridview third cell gives the result of multiplying first and second cell.When i reload or populate this data from datatable into that datagridview value comes like 40.00. with two decimals. For example
58.00 -------->i need only 58
58.78--------->i need exact 58.78
The only problem is to remove the decimals if they are 0.
I am attempting to develop a Gradebook that one can use to modify grades and have an average calculated at the end.When you first open the form, you see the database fields in the DataGrid (socSecNumber, firstExam, secondExam, finalExam)I have a button to save the changes made here. The exam grades are null in the database.This seems to work fine, however I have a problem with the calculated column I want to add. I want it to display the socSecNumber and the average for that student. Instead, I get all four fields in addition to the semAverage field. Also, all the grades come up 250 if I fill all the fields in with 100.[code]
View 2 Repliesi have a problem with my program i want to work with 2 color's red and green i want get the red color if the calculated - and green if it is +
[Code]...
I have a DataGridView that call a stored procedure. One of the fields is a calculated field, ie Quantity * Price.When I run the stored proc on the server, the calculated field returns a result that shows 2 decimal places to the right of the decimal point. When I run the stored proc in the VB application to fill the DGV, the result in the calculated field shows up to 8 places to the right of the decimal place. Is there a way that it will show only 2 places in the application?
View 3 RepliesHow are coordinates calculated on a form?
Consider the following code:
[Code].....
how can i make a world map that moves with the cursor and ifor example if i press on asia another page will open for asia's map and the same thing for allwith visual basic 2005?
View 3 RepliesI have a DataGrid as a child of a Customer Form based on a Query like this
[code]...
how to change this Linq to Entities (VB.Net) query to Group by L2_ID column and aggregate the calculated column diff as Sum for the group.
[Code]...
I have a gridview that displays a calculated field, based on a db source field it populates with.
can i sort by it? i can't seem to figure out how to do it?
example:
my templatefield looks like this:
<asp:TemplateField HeaderText="Category" SortExpression="category" >
<ItemTemplate>
<asp:Label runat="server" Text='<%# BuildCategory(DataBinder.Eval(Container, "DataItem.category")) %>'
ID="lblPrice"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
where category is party of the datasource, but what gets displayed is a calculated value - which is different from the category.what can i put in the "SOrtExpression" to make it sort by the new value - taht gets displayed?
I am attempting to teach myself visual basic and I cannot figure out how to send a calculated value (on a button click) into a one-dimension array and then recall the last five values in a message box when the user exits.
Here's what I have:
Public Class frmInvoiceTotal
Dim totals(4) As Decimal
Private Sub btnCalculate_Click(ByVal sender As System.Object,
[Code]....
My program is databound to an access 2007 database. I have a datagridview showing rows as part of my screen and the other part of my screen is texboxes bound to a different table.What I currently have:
1. Date in textbox from one table
2. Age in Datagridview column from another table
I need help with having a calculated date column in the datagridview that will be the textbox date + age (in days) in the datagrid column. I would also need this column to store in my database like any other field also. So if I typed in 2/17/11 into the textbox, and I typed in 2 in the age field, the calculated field would display and store 2/19/2011 in my datagrid and database. My dataset designer won't let me add a date to a string so I'm completely lost. A query calculates it easy in access but when I load the access query in my dataset it doesn't calculate anymore.
Im new to this and im currently teaching my self how to code using "sams teach your self C++ in one hour a day" (of course ignoring the 1 hour a day part!)
[code]...
I have some very rusty C++ and lots of C experience, but have done little OO design or coding.I've started learning C++.NET as that seemed to be the best starting point.I've hit restrictions in Microsoft's provision with multiple inheritance and extensions, neither work in C++.Would I be better off starting again with C#, or am I better off using a mixed language approach. eg. extensions in C#, rest in C++?I'm still struggling with this->method or that.property and theother::staticthingy or whatever, and this probably is not an issue in C#. You'll see what I mean as that probably isn't the right way to desribe the difference between '->' '.' and '::'I'm getting to achieve what I want, but it's taking me 10 times longer than I think it should.
View 7 RepliesI have a lot of HD images within my program design and it is causing the screen to flicker when loading other forms. It is kind of
slow too. Is there a way to resolve this, for example, using a reference or component such as DirectDraw. Here are my computer
specifications:
Intel Pentium 4 /2.53GHZ
1.5 GB RAM
512 MB ATI Radeon HD 2400 PRO AGP Video card
19 IN. LCD Widescreen 1440x900 resolution monitor.
could it be the refresh rate of only 60HZ?
I have invoice form bound to a bindingsource and bindingnavigator. In the form I have unit price, quantity and total textboxes. The total textbox text property is set to total.text = quantity.text * unitprice.text in the textChanged event of both quantity and unitprice text boxes. The result is displayed in the total textbox. But when i hit save button on the bindingnavigator it is set to null and not saved to database. [code]When I used msgbox to see the value of total textbox before bindingsource.endEdit() it is the correct value. but after the code bindingsource.endEdit() it is null. I checked the databinding property and it is correct. What is the problem.
View 1 RepliesI am working with a future value application and I am trying to display the calculated future values in a listbox. For instance, I input the monthly investment, the yearly interest rate and the number of years into textboxes and I want the application to list out the future value for each year until the number of years in which I entered is reached. I cannot figure out how to get the code to display the value after each year. I am trying to use the "mod" operator to display the value each time the 12th month comes around.[code]...
View 7 RepliesI have a RDLC report with a list that contains a table. I require a calculated column whose value depends on values from previous rows. Outside of a report I accomplish the same thing using code in a DataGridView's DataBindingComplete method.
From within a report how do I refer to specific cell values from previous rows? embedded code, but I have not had luck (#Error).
ive been struggling on this portion of my code for almost 3 days with no luck. i have a database containing a list of transactions (in this case, the product name, quantity and date of sale). I want to plot a graph for each product showing the amount sold each month for the past 12 months. The functions to calculate these values are working fine. but my problem is this:
each tab page is named after the product name:
TabControl_SaleOfProducts.TabPages.Add(
"TabPage_"
& ProductName, Item)
and then to this tab page i want to add the graph. but i cannot reference the newly created tab page?
At the minute I can display the mouse position using Cusor.Position.ToString() but my screen resolution is widescreem - 1360:768. What about about someone with a standard 1024:768? If I use my application on other computers, it won't work because it deeply depends on mouse co-ordinates
I am aware of a world coordinate system (or something) that will work on all screen resolutions. To use this (which I will need to) I will need to change all of my coordinates in the code? So I'll need to display it in a text box like I did with Cusor.Position.ToString() but what code can I use to get the world coordinate?
There is something like PoibntToScreen and PointToClient but what do these do exactly and how do I use them? I tried using
Code:
MouseCoordinates_tssl.Text = "Mouse Coordinates: " + "{X:" + PointToScreen(New Point(Cursor.Position.X, Cursor.Position.Y)).X.ToString + "; Y:" + PointToScreen(New Point(Cursor.Position.X, Cursor.Position.Y)).Y.ToString + ";}"
but much to my disappointment, it didn't work. What could I do that would work?
I am having a problem trying to get a real time back from this code.
Code:
Public Sub Time()
Dim StartTime As TimeSpan = TimeSpan.Parse(txtStart.Text)
Dim EndTime As TimeSpan = TimeSpan.Parse(txtEnd.Text)
[Code]....
I am using a start time of 09:25 and an end time of 10:15 to test this with. I would like it to return 50, as 50 real world minutes went by. I am getting -1331385.
This is mostly someone else's code from a different forum. I have never used a TimeSpan method before and they keep telling me it works "like what I asked for".
after numerous google searches and comparing excerpts from different peoples' various codes I could not get this program to work, though I came quite close. I'm attempting to make a program that will tell me the time in different parts of the world, a personal use program that I thought would help me exercise my vb skills.
The problem I'm having, however, is that when it should be showing my time it is either 5 hours ahead or 5 hours behind. I tried adding variables and deleted them again time and time again trying to make adjustments but all I managed to do was make the timer get stuck at 12:00:00 AM.
[Code]...