declare @FinallyGrandTotal float
declare @total float
set @total = 45.3699
set @FinallyGrandTotal = @total
in the above code ther is a total price 45.3699
I want add to FinallyGrandTotal this but with just 2 letters after the dot
that mean @FinallyGrandTotal = 45.3699
45.36 and not 45.3699
here is my query which is not working properly. I have 5 fields in my table Company, Reseller, Item, Code, Price. How can i get minimum Price when i pass parameters for Code is dublication value
Company Reseller Item Code Price
A A-1 I1 C1 20
B A-21 I2 C2 13
C A-B I1 C1 19
select Company,Reseller,Item,Code,Min(Price) from Table1 where code='C1' order by Code HOW CAN I GET THIS BELOW TYPE OF RESULT
Company Reseller Item Code Price
A A-1 I1 C1 20
C A-B I1 C1 19
I am trying to get the modalPopup to work. Don't get any errors, the panel popsup as is supposed to, but the background doesn't gray out and the background of the panel doesn't display correctly either (it is black). The background of the main page doesn't change. To make sure I wasn't doing something wrong, I downloaded the samplcode (vb) from the AJAX website, and created a completely new web page, css file, .vb file, etc. Still have the same issue. I am using the latest version of ajaxcontroltookit ( 4.1.40412.0), VS 2010 RC, and VB)
View 8 RepliesI think this is a little tricky problem, but I need to solve it somehow. I have a texbox in my asp.net page. I want to show all names when a user types in a letter in that textbox, whatever names starting with that letter. the names are from a list generated by other function, pulled out from active directory. So for example: User types in "a" in a textbox then automactically names "aron" "asron" "amanda" in the list shows, and user can select one of those names.
View 4 RepliesI want to maintain the consistency of my database, I want the first letter and every letter after a space to be capitalized before the record can be entered into the database. Currently my validator expression (^[A-Z]+[a-zA-Z]*[0-9]*[^f
v]*$) can achieve only the first capital letter and it can't check on the letter after every space, so what is the expression to achieve that?
I'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 RepliesHeres the situation: I need update a column from my table (T1) from two other columns in a different table (T2).
My constraints are:
That I have to match the first 4 letters of a column in T2 to one column in T1 I have to identify that the first letter in a column in T1 corresponds to one letter in the middle of a string in a column in T2 For instance:
My Table (T1):
Order Type Combined
Place
0090 0001 YYXX 1YY
0091 1001 YYXX YYY
0092 1002 XXXX 2XX
Table 2 (T2):
Order Value
00900001YY XX
00911001YY XX
00921002XX XX
The Combined column in T1 is what i'm trying to complete. The T1.Place column contains the first character that I want to check for.
If it's a "1" then I want to make sure the 5th letter in T2.Order is a "0" If its a "Y" then I want to look for a "1001" If its a "2" then I want to make sure the 8th letter is a "2" in T2.Order
If all that matches then I was the last two letters in T2.Order + T2.Value to be combined and put into the appropiate spot in T1.Combined
Here's what I have:
[Code]....
I know it's a little complex, but i'm really stuck on it and any help would be greatly appreciated.
In asp.net,When I type letter in textbox, textbox doesn't show this letter and save in variable and when i type digit in textbox, textbox shows this digit and store in another variable. How should i do?
View 4 RepliesI want you to help me to use a cod that convert number to letter .
For example :
2000 $ : Two
Thousand dollars
I have done this using templates but now I was wondering if its possible to use DataFormatString property of gridview's asp:boundfield to capitalize the first letter of the string
<aspBoundField HeaderText="Brand" DataField="brand" DataFormatString = "(?????)"/>
am using asp.net 2.0 + c# .i want search like if we click letter A, all the entries starting with A should list on a grid ,like that for B ,C upto Z.how can i do it.Is there any control for displaying all 26 lettersor should i give hyperlink or link.
View 1 RepliesI 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?
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]....
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#.
i 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 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]....
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.
Im new to ASP.net.Im currently developingecommerce website which is a wholesale website. According to requirements user can see the price only after log in to website.Eg:http://www.simplywholesale.co.uk /offer.116009.shtmlto develop this with with ASP.net
View 3 Repliesin asp.net c#. I have a DetailsView with a TextBox and I want the input data be saved always with the FIRST LETTER IN CAPITAL. Example:
"red" --> "Red"
"red house" --> " Red house"
i want to take a string and check the first character for being a letter, upper or lower doesn't matter, but it shouldn't be special, a space, a line break, anything
View 3 RepliesI browsed through [URL] but could not find a regular expression that only checks if the first letter is a capital A. Am I on the right track with something like: ^([A])+/
View 7 Replies
