The Chlankboot Journal http://www.chlankboot.com/blog let's chlank a little boot Sun, 22 Jan 2012 08:28:20 +0000 en hourly 1 http://wordpress.org/?v=3.3.1 chlankboothttp://feedburner.google.com I Love Rchouda http://feedproxy.google.com/~r/chlankboot/~3/TDQtOgJZzXk/i-love-rchouda http://www.chlankboot.com/blog/i-love-rchouda#comments Sun, 22 Jan 2012 08:27:26 +0000 chlankboot http://www.chlankboot.com/blog/?p=2241
  • Binary Wallpaper My GEEKS wallpaper !...
  • 2 Mois Avec Le Canon IXUS 85 IS Après avoir acheté cet appareil voilà 2 mois, j’ai décidé d'en partager mes trouvailles. Tout d’abord mon choix s’est porté sur le IXUS 85 IS car tout simplement c’est l'un...
  • Sending non form data with cforms II Cforms II from delicious days is probably the most powerful contact form plugin for WordPress. A friend using cforms II asked me for a way to send some non form...
    • ]]>

    I Love Rchouda

    I Love Rchouda

    Related Stuff :

    1. Binary Wallpaper My GEEKS wallpaper !...
    2. 2 Mois Avec Le Canon IXUS 85 IS Après avoir acheté cet appareil voilà 2 mois, j’ai décidé d'en partager mes trouvailles. Tout d’abord mon choix s’est porté sur le IXUS 85 IS car tout simplement c’est l'un...
    3. Sending non form data with cforms II Cforms II from delicious days is probably the most powerful contact form plugin for WordPress. A friend using cforms II asked me for a way to send some non form...

    ]]>     http://www.chlankboot.com/blog/i-love-rchouda/feed 0 http://www.chlankboot.com/blog/i-love-rchouda     Nahdha, Marzouki et vos chances de trouver l’âme sœur http://feedproxy.google.com/~r/chlankboot/~3/s-Oc_xZRFsU/nahdha-marzouki-et-vos-chances-de-trouver-lame-soeur http://www.chlankboot.com/blog/nahdha-marzouki-et-vos-chances-de-trouver-lame-soeur#comments Tue, 13 Dec 2011 20:56:31 +0000 chlankboot http://www.chlankboot.com/blog/?p=2222

    ]]>     http://www.chlankboot.com/blog/nahdha-marzouki-et-vos-chances-de-trouver-lame-soeur/feed 3 http://www.chlankboot.com/blog/nahdha-marzouki-et-vos-chances-de-trouver-lame-soeur     Challenge & Innovation http://feedproxy.google.com/~r/chlankboot/~3/8Yk0DjP4w6A/challenge-innovation http://www.chlankboot.com/blog/challenge-innovation#comments Sat, 08 Oct 2011 18:56:59 +0000 chlankboot http://www.chlankboot.com/blog/?p=2204
  • Pourquoi le RCD doit disparaitre Le RCD compte plus de 2 millions d’adhérents (d’après le premier ministère – décembre 2010). Propagande diriez-vous ? OK, disons qu’il n’en compte qu’un million, disons que seulement 100,000 sont...
  • 2 Mois Avec Le Canon IXUS 85 IS Après avoir acheté cet appareil voilà 2 mois, j’ai décidé d'en partager mes trouvailles. Tout d’abord mon choix s’est porté sur le IXUS 85 IS car tout simplement c’est l'un...
  • Lettre d’amour à ma femme C’est un hommage à la femme la plus merveilleuse de l’univers, la femme qui m’a tout donné, qui a tout laissé tomber pour moi, carrière, famille, amis … Cette femme...
    • ]]>

    Ce jeudi 06/10/2011, j’ai assisté à Jeddah au meeting organisé par Monsieur Abdellatif Khemakhem représentant la liste indépendante « Challenge & Innovation » pour la zone « Pays arabes et reste du monde ». Voici rapidement mes impressions :

    J’ai aimé :

    • Le candidat, Monsieur Abdellatif Khemakhem semblait être un homme très respectable.
    • C’est le seul candidat qui a pris la peine de rencontrer les électeurs (en tout cas en Arabie Saoudite), plein d’autres partis n’ont même pas pris la peine de m’envoyer leurs listes quand je les leur ai demandées.
    • D’après son discours, il semble être quelqu’un de modéré, ouvert avec un tout petit penchant conservateur.
    •  Il a accepté les critiques même celles où il « n’y était » vraiment pour rien du genre « allez vous nous réduire le prix des billets d’avions ? », a pris note des questions posées et a répondu à toutes.
    • Son expérience dans les domaines de la formation et du coaching.

    Je n’ai pas aimé :

    • Comme tous les autres, il propose un « gros programme électoral bourré de slogans », trop gras pour la constituante. Je n’étais pas le seul à partager cet avis. Les slogans manquaient aussi cruellement le « comment va-t-on-faire ».
    • Le Tunisien applaudit toujours, pendant les pauses, en fin de discours et entre les deux.
    •  Le Tunisien est toujours orphelin, il souffre toujours du syndrome de l’adoration de la personne, on vient pour la personne et non pas pour ce qu’elle représente ou va représenter.
    • Au lieu de nous vanter son programme ou ses idées, les collaborateurs de Monsieur Khemakhem n’ont pas arrêté de nous lire son CV et citer ses diplômes. C’est important, j’en conviens, mais ça n’a jamais été LE critère pour choisir son représentant, on aurait souhaité qu’on nous développe un peu sa vision et ses orientations.

    Finalement :

    On lui a reproché de présider un club privé appelé « Forum des compétences Tunisiennes en Arabie Saoudite » où la participation était tributaire des relations de complaisances avec les quelques membres. Monsieur Khemakhem avait souligné qu’il n’était pas au courant de cette sélectivité (là, on aurait aimé avoir droit à un غَلّطُونِي, mais bon…). Le lendemain, je constate que le groupe du même nom sur Facebook est devenu ouvert, un ami, m’y a même ajouté.

    Conclusion :

    Même si l’impression générale de la majorité des présents était plus ou moins positive, est-ce que cette liste pourrait faire le poids avec ses deux sièges dans la constituante, ne serait-il pas plus réaliste de voter pour un parti qui serait largement représenté ? Pourquoi Monsieur Khemakhem ne s’est-il pas allié à un parti déjà existant ?

    Liens utiles :

    Related Stuff :

    1. Pourquoi le RCD doit disparaitre Le RCD compte plus de 2 millions d’adhérents (d’après le premier ministère – décembre 2010). Propagande diriez-vous ? OK, disons qu’il n’en compte qu’un million, disons que seulement 100,000 sont...
    2. 2 Mois Avec Le Canon IXUS 85 IS Après avoir acheté cet appareil voilà 2 mois, j’ai décidé d'en partager mes trouvailles. Tout d’abord mon choix s’est porté sur le IXUS 85 IS car tout simplement c’est l'un...
    3. Lettre d’amour à ma femme C’est un hommage à la femme la plus merveilleuse de l’univers, la femme qui m’a tout donné, qui a tout laissé tomber pour moi, carrière, famille, amis … Cette femme...

    ]]>     http://www.chlankboot.com/blog/challenge-innovation/feed 0 http://www.chlankboot.com/blog/challenge-innovation     Disabling Android Market update http://feedproxy.google.com/~r/chlankboot/~3/r_KdYy8norg/disabling-android-market-update http://www.chlankboot.com/blog/disabling-android-market-update#comments Fri, 19 Aug 2011 13:34:53 +0000 chlankboot http://www.chlankboot.com/blog/?p=2187
  • Managing Comments in WordPress This post will describe SQL queries useful for managing conversation in WordPress. These queries could be run within phpMyAdmin or plugins like WP-DBManager. Enable comments for all published posts Enable...
  • 4 registry tweaks for securing your media Media in general and removable media like USB drives and flash memories in particular are one of the most important vectors of malware spread, especially at corporate level or in...
  • Word Custom Properties: How to Improve Productivity When working with Microsoft Word, a great part of administrative tasks consist in filling forms and generating reports on a pre-established templates or models. Now if within your document you...
    • ]]>

    I didn’t like the new android market application, and I’m not the only one. If you want to get back to old one, application name is Vending.apk available in the \system\app\ folder, you can just replace it from your old stock ROM. The easiest way is to send your old Vending.apk by bluetooth or cable to your phone and then use Root explorer to move it to the \app folder by overwriting existing one, of course to do that, you need root access. Do not forget to wipe Dalvik cache. Some developers offer a convenient package to be installed in recovery mode.

    But even after rolling-back, Android Market application gets automatically updated and there’s is no option to disable this update. We can fix this by using Terminal Emulator. We will gain root access and then disable the updater application:

    su -
pm disable com.android.vending.updater

    That’s it, and if by chance things go wrong, you can just enable updating.

    Related Stuff :

    1. Managing Comments in WordPress This post will describe SQL queries useful for managing conversation in WordPress. These queries could be run within phpMyAdmin or plugins like WP-DBManager. Enable comments for all published posts Enable...
    2. 4 registry tweaks for securing your media Media in general and removable media like USB drives and flash memories in particular are one of the most important vectors of malware spread, especially at corporate level or in...
    3. Word Custom Properties: How to Improve Productivity When working with Microsoft Word, a great part of administrative tasks consist in filling forms and generating reports on a pre-established templates or models. Now if within your document you...

    ]]>     http://www.chlankboot.com/blog/disabling-android-market-update/feed 11 http://www.chlankboot.com/blog/disabling-android-market-update     Displaying a full-page Frameset http://feedproxy.google.com/~r/chlankboot/~3/GuXryjz8oxg/displaying-a-full-page-frameset http://www.chlankboot.com/blog/displaying-a-full-page-frameset#comments Fri, 20 May 2011 18:02:51 +0000 chlankboot http://www.chlankboot.com/blog/?p=2181
  • Disabling Android Market update I didn’t like the new android market application, and I’m not the only one. If you want to get back to old one, application name is Vending.apk available in the...
  • Nahdha, Marzouki et vos chances de trouver l’âme sœur ...
  • Word Custom Properties: How to Improve Productivity When working with Microsoft Word, a great part of administrative tasks consist in filling forms and generating reports on a pre-established templates or models. Now if within your document you...
    • ]]>

    The following code can be used to “copy” a web site X in your own. Basically, it displays it inside a full page frameset, the browser address bar will always display your site’s URL, while the contents will be site X. In the example, the page title and keywords are also controlled.

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>This is a Damn Full Page Frameset</title>
<META name="description" content="chlankboot.com">
<META name="keywords" content="Chlankboot, Journal,">
</head>
<frameset rows="100%,*" border="0">
<frame src="http://www.chlankboot.com/" frameborder="0" />
<frame frameborder="0" noresize />
</frameset>
<!– pageok –>
<!– 01 –>
<!– 5.1–>
</html>

    Related Stuff :

    1. Disabling Android Market update I didn’t like the new android market application, and I’m not the only one. If you want to get back to old one, application name is Vending.apk available in the...
    2. Nahdha, Marzouki et vos chances de trouver l’âme sœur ...
    3. Word Custom Properties: How to Improve Productivity When working with Microsoft Word, a great part of administrative tasks consist in filling forms and generating reports on a pre-established templates or models. Now if within your document you...

    ]]>     http://www.chlankboot.com/blog/displaying-a-full-page-frameset/feed 0 http://www.chlankboot.com/blog/displaying-a-full-page-frameset     Ce dont a besoin la Tunisie http://feedproxy.google.com/~r/chlankboot/~3/0rx8_JiWdPk/ce-dont-a-besoin-la-tunisie http://www.chlankboot.com/blog/ce-dont-a-besoin-la-tunisie#comments Fri, 20 May 2011 13:01:13 +0000 chlankboot http://www.chlankboot.com/blog/?p=2134

    Ce qui suit ne vient pas de moi, je l’ai simplement reçu par mail mais j’ai décidé de le partager car je crois que ça colle un peu avec ce qui se passe en Tunisie.

    اقرأ الجمل المكتوبة في المثلثات

    هل لاحظت أن كلمة (في) مكتوبة مرتين في كل جملة ؟ هل تعرف ماذا حدث ؟ إنه طبقا لخبراتك السابقة فقد تمت برمجة عقلك أن كلمة (في) لا تـكتب سوى مرة واحدة في الجملة، لذلك لم يرها عقلك وجعلك ترى الجملة (في ضوء تجاربك السابقة) لا كما يجب أن تراها

    ماذا يعني هذا الكلام

    القصد من هذه الأمثلة هو التوضيح أننا نرى العالم طبقا لبرمجتنا السابقة فقط لا كما يجب أن نراه، نحن لا نرى الحقيقة إلا من خلال تجاربنا نحن فحين نختلف مع شخص ما في الرأي، يتمسك كل منا برأيه الذي كونته خبراته و تجاربه السابقة. حاول أن ترى الصورة الحقيقية، ليس كل ما تراه هو بالضرورة صحيح ! لأن ما تراه هو ما تمت برمجة عقلك عليه، ألم تخطئ منذ قليل في قراءة كلمة (في) الزائدة ؟ أعد التفكير في كل ما تراه صحيحا بالنسبة لك، تقبل النقاش و أعد النظر في أفكار من يختلفون معك. إنهم – فقط – لم تكن لهم تجاربك السابقة التي تؤهلهم كي يفكروا مثلما تفكر، فلماذا لا تتقبل فكرة أنهم ربما يكونون على شيء من الصواب؟ حاول أن تتفهم وجهة نظر الآخرين ولا تتمسك برأيك دائما لمجرَّد أنه رأيك، أعد النظر في برمجتك السابقة ولا تفترض دائما أن كل ما تراه صوابا

    قصة الفيل و العـميان

    يحكى أن ثلاثة من العميان دخلوا في غرفة بها فيل و طـلِب منهم أن يكتشفوا ما هو الفيل ليبدأوا في وصفه. بدأوا في تحسس الفيل وخرج كل منهم ليبدأ في الوصف :

    قال الأول : الفيل هو أربعة عمدان على الأرض !
    قال الثاني : الفيل يشبه الثعبان تماما !
    و قال الثالث : الفيل يشبه المكنسة !

    وحين وجدوا أنهم مختلفون بدأوا في الشجار وتمسك كل منهم برأيه وراحوا يتجادلون ويتِهم كل منهم الآخر بأنه كاذب ومدعٍ. بالتأكيد لاحظت أن الأول أمسك بأرجل الفيل والثاني بخرطومه ، والثالث بذيله. كل يعتمد على برمجته وتجاربه السابقة، لكن هل التفت إلى تجارب الآخرين ؟ من منهم على خطأ ؟ هل كان أحدهم يكذب ؟ بالتاكيد لا أليس كذلك ؟ من الطريف أن الكثيرين منا لا يستوعبون فكرة أن للحقيقة أكثر من وجه، فحين نختلف لا يعني هذا أن أحدنا على خطأ، قد نكون جميعا على صواب لكن كل منا يرى ما لا يراه الآخر لأنه لا يمكلك سوى جزءا من الحقيقة

    Un peu de tolérance … c’est tout ce dont on a besoin.

    ]]>     http://www.chlankboot.com/blog/ce-dont-a-besoin-la-tunisie/feed 1 http://www.chlankboot.com/blog/ce-dont-a-besoin-la-tunisie     Madain Saleh http://feedproxy.google.com/~r/chlankboot/~3/vz5AJFdefIw/madain-saleh http://www.chlankboot.com/blog/madain-saleh#comments Tue, 05 Apr 2011 16:04:32 +0000 chlankboot http://www.chlankboot.com/blog/?p=2124
  • The way to Madain Saleh Last week, we decided to go and visit the most important archaeological site in Saudi Arabia: Madâin Sâlih or Madain Saleh or (مدائن صالح). Here is just a foretaste: the...
  • Nahdha, Marzouki et vos chances de trouver l’âme sœur ...
    • ]]>

    Here it is: Madâin Sâlih or Madain Saleh or (مدائن صالح), no room to cheap talk, straight to the facts (or is it pics?) …

    Next »
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:46, SONY DSLR-A290, 10.0, 20.0mm, 0.004 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:48, SONY DSLR-A290, 11.0, 28.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:48, SONY DSLR-A290, 10.0, 20.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:49, SONY DSLR-A290, 10.0, 26.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:49, SONY DSLR-A290, 8.0, 55.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:49, SONY DSLR-A290, 10.0, 35.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:49, SONY DSLR-A290, 9.0, 24.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:51, SONY DSLR-A290, 5.6, 24.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:51, SONY DSLR-A290, 5.6, 24.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:52, SONY DSLR-A290, 5.6, 18.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:52, SONY DSLR-A290, 5.6, 18.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:53, SONY DSLR-A290, 7.1, 40.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:53, SONY DSLR-A290, 8.0, 55.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:55, SONY DSLR-A290, 11.0, 35.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:55, SONY DSLR-A290, 7.1, 55.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:59, SONY DSLR-A290, 5.6, 18.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 11:59, SONY DSLR-A290, 5.6, 18.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 12:00, SONY DSLR-A290, 5.6, 18.0mm, 0.017 sec, ISO 400

    Next »
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:42, SONY DSLR-A290, 7.1, 18.0mm, 0.017 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:42, SONY DSLR-A290, 5.0, 18.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:40, SONY DSLR-A290, 8.0, 50.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:41, SONY DSLR-A290, 8.0, 50.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:41, SONY DSLR-A290, 14.0, 50.0mm, 0.008 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:41, SONY DSLR-A290, 14.0, 55.0mm, 0.008 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:41, SONY DSLR-A290, 8.0, 55.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:43, SONY DSLR-A290, 6.3, 55.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:43, SONY DSLR-A290, 8.0, 28.0mm, 0.017 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:45, SONY DSLR-A290, 8.0, 50.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:45, SONY DSLR-A290, 8.0, 50.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:45, SONY DSLR-A290, 8.0, 55.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:46, SONY DSLR-A290, 9.0, 55.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:46, SONY DSLR-A290, 10.0, 55.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:47, SONY DSLR-A290, 5.6, 18.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:47, SONY DSLR-A290, 3.5, 18.0mm, 0.1 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:47, SONY DSLR-A290, 3.5, 18.0mm, 0.04 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC25-Feb-2011 09:52, SONY DSLR-A290, 10.0, 18.0mm, 0.004 sec, ISO 100

    Related Stuff :

    1. The way to Madain Saleh Last week, we decided to go and visit the most important archaeological site in Saudi Arabia: Madâin Sâlih or Madain Saleh or (مدائن صالح). Here is just a foretaste: the...
    2. Nahdha, Marzouki et vos chances de trouver l’âme sœur ...

    ]]>     http://www.chlankboot.com/blog/madain-saleh/feed 1 http://www.chlankboot.com/blog/madain-saleh     Exporting DataGrid contents to Excel http://feedproxy.google.com/~r/chlankboot/~3/MNoR6ZW7gzs/exporting-datagrid-contents-to-excel http://www.chlankboot.com/blog/exporting-datagrid-contents-to-excel#comments Tue, 05 Apr 2011 13:14:54 +0000 chlankboot http://www.chlankboot.com/blog/?p=2112
  • ChlankMail: Extract Email Addresses From Any Text When you get emails like “you’re not gonna be able to pee for 3 years, if you don’t forward this mail to 23.6 of your friends”, the best revenge is...
  • Word Custom Properties: How to Improve Productivity When working with Microsoft Word, a great part of administrative tasks consist in filling forms and generating reports on a pre-established templates or models. Now if within your document you...
  • Some Crystal Reports useful formulas Creating a (unique*) time-based identifier (time-stamp), could be used to uniquely identify reports for example: *: Only if you do not call it more than once per second Replacing NULL...
    • ]]>

    Here’s an example of code (the quick n’dirty way as usual) to export the contents of a DataGrid control (called MyDataGrid in the example). The example uses an empty excel file as a template. This template is to be added to the project resources. I used a template first to try and then to make some formatting for the (empty) cells before they get filled by our program and avoid to do that formatting pro grammatically. 

        Private Sub Export_File_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Export_File.Click
        If Me.MyDataGrid.Rows.Count > 0 Then
            'SVFileDialog is a SaveFileDialog
            If SVFileDialog.ShowDialog() = DialogResult.OK Then
                Dim FilePath As String
                Dim i, j As Integer
                Dim appExcel As Excel.Application
                Dim wbExcel As Excel.Workbook
                Dim wsExcel As Excel.Worksheet
                FilePath = Application.UserAppDataPath & "\empty.tmp"
                Dim Ob As Object = My.Resources.ResourceManager.GetObject("empty")
                Try
                    Dim fs As New IO.FileStream(FilePath, IO.FileMode.OpenOrCreate)
                    Dim w As New IO.BinaryWriter(fs)
                    w.Write(Ob)
                    w.Close()
                    fs.Close()
                    Dim CurCulInfo As System.Globalization.CultureInfo
                    'Get current culture info, back it up
                    CurCulInfo = System.Threading.Thread.CurrentThread.CurrentCulture
                    'Forcing en-US culture info cos due to a bug, any other culture info will raise an exception
                    System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US")
                    appExcel = CreateObject("Excel.Application")
                    wbExcel = appExcel.Workbooks.Open(FilePath)
                    wsExcel = wbExcel.Worksheets(1)
                    For j = 0 To MyDataGrid.ColumnCount - 1
                        wsExcel.Cells(1, j + 1) = MyDataGrid.Columns(j).HeaderText
                        For i = 0 To MyDataGrid.RowCount - 1
                            wsExcel.Cells(i + 2, j + 1) = MyDataGrid(j, i).Value.ToString()
                        Next
                    Next
                    wsExcel.Columns.AutoFit()
                    wsExcel.SaveAs(SVFileDialog.FileName)
                    wbExcel.Close()
                    appExcel.Quit()
                    System.Threading.Thread.CurrentThread.CurrentCulture = CurCulInfo
                    releaseObject(appExcel)
                    releaseObject(wbExcel)
                    releaseObject(wsExcel)
                Catch er As Exception
                    _Display_Error(er.Message)
                End Try
            End If
        End If
    End Sub

    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

    Note that the lines 18 to 22 are used to save the current culture info of the executing thread in order to switch to English culture info. Line 36 is to restore it. This trick is used to overcome the “Old format or invalid type library” bug in Microsoft’s libraries described here. “releaseObject”, you guessed it, is just for cleaning up the mess.

    I also remember I spent a lot of time looking for the required dlls so I uploaded those for Excel and also for Word. You just add them as a reference in your projects.

    Related Stuff :

    1. ChlankMail: Extract Email Addresses From Any Text When you get emails like “you’re not gonna be able to pee for 3 years, if you don’t forward this mail to 23.6 of your friends”, the best revenge is...
    2. Word Custom Properties: How to Improve Productivity When working with Microsoft Word, a great part of administrative tasks consist in filling forms and generating reports on a pre-established templates or models. Now if within your document you...
    3. Some Crystal Reports useful formulas Creating a (unique*) time-based identifier (time-stamp), could be used to uniquely identify reports for example: *: Only if you do not call it more than once per second Replacing NULL...

    ]]>     http://www.chlankboot.com/blog/exporting-datagrid-contents-to-excel/feed 1 http://www.chlankboot.com/blog/exporting-datagrid-contents-to-excel     The way to Madain Saleh http://feedproxy.google.com/~r/chlankboot/~3/l7d2iPgRjPA/the-way-to-madain-saleh http://www.chlankboot.com/blog/the-way-to-madain-saleh#comments Fri, 04 Mar 2011 19:03:51 +0000 chlankboot http://www.chlankboot.com/blog/?p=2096
  • Madain Saleh Here it is: Madâin Sâlih or Madain Saleh or (مدائن صالح), no room to cheap talk, straight to the facts (or is it pics?) … Next » View at Picasa...
  • Nahdha, Marzouki et vos chances de trouver l’âme sœur ...
    • ]]>

    Last week, we decided to go and visit the most important archaeological site in Saudi Arabia: Madâin Sâlih or Madain Saleh or (مدائن صالح). Here is just a foretaste: the incredible photos taken on the wild desert between Medina and Al Ula city.

    Next »
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 10:38, SONY DSLR-A290, 11.0, 30.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 10:39, SONY DSLR-A290, 10.0, 24.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 10:39, SONY DSLR-A290, 5.6, 24.0mm, ISO 800
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 10:39, SONY DSLR-A290, 5.6, 24.0mm, ISO 800
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 11:27, SONY DSLR-A290, 5.6, 26.0mm, ISO 800
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 11:27, SONY DSLR-A290, 5.6, 26.0mm, ISO 800
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 11:28, SONY DSLR-A290, 5.6, 55.0mm, 0.002 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 11:28, SONY DSLR-A290, 9.0, 55.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 12:08, SONY DSLR-A290, 13.0, 55.0mm, 0.004 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 12:08, SONY DSLR-A290, 5.6, 55.0mm, 0.001 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 12:15, SONY DSLR-A290, 32.0, 40.0mm, 0.013 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 12:15, SONY DSLR-A290, 36.0, 55.0mm, 0.013 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 12:15, SONY DSLR-A290, 36.0, 55.0mm, 0.017 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 12:56, SONY DSLR-A290, 10.0, 18.0mm, 0.002 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 14:07, SONY DSLR-A290, 10.0, 18.0mm, 0.004 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 14:07, SONY DSLR-A290, 10.0, 18.0mm, 0.006 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 14:07, SONY DSLR-A290, 11.0, 26.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 14:08, SONY DSLR-A290, 11.0, 26.0mm, 0.006 sec, ISO 100

    Now, we reached Al Ula, the first set shows the giant rock known as the “Elephant Rock”. The second set of photos has been taken at Al Ula Plateau, an immense area at a height of more than a thousand meters, really impressing!

    Next »
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:35, SONY DSLR-A290, 9.0, 55.0mm, 0.003 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:36, SONY DSLR-A290, 10.0, 18.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:36, SONY DSLR-A290, 10.0, 18.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:38, SONY DSLR-A290, 10.0, 18.0mm, 0.005 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:46, SONY DSLR-A290, 13.0, 55.0mm, 0.005 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:50, SONY DSLR-A290, 6.3, 50.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:52, SONY DSLR-A290, 3.5, 18.0mm, 0.001 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:52, SONY DSLR-A290, 10.0, 18.0mm, 0.004 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:53, SONY DSLR-A290, 10.0, 18.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:54, SONY DSLR-A290, 10.0, 22.0mm, 0.002 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:54, SONY DSLR-A290, 10.0, 18.0mm, 0.005 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:55, SONY DSLR-A290, 22.0, 18.0mm, 0.02 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:57, SONY DSLR-A290, 22.0, 18.0mm, 0.033 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:58, SONY DSLR-A290, 22.0, 18.0mm, 0.033 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:59, SONY DSLR-A290, 22.0, 18.0mm, 0.033 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:59, SONY DSLR-A290, 22.0, 18.0mm, 0.033 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:59, SONY DSLR-A290, 22.0, 18.0mm, 0.033 sec, ISO 200
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 15:59, SONY DSLR-A290, 22.0, 18.0mm, 0.017 sec, ISO 200

    Next »
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:51, SONY DSLR-A290, 10.0, 18.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:52, SONY DSLR-A290, 9.0, 18.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:52, SONY DSLR-A290, 22.0, 18.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:54, SONY DSLR-A290, 8.0, 50.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:54, SONY DSLR-A290, 9.0, 50.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:54, SONY DSLR-A290, 9.0, 50.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:54, SONY DSLR-A290, 9.0, 50.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 16:55, SONY DSLR-A290, 8.0, 55.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:01, SONY DSLR-A290, 25.0, 55.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:01, SONY DSLR-A290, 25.0, 55.0mm, 0.017 sec, ISO 400
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:02, SONY DSLR-A290, 8.0, 24.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:11, SONY DSLR-A290, 9.0, 18.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:11, SONY DSLR-A290, 8.0, 26.0mm, 0.017 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:11, SONY DSLR-A290, 8.0, 55.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:26, SONY DSLR-A290, 8.0, 26.0mm, 0.008 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:26, SONY DSLR-A290, 7.1, 26.0mm, 0.01 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:26, SONY DSLR-A290, 9.0, 26.0mm, 0.013 sec, ISO 100
    SONY DSC
    View at Picasa

    SONY DSC24-Feb-2011 17:26, SONY DSLR-A290, 9.0, 26.0mm, 0.013 sec, ISO 100

    Stick around for the rest of our trip …

    Related Stuff :

    1. Madain Saleh Here it is: Madâin Sâlih or Madain Saleh or (مدائن صالح), no room to cheap talk, straight to the facts (or is it pics?) … Next » View at Picasa...
    2. Nahdha, Marzouki et vos chances de trouver l’âme sœur ...

    ]]>     http://www.chlankboot.com/blog/the-way-to-madain-saleh/feed 0 http://www.chlankboot.com/blog/the-way-to-madain-saleh     The Tunisian Revolution in pictures http://feedproxy.google.com/~r/chlankboot/~3/9rxem4HKt6c/the-tunisian-revolution-in-pictures http://www.chlankboot.com/blog/the-tunisian-revolution-in-pictures#comments Fri, 11 Feb 2011 16:31:05 +0000 chlankboot http://www.chlankboot.com/blog/?p=2082

    Next »

    ]]>     http://www.chlankboot.com/blog/the-tunisian-revolution-in-pictures/feed 0 http://www.chlankboot.com/blog/the-tunisian-revolution-in-pictures