Feb 14 2006

Build a Data Access Layer in less than 15 minutes with CodeSmith

Category:Bil@l @ 17:08

Erick Smith, the founder of CodeSmith, posted a great article on how to create a Data Access Layer in a very quick time.

You can check the article at: Build a Data Access Layer in less than 15 minutes

Hope that helps you,

Regards

Tags:

Feb 12 2006

DataList Show/Hide Table Rows

Category: ASP.NET 1.x | ASP.NET 2.0 - GeneralBil@l @ 00:31

In the last few days, I was working on a Custom DotNetNuke Module, which is called ContactUs, which I will be using in one of the projects currently under my hands.

I wanted to list all entries of the ContactUs form that are stored in the database. So I decided to use the DataList, in which I place my own Table inside the ItemTemplate.

There are some fields in the ContactUs form that might be empty or null. So I didn't want to show the ROW inside the table for each NULL field in the database.

Here how I did it:

<asp:datalist id="dlstContactUs" runat="server" cellpadding="4" datakeyfield="itemId">
    <ItemTemplate>
        <table cellSpacing="0" cellPadding="2" border="0">
            <tr vAlign="top" runat="server" id="trCompany" Visible='<%# IsNull(DataBinder.Eval(Container.DataItem,"Company")) %>'>
               </tr>
        </table>
    </ItemTemplate>
</asp:datalist>

Watch the DarkGreen areas above.

In the code-behind, this is the IsNull method that I am using:

public bool IsNull(object item)
{
    if ((item.ToString() != null) && (item.ToString() != String.Empty))
    {
        return true;
    }
        return false;
}

Hope that helps,

Regards

Tags: ,

Feb 11 2006

CountryList SQL Script

I am working on a Custom DotNetNuke module. I wanted to have a DropDownList of all the countries in the world.

I had to google a little bit to find all the countries available, which I beleive are 222 countries.

I wanted to share with you the SQL Script I created.

You can download this script from the Files Area.

When you run this script using the Sql Query Analyzer, it will create the following:

  • regionList table
  • countryList table
  • Insert 222 countries into the countryList table categorized by regions located at regionList table.

I am sure you will need this script in your work some time.

If there is still any country not listed, please let me know so that I update the script

For DNN Custom Modules' developers, I found later on that there is a dll in the bind folder of the DNN installation called CountryListBox, don't know what it is, but I guess it is related to country list or so.

Hope this helps,

Regards

 

Tags: , ,

Feb 9 2006

Popup Window inside Code-Behind

Category: ASP.NET 1.xBil@l @ 14:14

Opening a pop up windows from code-behind has been the topic of many many questions on the ASP.NET forums. I once created a control in two versions for ASP.NET 1.1 and 2.0, that helps developers by calling a simple method, providing it with some paramters, and here you go, opening a popup windows very easily, no javascript no nothing, just simple VB.NET/C# function calls.

I had that control on my previous website, as a free downloadable control, I decided today to place it again on this blog, since there are still many developers on the ASP.NET forums, asking on how to do so.

Visit the Files Area on my blog and download the control and use it for free.

Enjoy Popupping !! :)

Regards

 

Tags:

Feb 8 2006

Access Selected GridViewRow in GridView

Category: ASP.NET 2.0 - GeneralBil@l @ 08:10

Hello:

I was working last night around 3:00 AM, and I found out that in my GridView Column's list, I have added a TemplateField of type LinkButton with CommandName=”EditRec”, in such a way, when the Edit link button is clicked, I want to access the selected GridViewRow, then populate a web form on the same page, and without having to show the “Update” and “Cancel” buttons on the GridView.

I did that, but the problem was now how to access the GridViewRow in the RowCommand method?

I used the “SelectedRow” property but I kept having “Object Reference not ....” I didn't know in fact.

I tried to use GridView1.Rows[e.CommandArgument], but the DataKey I set for the GridView was of type String, so cannot use that either.

I finally was able to use the following and it works fine for me:

if (e.CommandName.Equals("EditRec"))
  {
            string MediaIndex = e.CommandArgument.ToString();

            // Get the last name of the selected author from the appropriate
            // cell in the GridView control.
            GridViewRow selectedRow = (GridViewRow)(((Control)e.CommandSource).NamingContainer);

            string _mediaType   = selectedRow.Cells[0].Text;
            string _CheckOut    = selectedRow.Cells[1].Text;
}

                

The way the code works if as follows:

e.CommandSource -> LinkButton
((Control)e.CommandSource).NamingContainer -> GridViewRow

Then, simply use the Cells property inside the GridViewRow to access all cells.

Hope that Helps,

Regards

Tags:

Feb 8 2006

Good Links to Share

Category: ASP.NET 1.x | ASP.NET 2.0 - GeneralBil@l @ 08:01

I would like to share with you the following two links, which I beleive are good and useful.

Regards

 

Tags: ,

Feb 8 2006

URL Mapper in ASP.NET 2.0

Category:Bil@l @ 07:54

Url Rewriting with Regex for ASP.NET 2.0

A new feature in ASP.NET 2.0 is it's built-in url rewriting support. When i looked into this new feature i found out it lacked regular expressions support, wich is really the point of an Url Mapper. ScottGlu at his blog, explains the reason why the ASP.NET team didn't implemented this feature. Basically they realized that a full featured version would want to take advantage of the next IIS 7.0 new features, specially the support for all content-types (images and directories).

Anyway, it's really simple to implement a Url Rewriting Module with Regex support in ASP.NET. I wrote a quick and simple HttpModule for this. The whole magic is done within a few lines within the HttpModule:

 1 public void Rewrite_BeginRequest(object sender, System.EventArgs args) { 
 2      string strPath = HttpContext.Current.Request.Url.AbsolutePath; 
 3      UrlRedirection oPR = new UrlRedirection(); 
 4      string strURL = strPath; 
 5      string strRewrite = oPR.GetMatchingRewrite(strPath);
 6       if (!String.IsNullOrEmpty(strRewrite)) { 
 7           strURL = strRewrite; 
 8      } else { 
 9           strURL = strPath; 
10      } 
11      HttpContext.Current.RewritePath("~" + strURL);
12 }

The code is self explanatory. When a request that is processed by the ASP.NET engine, the module checks an XML for a regex match. I've seen many Url Rewriting engines that uses Web.config to store the matching rules but i prefer using an additional XML file. The rewriting rules file look like the following:

 1 <?xml version="1.0" encoding="utf-8" standalone="yes"?>
 2 <urlrewrites>
 3      <rule name="Category Page">
 4           <url>/([a-zA-Z][\w-]{1,149})\.aspx</url>
 5           <rewrite>/Default.aspx?Category=$1</rewrite>
 6      </rule>
 7      <rule name="Item Page">
 8           <url>/([a-zA-Z][\w-]{1,149})/([a-zA-Z][\w-]{1,149})\.aspx</url>
 9           <rewrite>/Default.aspx?Category=$1&amp;Item=$2</rewrite>
10      </rule>
11 </urlrewrites>

The rule matching routine, wich is implemented in the GetMatchingRewrite() method is quite simple and lightweighted:

 1 public string GetMatchingRewrite(string URL)  {
 2      string strRtrn = "";
 3 
 4      System.Text.RegularExpressions.Regex oReg;
 5 
 6      foreach (RedirectRule oRule in Rules) {
 7 
 8           Reg = new Regex(oRule.URL);
 9           Match oMatch = oReg.Match(URL);
10 
11           if (oMatch.Success)  {
12                strRtrn = oReg.Replace(URL, oRule.Rewrite);
13           }
14 
15      }
16      return strRtrn;
17 }

I have uploaded a sample project that uses this rewriting engine. The HttpModule and it's helper classes are inside the App_Code folder. I hope you find this code useful, if you have any questions just leave a comment in this entry. Happy coding!

Tags:

Feb 8 2006

String Formatting in C#

Category:Bil@l @ 07:45

String Formatting in C#

I couldn’t find a quick reference to .NET string formatting using the String.Format() function, so I created this one.

When I started working with the .NET framework, one thing puzzled me. I couldn’t find sprintf(). sprintf() is the C function that takes an output buffer, a format string, and any number of arguments, and builds a string for you. For example:

char szError[256];
sprintf(szError, “Error %d occurred.\n”, nError);

This would write “Error 12 occurred.” into the szError buffer (assuming nError was 12). It’s a basic part of C programming and most C++ programmers still use it though better functionality is available in the STL because sprintf is simple to use and clear. The STL equivalent would be:

str << “Error ” << nError << ” occurred.” << endl;

Or something close to that. It’s type-safe, and more OO than sprintf, but not as easy to read and not as easy to localize.

The .NET framework handles strings very nicely - but it takes some getting used to. The rough equivalent of sprintf in .NET is the static String.Format function, which takes a format string and some arguments, and generates an output string. (This is a nice improvement over sprintf since there’s no chance you’ll overflow the output buffer). For example:

string errorString = String.Format(”Error {0} occurred.”, nError);

Teeming with metadata, the .NET environment doesn’t need the format string to say what type of data you’re formatting, just where you want it. (A common sprintf bug is supplying the wrong data type - there’s no protection from using %s instead of %d and having your program crash when sprintf is called).

The {0} in the string above is replaced with the value of nError, but what if you want to specify the number of digits to use? Or the base (hexadecimal etc)? The framework supports all this, but where it seemed confusing is that it’s not the String.Format function that does the string formatting, but rather the types themselves.

Every object has a method called ToString that returns a string representation of the object. The ToString method can accept a string parameter, which tells the object how to format itself - in the String.Format call, the formatting string is passed after the position, for example, “{0:##}”

The text inside the curly braces is {index[,alignment][:formatString]}. If alignment is positive, the text is right-aligned in a field the given number of spaces; if it’s negative, it’s left-aligned.

Strings

There really isn’t any formatting within a strong, beyond it’s alignment. Alignment works for any argument being printed in a String.Format call.

Sample Generates
String.Format(”->{1,10}<-”, “Hello”); -> Hello<-
String.Format(”->{1,-10}<-”, “Hello”); ->Hello <-

Numbers

Basic number formatting specifiers:

Specifier Type Format Output (Passed Double 1.42) Output (Passed Int -12400)
c Currency {0:c} $1.42 -$12,400
d Decimal (Whole number) {0:d} System.FormatException -12400
e Scientific {0:e} 1.420000e+000 -1.240000e+004
f Fixed point {0:f} 1.42 -12400.00
g General {0:g} 1.42 -12400
n Number with commas for thousands {0:n} 1.42 -12,400
r Round trippable {0:r} 1.42 System.FormatException
x Hexadecimal {0:x4} System.FormatException cf90

Custom number formatting:

Specifier Type Example Output (Passed Double 1500.42) Note
0 Zero placeholder {0:00.0000} 1500.4200 Pads with zeroes.
# Digit placeholder {0:(#).##} (1500).42
. Decimal point {0:0.0} 1500.4
, Thousand separator {0:0,0} 1,500 Must be between two zeroes.
,. Number scaling {0:0,.} 2 Comma adjacent to Period scales by 1000.
% Percent {0:0%} 150042% Multiplies by 100, adds % sign.
e Exponent placeholder {0:00e+0} 15e+2 Many exponent formats available.
; Group separator see below

The group separator is especially useful for formatting currency values which require that negative values be enclosed in parentheses. This currency formatting example at the bottom of this document makes it obvious:

Dates

Note that date formatting is especially dependant on the system’s regional settings; the example strings here are from my local locale.

Specifier Type Example (Passed System.DateTime.Now)
d Short date 10/12/2002
D Long date December 10, 2002
t Short time 10:11 PM
T Long time 10:11:29 PM
f Full date & time December 10, 2002 10:11 PM
F Full date & time (long) December 10, 2002 10:11:29 PM
g Default date & time 10/12/2002 10:11 PM
G Default date & time (long) 10/12/2002 10:11:29 PM
M Month day pattern December 10
r RFC1123 date string Tue, 10 Dec 2002 22:11:29 GMT
s Sortable date string 2002-12-10T22:11:29
u Universal sortable, local time 2002-12-10 22:13:50Z
U Universal sortable, GMT December 11, 2002 3:13:50 AM
Y Year month pattern December, 2002

The ‘U’ specifier seems broken; that string certainly isn’t sortable.

Custom date formatting:

Specifier Type Example Example Output
dd Day {0:dd} 10
ddd Day name {0:ddd} Tue
dddd Full day name {0:dddd} Tuesday
f, ff, … Second fractions {0:fff} 932
gg, … Era {0:gg} A.D.
hh 2 digit hour {0:hh} 10
HH 2 digit hour, 24hr format {0:HH} 22
mm Minute 00-59 {0:mm} 38
MM Month 01-12 {0:MM} 12
MMM Month abbreviation {0:MMM} Dec
MMMM Full month name {0:MMMM} December
ss Seconds 00-59 {0:ss} 46
tt AM or PM {0:tt} PM
yy Year, 2 digits {0:yy} 02
yyyy Year {0:yyyy} 2002
zz Timezone offset, 2 digits {0:zz} -05
zzz Full timezone offset {0:zzz} -05:00
: Separator {0:hh:mm:ss} 10:43:20
/ Separator {0:dd/MM/yyyy} 10/12/2002

Enumerations

Specifier Type
g Default (Flag names if available, otherwise decimal)
f Flags always
d Integer always
x Eight digit hex.

Some Useful Examples

String.Format(”{0:$#,##0.00;($#,##0.00);Zero}”, value);

This will output “$1,240.00? if passed 1243.50. It will output the same format but in parentheses if the number is negative, and will output the string “Zero” if the number is zero.

String.Format(”{0:(###) ###-####}”, 8005551212);

This will output “(800) 555-1212?.

If you have any questions about string formatting, or pretty much anything related, drop by the Forum and ask it there. It’s an easier place to talk than in the comments section here.

14 Responses to “String Formatting in C#”

  1. stevex » Blog Archive » Different Theme Says:

    […] In case anyone reads this on the main page instead of in an aggregator.. I’m trying out a different theme. It’s wider, so code snippets don’t wrap. I wanted to make my String Formatting in C# page look good since searching for how to do sprintf type formatting in C# is how most people find this site. […]

  2. pwalls Says:

    Great resource! This is definitely a handy reference page I’ve added to my favorites. However, I did notice a minor error.

    The following:

    String.Format(”{0:(###) ###-####}”, 18005551212);

    Produces (1800) 555-1212 and not (800) 555-1212.

    Otherwise, great information.

  3. Tim Lewis Says:

    This will output “$1,240.00? if passed 1243.50. It will output the same format but in parentheses if the number is negative, and will output the string “Zero” if the number is zero.

    Correction:
    String.Format(”{0:$#,##0.00;($#,##0.00);Zero}”, 1243.50); // Outputs “$1,243.50? not the claimed “$1,240.00?

  4. Max Says:

    I want format String

    string.format(”00-0000?),myhouse);

    my-house?

  5. murugan.g Says:

    Hi Steve,

    Thanks for this wonderful article.

    How can i format date like this “December 08th, 2005?.

  6. Jorge de Cardenas Says:

    Someone asked if 0,1 could be formatted to no,yes on your other page
    http://www.stevex.org/CS/blogs/dottext/articles/158.aspx

    this can be done with formatting using:

    String.Format(”{0:yes;;no}”, value)

    => yes if value == 1
    => no if value == 0

  7. Jeremy Says:

    Was this article ripped off from here:

    http://idunno.org/displayBlog.aspx/2004071401

    ?

    I ask because they are almost identical.

  8. stevex Says:

    Nope.. it looks like they’re just surprisingly coincidentally similar. My original article was posted in 2003, over here:

    http://www.stevex.org/CS/blogs/dottext/articles/158.aspx

    His was posted 2004.

  9. Krise Says:

    Nice howto,
    there is a small error in it though:

    the following :

    Sample Generates
    String.Format(”->{1,10} Hello{1,-10}Hello

  10. Broads Says:

    Steve,

    I have found this blog very usefull but was wondering if you may shed some light on the following.
    I have a shopping basket on my site which should display my total as GBP £x.xx however when using the string.format {0:c} the currency of the hosting server is used. So when I developed and tested my site all looked fine. When I then hosted my site it took, i presume, the localisation of the hosts server and displayed as $x.xx

    To get around this I am now using string.format{0:#.##} which is then prefixed with a physical £ sign.

    Is this the correct way to get over this formating issue or is there a better way.

    Thanks

  11. Philippe Quesnel Says:

    great info ! at last, I always swear at the .NET doc when looking form string formatting info ;-)

    note: the 1st example, right at the top of the article:
    String.Format(”->{1,10} Hello{1,-10}Hello

  12. Philippe Quesnel Says:

    oops, sorry, don’t know what happened to my text in the 1st post !! ??

    here it is again, hopefully complete this time !

    great info ! at last, I always swear at the .NET doc when looking form string formatting info ;-)

    note: the 1st example, right at the top of the article:
    String.Format(”->{1,10} Hello{1,-10}Hello
    String.Format(”->{1,-10}Hello

  13. tom callaghan Says:

    I know there is a way to do this, I just cannot remember the format string. I want to force a sign place holder so that either ‘+’ for positive numbers or ‘-’ for negative numbers will print. For example

    34.2 outputs as +34.2 and -34.2 outputs as -34.2

  14. ddegenaro Says:

    if i have converted from like “1110.20? to “$1,110.20? using {0:C}
    how do i convert “$1,110.20? back to “1110.20?..i tried {0:f} and {0:0.00}
    still doesnt work!

Tags:

Feb 3 2006

Windows WorkFlow

Category:Bil@l @ 20:49

Yesterday the LebDev.NET user group in Lebanon offered a great session about

Working with Windows WorkFlow.

As part of the Community Nights, sponsored by Microsoft Beirut Office and held by the LebDev.NET user group.

For more information on Windows WorkFlow, make sure to check the links below:

http://msdn.microsoft.com/windowsvista/building/workflow/default.aspx

http://www.windowsworkflow.net

 

Regards

 

Tags: