DataFormatString questions...

Michael Tanner · Nov 10, 2003

I have 2 formatting cases that I need to handle:

Case 1: an eight digit account number stored in database as such - 12345678
I need to display this in a boundcolumn as such - 1234-5678

Case 2: a number is stored in the database as such - 42
I need to display this in a boundcolumn as such - 0000042

Can I use the DataFormatString property to accomplish these 2 cases and how?

Thanks,
Mike

Aaron Weiker · Nov 14, 2003

Mike,
Here is a brief sample that you can put into an ASP.NET page and it will
demonstrate on how to do what you wanted. For more information look up
String.Format() in the MSDN library.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/htm
l/frlrfsystemstringclassformattopic2.asp



<%@ Page Language="C#" Debug="True" %>
<script runat="server">
private void Page_Load(object sender, EventArgs e) {
if (original.Text.Length > 0) {
result1.Text = String.Format("{0:000000##}", int.Parse(original.Text));
result2.Text = String.Format("{0:0000-0000}", int.Parse(original.Text));
}

}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:textbox id="original" runat="server" /> <br />
<asp:label id="result1" runat="server" /> <br />
<asp:label id="result2" runat="server" /> <br />
<asp:button id="transform" runat="server" text="transform" />
</form>
</body>
</html>


Aaron Weiker
http://aaronweiker.com/posts/174.aspx

DataFormatString	1	Nov 20, 2006
Born Again C.S. Guy Intro/Career Questions	3	May 2, 2023
Createa Custom DataFormatString in a GridView	1	Jan 29, 2009
DataFormatString on boundcolumn not working	1	Apr 15, 2004
Rounding floor in DataFormatString	0	Feb 26, 2008
BoundColumn - DataFormatString in a Multicutural Manner	0	Mar 31, 2005
DataFormatString Date	2	Oct 4, 2006
XDBMS?	0	Jul 1, 2022

DataFormatString questions...

Michael Tanner

Aaron Weiker

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads