Data Controls :: Calculation In Database And Gridview In VB Code
Oct 5, 2012
I have a web page in asp.net+vb code+sql database. in an table named course_intake i want to count i tried some and it works correct but i am not able to add more clouse to it
1. if date1 (field) not equal to date2 (field) then att pd as 1 else 2
2. (OY is a field) if OY Ends is lesser than Jun then Deg Dt as 1 Jul+ OY end year (example if OY is 5 Jun 2012 then deg dt will be 1 Jul 12 else 1 Dec 12)
3. Count from COURSE_INTAKE where OY LIKE 'YO-' WHERE ENTRY_COURSE= ENTRY_COURSE
4. Count from COURSE_INTAKE where OY LIKE 'TAKEN YO-' WHERE ENTRY_COURSE= ENTRY_COURSE
5. Count from COURSE_INTAKE where OY LIKE 'DONE' WHERE ENTRY_COURSE= ENTRY_COURSE
My code is as under
select ENTRY_course,COUNT(*) as Str,convert (varchar, DTsen,6) as [DTSEN],convert (varchar, DTCOM,6) as [DTCOM],
dbo.getBTechBECount(ENTRY_course) as 'BTECH',batch,dbo.getMedCount(ENTRY_course) as 'MED',convert (varchar,
DTCOM+396,6) as [AVL for OY], str-btech AS [STR AVL]
FROM COURSE_INTAKE group by ENTRY_course,DTCOM,dtsen,batch, str-btech ORDER BY dtcom
I am looking at the following article [URL] .... its converting a gridview to excel. On my gridview I have a running total on the footer, and i do know to to change the code or add code to add this to my excel document...
this is my gridview footer calculation script, this script is working good if the aspx page is independent , when i use the same script with my asp.net master page content page that script is not working this is my script
what changes i have to do for apply this script to be work in my master page content page in asp.net
function GrossTotal() { $("[id*=GridView1]input[type=text][id*=txtCalc]").keyup(function(e) { var price = $(this).closest('tr').find("input[type=text][id*=txtCalcPrice]").val(); var quantity = $(e.target).closest('tr').find("input[type=text][id*=txtCalcQuantity]").val(); var total = parseInt(price) * parseInt(quantity); $(e.target).closest('tr').find("[id*=lblGrossTotal]").text(total); }); }
i have one grid which have 5 columns 1 for subject,2,3,4 for marks which have textbox to insert obtained marks,and last column have one lable to display total of (2+3+4),now i want total value on textbox event,when user enter any value to any column of textbox i need to display total of all three columns in total column.
I currently have 3 tables and return an average value for the OverallRating Column on each to get a CombinedOverall, but what if one of the tables does not have data for a particular customer? if I divide by 3 the answer will not be the same, and I could get an answer that is over the max I want (5.0)
[Code]....
It will be possible that the Customer will not have any data in one of the tables.
I have 3 dropdownlist for date, month, year. When I select DOB from dropdownlist, the age should be calculated automatically and display in textbox. What can i do?
In a formview I need to present a new value calucalted by dividing one field value by another. I need to present the result to one decimal place. The code I am using is the following, however it presents the resulting value rounded up or down to the nearest whole value:
I did try and insert refernces to {0:N1} but this just threw asp.net errors. Any advise on how I can guarantee that the value calculated is presented to one decimal place?
Why am I getting this error? I'm trying to do a calculation on my GridView2 and I'm using clientside javascript. I need to add the onkeyup attribute. How do I do this?
Code Behind:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load CType(GridView2.FindControl("TextBox13"), TextBox).Attributes.Add("onkeyup", "calculateSubTotal") End Sub
I am using a grid form to diplay data... the insert form is completely a separate form. In the insert form a text box called "FormPercentageTextBox" is getting a calculated result using javavascript based on some field ( field1,field2) values (val1, val2).
the problem i have is: when i edit the form and i want to update any value..i want the new calculation result showing on the edited "FormPercentageTextBox" field. I need to have this calculation reflected/
I need to do calculation of different no as shown in fig..right now i am doing addition in the normal way...adding all the values of the textboxes and thenn showig the result in the last textbox..what i want is whenever i change any value in the any textboxes it should automatically reflect the changes in the final calculation(final textbox) without using calculate button.
my query is like this " select product_id, product_price, purchase_amout from purcases"
and on my formview i tried to add a "total purchase"
i tried using <asp:Label ID="total_purchase" runat="server" Text='<%# string.format(cint(eval("product_price")*eval("purchase_amout")),"{ Rp 0:###,###,###,###,###}")%>'>
the total amount show the correct calculation result, but the string format dont work.... so it display 20000 instead of Rp 20,000
btw. "Rp" is the currency symbol in my country... i dont use {0:c} coz the server user US currency
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
my requirement is like i want to insert data to table after caliculation like table name salaryhike columns salaryinput,20%hike, 25%hike and 30%hike salaryinput column details to be input by the user and hike is to be caliculated and inserted with 20%hike, 25%hike and 30%hike are columns of same table.
I want to make sure I go about this in an efficient manner. I have a gridview. On the gridview, I have some columns that are read only values . These values go through calculations based on values in a database. The stored procedure takes information in the database, does some simply calculations (this value * that value / another value type of stuff) then returns a recordset as a datasource for the grid.
Other columns on the gridview have values the users can enter data. I want to be able to provide a recalculate button that will run calculations based on the entered values which will change the readonly values and then repopulate the gridview's read only values without going back to the database. This recalculate button is not the save to the database button. The save to the database button will take the values in the user entered columns and save them to the database. Then, the next time the grid is called, the page calls to the database and loads the grid.
So, what I'm looking to do is allows for recalculations on a gridview, a gridview with about 24 columns and about 1000 rows. My first thought is to create a class that reads the gridview and then applies the business rules, then updates the gridview some how. Or, maybe have a dataset table thats i read the value from the user inputs, then apply business rules and then bind the gridview to the dataset table. Do any of you have thoughts here, maybe have done something like this?
I want to save data to a different table. My save is working fine but the challenge is that it saves empty cells as well.I will like to save only QTyDelivered cell with value. Any empty QTyDelivered cell should be ignored (which means the row of QTyDelivered cell that is empty will not be saved) .How can i achieve this?
Set @StartMonth = Aug Set @EndMonth = Jan Set @StartYear = 2009 Set @EndYear = 2010
I need to insert records into one new table based on the above informations Month name should go from StartMonth to EndMonth and Year also should insert like below
MonthName Year Aug 2009 Sep 2009 Oct 2009 Nov 2009 Dec 2009 Jan 2010
2) when I pass again
Set @StartMonth = Dec Set @EndMonth = Feb Set @StartYear = 2009 Set @EndYear = 2010
It should check for the records already in the database and should not insert the duplicate record. Based on the above case it should insert only one record
MonthName Year Feb 2010
3) I need to also calculate number of days in the month except sat and sunday ..
Like Jan2010 we have 21 days except Saturday and Sunday
Is there any logic through which we calculate the number of days.?
