.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Decimal Point

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

How do i format the field so i just get 2 decimal point, this is how it is shown on the report currently


I want the table to look like this...




View Complete Post

More Related Resource Links

MaskedEditExtender forcing user to enter decimal point...


I have a MaskedEditExtender set for a TextBox that will receive a fee amount. I want the user to be able to type the "." decimal when the amount contains a decimal value (123.45). But if the amount has not decimals (123) I want the mask to automatically fill the 2 decimal with zeroes and also enter the "." decimal point (123.00).

With the following mask I'm able to enter a full number (999) and get the zeroes but when user enters 85.85 it will be 850.85 so I change the direction RightToLeft but I'm not even able to type the first character.

<cc1:MaskedEditExtender ID="txtFee1ME" runat="server" PromptCharacter=" " Mask="999.99" 
                    Enabled="True" TargetControlID="txtFee1" MaskType="Number">


Precision and scale from flat file with no decimal point


I can't figure out if "precision" and "scale" in flat files connection manager can give me an implied decimal. 

Say each record is an amount and a name:



The numbers represent 1.01 and 1.02

I would hope I could put in the flat file something to say the Scale is 2 and Precision is 5, and down-pipeline tasks would see 1.01 and 1.02.  I've tried dt_numeric and dt_decimal data types in my flat file connection manager advanced properties and tried setting DataScale to 2 and (in numeric, no such option in decimal) setting DataPrecision to 5, but the numbers just come out as 101 and 102 when I write them into an ODBC database. 


Would you expect this to work (I'm doing the right thing wrong) or is there something similar (I'm doing the wrong thing)?

In fact what I have is dozen of currency fields and percentages with no decimal points - old Cobol style data we get from competitors who won't change the format.  I realize that I could transform the field(s) but then that has to be done for each dataflow that uses the connection manager.


How do I print just the numbers after the point from a decimal value?


decimal 123,45m;

I'd like to print  "45"

Thank you.

learn basic about share point.

This learn basic about share point.

how to set break point at inline code

I set the element height value by using inline code 
<%# Eval("s") %>
where "s" is the variable declared in page load event. when i run the application it don't set the height. 
Is there any way, i can set break point into .aspx file. i mean how i can check if my Eval("s") get the value.  

decimal value validation and round off by javascript

The article decimal value validation and round off by javascript was added by hiral.hapani on Wednesday, June 02, 2010.

Hi All, I have createdone javascript by which you canvalidate a decimal value of any textbox for which you want. By thisjavascriptwecan bind user to enter only digits in textbox. and when he will enter any decimal value javascript will do round off it

Which one is better: Money or Decimal?



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

Please tell me which one is better to work with in sql and VS.net (handling sql in VS)

Best Regards. Morteza

Primary Key In Share Point 2007/ 2010


Can I create 3 columns Primary key in a list using the MOSS 2010 or 2007

Actually My requirement  is

I collect some information by Country,State,Dist wise Temperature


1.  India-Andraprades-Hyderabad-Temp-30

2.  India-Andraprades-KarimNagar-Temp-30

here first 2 column is Same but 3rd column is different that's I required 3 column is Primary Key


Any one help me.



How to work around Share point accessibility requirement ?



I am somewhat new to things related to accessibility in SharePoint. I am trying to work on section 508 accessibility requirements for SharePoint site. I have tried to see few articles from the internet and still looking for more information on the subject matter including what to consider fro preparing requirement.  

I am looking to know what is possible and what is not with SharePoint?

How to achieve all the possible accessibilities in SharePoint?

Is it possible to make accessible all site types (Publishing, team sites,.)?

Please help me in understanding everything around SharePoint accessibility and first in preparing the requirement document. I have tried to see AKS site but there were some issues that are not clear for me at this level.

Thank you in advance,


Is MSDN uses Share point?



Is MSDN uses Share point?


Not able to edit user profile in share point


Hi ,

I am new to share point, and not able to edit user profile data in sharepoint2007. I am getting an error "can't edit the property try with user profile services".

I have ran full crawl still getting the same problem. Also let me know how I can fetch data from Active Directory to share point 2007.



How to create WSP or Package for workflow in Share Point 2007?



I am working on SharePoint 2007. I have created 2 List called "Config List" (this is a list) and "Vacation Form" (this is form library & form designed in infopath). I have also created a workflow on form library "Vacation Form" in Share Point Designer 2007.

With the use of this workflow I am creating some task and updating "Vacation Form".

Now I want to deploy these three thing (Config List, Vacation Form & workflow) on other server.

How do I create a package or WSP file to install these things on different server.


G. Goyal

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

Point of sale


Hello all!!

I'm Requiered to build a web app thats almost like a point of sale, but web based. Thats cool, but i'm stucked with the part where you select items and put them in some sort of shopping cart, all in the same page. What components would you guys use to do something like this.

Thanks in advance!

Share point website connection with Certral administration


Here is the situation , although I have SBS server 2008 I posted this same problem there , but I want here also to ask.

I followed link http://technet.microsoft.com/en-us/library/dd548330(WS.10).aspx and here are the  results.

In SBS console there is companyweb and it is marked as online. DNS also has entry for companyweb and nslookup works.  When I try to recreate internal website , which is described as 2nd step, my IIS server  is started, in IIS7 my website is running, but when I try to see in central administration if my site exist (web application list)  it isn't listed. So I tried to recreate it and I  followed directions from upper link in section repair user access to the internal website but when I want to delete web site , it is not listed. And after when I want to extend I cannot once again because it is not listed. Any suggestions and is there an

System.EntryPointNotFoundException: Entry point was not found. when unit testing html helpers


I'm trying to unit test a very simple html helper but keep getting the following exception:

System.EntryPointNotFoundException: Entry point was not found.

public static string AdditionalUsersDropDownList( this HtmlHelper helper, int additionalUsers )


Dictionary<int, string> items = new Dictionary<int, string>( );

items.Add( 0, "None" );

for ( int i = 1; i <= 30; i++ )


items.Add( i, i.ToString( ) );


SelectList list =  new SelectList( items, "Key", "Value", additionalUsers );

return helper.DropDownList( "AdditionalUsers", list );


Need RegEx for four decimal place

Hello All, I have total 19 digits in which i have 4 decimal place. What would be the pattern. ThanksBizTalk Beginner
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend