i am working on a product based website in which i have a product table with product names and prices, i have defined the datatype of price as "Money"
but the problem is it shows price upto 4 decimals everytime, how i can limit that upto 2 decimals only, on the webpage as well as in the table also in database ?
i hav one data table in which some decimal values are up 6 decimal places.. im trying to bind that Data table to DataGridView while binding i want to round decimal values up to two decimal palces here is my code
dt.Columns.Add("Orderid", typeof(string));
dt.Columns.Add("tagnumber", typeof(string));
dt.Columns.Add("Minimum Value", typeof(string));
dt.Columns.Add("Maximum Value", typeof(string));
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
[code]...
hows hould i round up while binding..?
Some values are returning 2.0 but I need it to be 2.00 as this is a money value that is displayed to the web page.
I am doing:
Math.Round(value, 2);
Is there a way to force it to 2 numbers after the decimal?
I need a validation regex for decimal. It should allow upto 5 digits after decimal.
Allow:
1
1.0
12.0
12.01
123.01
1,123.01
1,123.013
21,123.01234
3,21,123.01234
How Can I do regex for this?
I want a field to keep money value (up to 100,000,000.00). And I didn't work with money or decimal data type. Money data Type is 8 byte Decimal (9, 2) is 5 byte. (Exactly msdn only say Decimal (9, 0) is 5 byte and I don't really know how byte is Decimal (9, 2)) which one is better to work with in sql and VS.net (handling sql in VS)
View 2 Repliesi have a double, the decimal place isn't fix (8-?) i want to fix the decimal place to six (for example: 1,234567). this is my double:
CStr(score)
i am store ms word resume to image(BLOB) data type in sql server 2005. now i want to display this resume in HTML page or in text area. and for that i use
[code]....
convert below datetime value which is as varchar datatype to another datetimeformat as varcharchar datatype
2010-05-19T13:05:08.6Z
I was read your post: "Export GridView to Excel in ASP.Net with Formatting using C#" and is very useful. That code works perfect. But I need create a new format for a specific column in my sheet before to export it. For example:My DataTable have a column with decimal numbers and I'm trying reduce the tenths for each number.I want this: 2,874444 ----> 2,87 for a specific range. In this case I need it for all numbers in the column 13 or well said for the Column called N in Excel. Only reduce two tenths.
I used:
xlWorkSheet.Range["N"+h,"N"+h].NumberFormat = "0.00";
And no works (h is for rows, N is the column. Into a foreach).
I'm trying to execute this statement every minute with SQL Agent, I have it set up as a job:
[Code]....
It's trying to update a column which data type is set to decimal. Just so you know what I really need out of it, here is an example:
[Code]....
The answer of which should add on 0.5 to the original value. If I were to use the increase value of 60 which then becomes 60/60 it will work.I'm dividing by 60 because the increase value is per hour so I make it smaller to get per minute value. Why is it doing this?
i have this validation for money value in textbox ^d+(.d{1,2})?$.Its working fine. for example if i enter 23.10 its fine.but if i give .10 it does not work.I want this to be worked if i dont put any ineteger before the decimal point like .20.
View 2 RepliesI have set Private Memory limit of 200mb in IIS 7 for an application pool. The Private Working Set memory(Task Manager) for the application is always below 125mb but the number of page faults have increased a lot and application cache is getting cleared frequently after setting the limit.
I haven't set any limit on Virtual Memory.why the cache is getting cleared even when the Private memory used is below the allocated memory?
i need textbox that is only entered money value. my code is below:
[Code]....
[Code]....
I have a requirement of sending 3000 Emails one by one with an attachment of around 100KB, I was using System.net.mail namespace with our company mail server.my program will send upto 360 mails after that it is not sending emails,and it is not giving any exception.what is the solution to my problem.
View 13 RepliesIam looking a solution for uploading files with ftp. i need a asp.net script in vb for uploading large files upto 1 gb with ftp.
View 3 RepliesI am creating an application where the user can upload files upto 100mb into the database and retrieve them later. I used the asp.net uploald control. Looks like it can upload only files of size 4MB.
View 3 RepliesUser will be entering % data in textbox. I am now using filter textbox extender to allow only numbers and .(ie decimal values). I also want the user to enter values from say 1 to 100 only.. How can i do this? If user wants to enter 0.5%?
View 1 RepliesI got a decimal member in my viewmodel and get populated from the database (say 55.5, or 100.00)
In my view I use TextBoxFor<> for this member.
Is there any way to have a number (it's actually a percentage) like 100.00 display as 100 instead, and 55.50 as 55.5?
I am using gridview for adding invoices dynamically.And I am set the column as auto generated column.How can i set alignment as right for money column.And how to i specify money value for that column.
View 4 RepliesI have develope web application with dropdown menu style. All pages loaded into iframe which is include in master page, Master page have dropdown menus (ui,li) and iframe, according to selection of link page will get loaded into iframe using javascript.Now i want to dispaly breadcrump upto current page. how can i handle same thing in asp.net with iframe. Example :
ABC : DEF : GHI ============Main Menu
abc ======== Child Menu
def -> jkl======= Sub Child Menu
mno
pqr
So when i am on page "mno" breadcrums like ABC > def > mno When user again mouse over on def same sub child menu will get appear as we have dispaly on header. My all pages get open in iframe.as i have call javascript for all page links to set src of iframe.
At the first loading of my page, duration of PreRender takes upto 13 seconds. That page has basically a gridview control which bind to SqlServer query by SqlDataSource. When I execute query seperately, it takes only 0.02 second.
On the other hand, for the next loadings of same page by postback, duration of PreRender varies from 0.5 second to 3-4 seconds.
In addition to gridview, there are several dropdownlist, update panel, ImageButton in gridview. I use paging for Gridview.
Which strategy should i follow to increase performance of this page?
I am trying to format money to be inserted to an sql statement. I currently have this
str = str + "'" + a.Trim + "', '" + b.Trim + "', '" + System.DateTime.Now + "', money, "
when i hard code money as 2.00, for example:
str = str + "'" + a.Trim + "', '" + b.Trim + "', '" + System.DateTime.Now + "', 2.00, "
it works fine, but when i am using a variable like dim money as double
money = dr("amount").ToString()
as with the 1st example i get the error message:
Input string was not in a correct format.
i want to format money in two formats
1) US dollors like this $126,765
2) is normal only seprate with comma when thousand occurs like this 126,765
I am using LINQ.I have stored procedure as:
ALTER PROCEDURE [dbo].[usp_ATI_OA_GetCalculatedValue]
@OredrID BIGINT = 0,
@SubTotal MONEY OUTPUT,
@ShippingTotal MONEY OUTPUT,
[code]...
The problem is that, how to return OUTPT value to dTtoal and the remaining. Because now it's show assigned values as 1, 2, 3, 4 resp. I mean the bold values.But, if I execute SP using EXEC then it works fine, shows result correctly.
Most of my DAL functions use structures to pass the data back to the BLL and to the UI. I have got the try catch code now and it all works fine. I capture the exceptions in a seperate db table and it all works fine.I wanted to know how to pass the error up and what varable would be used to hold the error statusWhat I was think was - if I had a BO structure that was used to in the DAL and was populated and I wanted the error state up do I need to have a specific error field in the structure.
View 2 Replies