I have kept four column in gridview with dynamically added row...
E.g.
work type rate noofworker amt
Groundwork 10 100 1000
Earthwork 20 100 2000
Total 3000
OnChange event to fire the calculation...
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...
View 1 Repliesthis 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 a gridview in which i have itemtemplates and label controls having data from sql server.
I have two fields say quantity and units and in third field i want their product. I m trying in rowdatabound event like this-
[Code]....
Here my third field is netvalue.
It is throwing error-
Input string in wrong format.
How can i achieve this?
Here is my page:
[Code]....
It basically is 4 questions with each answer assigned a value.
What I would like to do is when the button is clicked the selected values are retrieved and calculated to give a total.
That total is then compared against some common totals and the next value is shown.
So is the total is 8= Very Good, 6= Very Bad, 4= Terrible etc.
The two labels Result and Truth would sho the numerical result and the truth according to the scale.
I am at a loss on how to retrieve the list button clicked value, how to add them up and referance that to the Truth result.
its complicated (to me its "bang head against wall" difficult.
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.
View 2 RepliesI 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.
How do I get around this?
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?
View 1 RepliesIn 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:
<asp:label id=lblTotal text='<%# Convert.ToInt32(Eval("Value1")) / Convert.ToInt32(Eval("value2")) %>' runat="server"></asp:label>
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?
I'm not sure how to do this, but I did read a lot of post and searched for it.
Protected Function GetTotal(ByVal DonTotalQty As Decimal, ByVal DonValue As Decimal)
I have two coloumns in a table to store Registered and Closed dates.
I want to calculate the period and to show in labels templated in detailsView.
Period should be like this:
72 Hrs and 58 minutes
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 m trying to stop the postback causing by ddl. I have tried the following code but still pb doesnt stop:
<script type="text/javascript" language="javascript">
var ddlSubCategory = document.getElementById("ctl00_m_g_73a5a887_bd36_4a37_966a_ed640c804a84_ctl00_ctl04_ctl09_ctl00_ctl00_ctl04_ctl00_ctl00_SubCategory"); //Get this form html source
ddlSubCategory.removeAttribute("onchange"); //Here "onchange" attribute causes post back
</script>
I have a checkbox in gridview. I have a onclick event in which i am checking if there are more than one record selected in the gridview, i need to select only one and de-select other checkboxes.
This is my aspx code:
[Code]....
This is my checkedchanged code:
[Code]....
I am not sure why the check change is not getting trigerred. And, is this code correct for selecting only one checkbox
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'm trying to display a confirm message box before firing selectedIndexChanged when user change selection in the dropDownList. I was wondering if anyone would an example of how to do this.
View 14 RepliesI've been searching for a tutorial or example on how to update my database when I change the text in the textbox that is in a DataList?
View 8 RepliesI'm having trouble generating onchange event code for a simple order form housed in a datagrid.This takes product items from sql database,whereas user can enter quantity (originally set to 25) of cards they want to order (the textbox id is txtQty). if they order 50 (so if they order 25 to 49,the price would stay the same for the lot),the subtotal for that given product will change another 15 dollars greater.,so the formula for the price wouldnt be product * price, but "if qty = qty + 25 then subtotal = price + 15".Then the button click event would add the subtotals to a grand total.
I cannot coordinate teh adequate javascript that would fit with this type of scenario,given that this is all predicated on each product coming from the database; i'm wondering if there is another good source i can be directed to that would show helper functions in the code behind or header subs to calculate the onchange (or textOnchange) event of the textbox.
<form name="mydgrid" runat="server">
<asp:DataGrid id="dgProducts" runat="server"
AutoGenerateColumns="False" CellPadding="4"
[code]...
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.
Below is my .aspx code
<asp:Panel ID="Panel2" runat="server" Height="387px" Width="83%">
<table style="width:108%; height: 390px;">
<tr>
<td>
<asp:Panel ID="Panel1" runat="server" Width="718px">
<table style="width:100%;">
[Code] .....
How can I get a gridview (that is inside an update panel) to update/filter whenever something it typed into a related textbox outside that panel..( possibly in another update panel)?
As in Google. When you start typing, it starts autocompleting for you by looking up words in the background using the text you've typed.
I want, in effect, for a user to start typing in a textbox (say "Order #" textbox) and each time a character is typed, to trigger an update to a gridview that has a 'search param' in it's SQL Datasource SP that plugs the textbox's text into the where clause of the select inside the SP...
make sense? I have the SP and all other related code, I would just need to know how to create a JS function (preferably via server-side using something like:
txtOrderID.Attributes.Add("ontextchanged",....
Rather than hardcoding client-side JS....
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
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:TextBox ID="TextBox1" onchange="calculate()" runat="server" Text="0"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
I'm getting this error on the above markup: Message 1 Validation (ASP.Net): Attribute 'onchange' is not a valid attribute of element 'TextBox'.
I have tried to search web regarding my query but couldn't find what I actually require, I was about 70% near but couldn't achieve what i'm looking for.
To put it simple, below is my query:
I have an ASP page which has a select box (input box) in which I'm adding request numbers through SQL database.
Below are some empty text fields, check boxes.
Whenever any user selects any of the request numbers from the select box, I want to query the database and update the below text boxes and check boxes according to the request number.
I don't want user to press any button or refresh or another frame.
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.
View 4 Replies