DataSource Controls :: Correct Calculation For Avg If One Table Has No Data?

Mar 24, 2010

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.

How do I get around this?

View 10 Replies


Similar Messages:

Forms Data Controls :: The Total Amount Show The Correct Calculation Result, But The String Format Dont Work?

Feb 27, 2010

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

View 4 Replies

Correct The Method For The Calculation?

Jan 23, 2010

to correct the method for the given below calculation:-

if num1 <=2.500 then

num1.text= (num1) % 10 + Num1

else num1=num1.text= (num1) % 10 + Num1

if num1 >2.500 <=10.00 then

num1.text=(num1) % 10= + Num1

else num1.text= (num1) % 10 + Num1

if num1<=10.000 then

num1.text=(num1) % 2 + Num1

else num1.text= (num1) % 7+ Num1

if num1 <=10.000 then

num1.text= (num1) % 6 + Num1

View 2 Replies

DataSource Controls :: Trying To Get The Correct Info Belonging To The Correct Id?

Mar 6, 2011

I am using 3 tables and are trying to get the correct info belonging to the correct id. Like this: I go to a page and here i want to see the information from the 3 tables using a specific id.

I have written this so far in a query:

[Code]....

My problem is that the last line does not work and i am uncertain how to make this work? How to write it correctly that is.

View 2 Replies

Forms Data Controls :: Get A Correct Row Index After Refresh The Gridview Table?

Oct 21, 2010

i am facing a problem to get a correct row index after i filter the data in table, it always keep the history row index in the table before i filter. i had a search button to filter the data in gridview,

below is my coding:

[Code]....

[Code]....

View 4 Replies

DataSource Controls :: Month And Year Calculation In Stored Procedure?

Jun 18, 2010

I have a problem described below

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.?

View 5 Replies

DataSource Controls :: The Correct Code Syntax To Insert Row Of Data?

Nov 8, 2010

What is the correct code syntax to insert Row of Data.

How do we remove the syntax errors (i.e., '>' expected, and 'declaration expected')?

What is the correct code?

Read example, below:

[Code]....

View 16 Replies

Forms Data Controls :: Interrogate The RBL And Set The Label So The Correct Value Is Passed Back To The Datasource?

Mar 1, 2011

I have a Gridview with a templated column that gets a True/False value from the SQL Datasource. The value displays as a string in a label in the template. I added a RadioButtonList and in the RowDataBinding event put in some logic to set the appropriate radio button based on the text value of the Label.

Now I want to be able to interrogate the RBL upon update and set the Label text accordingly. I tried the Row_Updating event but that doesn't have a handle on the row itself and the RBL is not in the NewValues or OldValues collection since it's not one of the bound fields. I tried the RBL_SelectedIndexChanged event but I can't get the current row (got a handle on the Gridview but Gridview.SelectRow and Gridview.SelectedDataKey are both null).

how to interrogate the RBL and set the Label so the correct value is passed back to the datasource for update?

View 2 Replies

DataSource Controls :: Way To Retrieve Data From A Table, Modify And Insert It Into Another Table

Jun 13, 2010

Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token

ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...

View 2 Replies

DataSource Controls :: Can Transfer Data From A Table To Another Table

May 15, 2010

May you tell me how can I transfer data from a table to another table, the condition of non-repetition rows

as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only

View 4 Replies

Data Controls :: GridView Calculation With OnChange

Oct 9, 2012

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...

View 1 Replies

Data Controls :: Age Calculation Based On Date Of Birth

Apr 27, 2016

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 Replies

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

View 1 Replies

Forms Data Controls :: Decimal Place Missing After Calculation

May 11, 2010

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:

<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?

View 4 Replies

Forms Data Controls :: Footer Calculation Of Template Field?

Dec 1, 2010

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)

View 5 Replies

Forms Data Controls :: Period Calculation From Dates For DetailsView?

Jan 16, 2010

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

View 9 Replies

Forms Data Controls :: Trying To Do A Calculation On GridView2 And Using Clientside Javascript?

Oct 10, 2010

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

View 5 Replies

Data Controls :: Export GridView With Calculation In Footer To Excel

Feb 11, 2014

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 Replies

DataSource Controls :: Unable To Get Correct Syntax?

Jul 7, 2010

I am just not able to get the syntax right for the below code,

Dim HeaderCount As Integer = readerXML.HeaderCount()
Dim NewTable As String
NewTable = "CREATE TABLE " + tbCustomerFileName.Text +
" (" +
" RowId smallint" +
" IDENTITY(1,1)" +
" PRIMARY KEY CLUSTERED,"
For I = 0 To [HeaderCount]
NewTable = NewTable + readerXML.Item(I) + " DEFAULT 'New Position - title not formalized yet'," + " varchar(50) NOT NULL,"
Next [I]
+ ")" ...this part gives me an error ssaying incorrect syntax.

I am trying to upload an excel file and based on the number of headers in the file, I want to generate columns, however I am just not able to get this going because i am getting syntax error, the main problem being I am not able to put the brackets at the right place.

View 2 Replies

DataSource Controls :: Use Char B/c That Is The Correct Datatype In SQL?

Mar 17, 2010

I'm using DAAB from MS Ent Library 4.1. I have this function in my DAL that returns a dataset.

[Code]....

However, it is failing with this error:Failed to convert parameter value from a String to a Boolean.
But if I use SqlDbType.VarChar instead it works fine. I want to use Char b/c that is the correct datatype in SQL.In my SP the param is @CUSTNMBR char(15). In my database table the field is also char(15).

View 3 Replies

Forms Data Controls :: Edited GridForm Can Reflect A Calculation Change?

Mar 11, 2010

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/

View 2 Replies

DataSource Controls :: Input String Was Not In A Correct Format?

Jan 10, 2011

I have the textbox input the double number like 0.5 or 2.1 then click the submit insert to database, but show the error. Server Error in '/' Application. Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

[Code]....

Source File: c:inetpubwwwrootInformationadd_detail_menu2.aspx.vb Line: 6 Stack Trace:

[Code]....

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

View 2 Replies

Data Controls :: Gridview Footer Total Calculation Not Working In Master Page

Nov 21, 2012

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);
});
}

View 1 Replies

DataSource Controls :: Error - Input String Was Not In A Correct Format

Jun 21, 2010

I am using a SQL stored procedure to insert client records into multiple tables.

this is my datasource markup:

[Code]....

I am using a multiview to step through the input pages then on the last view there is a submit button that fires this:

[Code]....

this is my stored procedure:

[Code]....

View 5 Replies

Forms Data Controls :: Gridview Row_databound Calculation Error - Input String In Wrong Format?

Dec 7, 2010

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?

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved