I have a table that includes a state column and a price column.
I am able to obtain the average price from a particular state using:
SELECT avg(Price)
FROM MainTable
WHERE StateId=x
I would like to display the average price from each state. The only way I know of doing this is 50 seperate datasource controls. Is there another way?
I have a gridview, I am binding the gridview with a datatable and in the gridView, my autogenerateColumn is set to true since I am generating the columns dynamically coming from database. I am also doing doing showFooter =true. There are values in the rows of these dynamically generated columns. I need to calculate the average of each of these columns and display it in the footer. so for e.g, I have
A B C
10 11 12
13 14 15
16 12 11
-- -- --
13 12.3 12.6
I am having some issues with the performance. I am binding a Gridview with around 200 records and it is taking a long time. At one time I only display 10 records on the page, but I bind all the 200 records.
Generally what is the number of records that should be bound to a gridview ?
I have a small table that has ratings for a album let's say.
Instead of showing the rating from 1-4 I want to show start instead
Rating 1 the 1 star
Rating 3 3 stars
Rating 0 no star
etc.
I have an tiny int field in the table and I will make a drop down list to allow 0-4
Currently I have a list view to show the list of comments and ratings but not sure how to convert the 0-4 from tiny int to a the same amount of stars
I have created a student webpage with many tables like student info,test1 marks,test 2 marks and so on now i have to generate a report for each and every student with their details and average marks in each subject
View 4 RepliesI'm building an application, my client wants me to create new control using AJAX. This control should look like thisThis control includes price(dolars and cents) and when user clicks on specific price(suppose 95 dolars and 33 cents) this price should jump inside to textboxs(one for dolars and one for cents)Does anybody have a clue how to implement this control creation??
View 4 Repliesi want to use a Datalist to list products from sqldatasource. When i select the Product i would like to retrieve the associate Product value in the code behind page so that i may use it to display data in Grid.
View 8 RepliesI have a gridview with the following columns: months, number of injury, expenses. my month column is a string, my number of injury column is a number and my expenses column is a number. I need to first obtain the month column as an integer and then obtain the number of injury column in my gridview. Once these columns are obtained, I want to be able to get the total number of injuries. How do I solve the problem. First obtain the month column and change it to an interger or gridview
Next obtain the injury column and then add each row in the injury column to get the total number of injuries.
Currently I am developing an ecommerce web site where
1. I choose the Product from a GridView (by pressing Select)
2. This product gets added to a DataView
The problem arises because I have a quantity textbox and wish to multiply the price by the quantity textbox.
How can I extract the price from the gridview to multiply it ? (and then subsequently display it in a label)
[Code]....
[Code]....
[Code]....
How to obtain additional information in label1? Data ID and last name, it works. How to obtain additional information ID2 in DropDownList?
I am able to sum an entire column and put the total in a column, but what if i want to get the average of all the numbers in the column?
[code]....
i need to calculate the total price in a column in a gridview1. How do i do so?
My column in the gridview is like this, it is at cell 5
Price
$1.00
$3.50
$4.00
I'm using VB btw, i dont understand C#.
First of all, when using the GridView control with Delete enabled, when I delete a record is the event handler in the code behind file handled before the record is deleted or after? I need to obtain a counter value that I have set up in the record before it is deleted so that I can decrement all of the counter values that followed it. Is the best way to do this to open a connection in the Delete even handler and take care of it by code, or is there another way to access a column value from the GridView control that would simplify the process?
View 2 Repliesi have a girdview
RefNo
ProductID
ProductName
ProductType
Quantity
Price
000000000000249
FT10
0
ItemA
M
1
92.00
000000000000249
FT23
0
ItemB
M
1
355.00
i want count total the price in a label,
[Code]....
my web Form contain Gridview : when i click the button woth ID="IncreaseButton" , i have problem is : The Initial price = 334,7 now When i click button to Increase the price with 1.5 , i got this value :
3347000,0000 wich incorrect
this is the code
<asp:GridView id="ProductsGridView"
DataSourceID="ProductsDataSource"
DataKeyNames="ProductID"
AllowPaging="True"
SelectedRowStyle-CssClass="selectedRow"
CssClass="gridView"
OnRowCommand="ProductsGridView_RowCommand"
AutoGenerateColumns="False"
runat="server">
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Productid" HeaderText="Product ID" />
<asp:BoundField DataField="Name" HeaderText="Product Name" />
<asp:BoundField DataField="ProductNumber" HeaderText="Product Number" />
<asp:TemplateField HeaderText="Price">
<ItemTemplate>
<asp:Label ID="PriceLabel" runat="server"
Text='<%# Bind("ListPrice") %>'>
</asp:Label>
<asp:Label ID="Label2" runat="server"
Text='<%# Bind("ListPrice") %>' Visible="true" >
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Button runat="server" ID="IncreaseButton"
Text="Increase Price 5%"
CommandName="Increase"
CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />
In my webpage i am trying to create a order by gridview here item selected by user from dropdown and on selction of dropdown price display in next to item dropdown label price.now user insert quantity from next grid textbox and next is label amount shold disply calculate amount on price and quantity.i also want to use javascript for this prob.what i did that item and price displaying and user make input from textbox now want to calculation but how textbox recieve input and amount label dispaly calculate amount.
[Code]....
I have a gridView that shows the transaction_line table including "tL_id, t_id, date, pro_id, quantity, price, total price = quantity*price. How can I get a total transaction_line price for this gridView for each transaction_line id ??
View 3 RepliesI have a Data Grid View which display values from a SQL Query, and inside the data grid view I have two template fields one is Quantity and it is a text box and the other is Total Price and it is a label.
What I want to do is to insert a button called update and when I press this button the price Column should be multiplied by the quantity Column and the result should be displayed in the total Column.
I have gridview and button and radiobutton in page below are codes...
<input type="radio" name="n" id="RBmkvM" runat="server"/>
<input type="radio" name="n" id="RBdvdM" runat="server"/>
<asp:ImageButton ID="ImageButton1" runat="server" CssClass="imgored" ImageUrl="~/Image/Main/png1.png" OnClick="Imgorder_Click"></asp:ImageButton>
[Code]....
how can we find avg in matrix row wise? that is i want find the average of data at the end of a row.
View 1 Replieshow to calculate 3 days average
View 4 RepliesI want to use jquery price range slider use my website but not fire in onchange event .
just like [URL]
I want to calculate average time to cover a duration of a route.
A route can have multiple trip between different time slots.
trip have TripStartTime and TripEndTime.
For more clear of the Qns for Qns please go to this URL and for table structure please go to this Url.
Trip Time = TripEndTime - TripStartTime from columnin the table.
I have to calculate Actual trips time for different time slots group by Fleet Id which is related to route no in another table..
I have dynamically generated paragraphs with id's that are incremented. I would like to take information from that page and bring it to my main page. Unfortunately I am unable to read the dynamically generated paragraph IDs to get the values. I am trying this:
var Name = ((data).find("#Name" + id).text());
The ASP.NET code goes like this:
Dim intI As Integer = 0
For Each Item As cItem in alProducts1
Dim pName As New System.Web.UI.HtmlControls.HtmlGenericControl("p")
pName.id = "Name" & intI.toString() pName.InnerText = Item.Name controls.Add(pName) intI += 1
Next
Those name values are the values I want...Name1, name2, name3 and I want to get them individually to put in their own textbox... I'm taking the values from the ASP.NET webpage and putting them into an AJAX page.