{C}Bonacci

How Set Client-Side Selected Value from DropDownList Using the CascadingDropDown

2008-09-24T21:27:00.009+02:00

L'altro giorno mi sono imbattuto in questo piccolo problemino...
Beh, non so se questo è il modo corretto .... ma funziona!

1 // set default value

2 function setSelectedIndex(_control, _value) {

3 for ( var i = 0; i < _control.options.length; i++ ) {

4 if ( _control.options[i].value == _value ) {

5 _control.options[i].selected = true;

6 return;

7 }

8 }

9 }

10 // Load Data From DB

11 function LoadData()

12 {

13 GetWebServiceProxy().GetDataFromDB(key, LoadSuccess, LoadFail, key);

14 }

15 // Binding Data

16 function LoadSuccess(result, userContext, methodName)

17 {

18 // set the Parent value

19 setSelectedIndex( $get(ddlParent), result.parentValue );

20 // set the Child value

21 $find("bIDChild").set_contextKey( result.parentValue );

22 $find("bIDChild")._onParentChange( null, false );

23 $find("bIDChild").set_SelectedValue( result.childValue, result.childValue );

24 }

26 // Raise Error

27 function LoadFail(result, userContext, methodName)

28 {

29 alert('[LoadData] method fail.');

30 }

31 </script>

33 <div>

34 <asp:DropDownList ID="ddlParent" runat="server">

35 </asp:DropDownList>

36 <ajaxToolkit:CascadingDropDown ID="cdParent" runat="server" TargetControlID="ddlParent"

37 Category="Parent" PromptText="Please select an Parent" LoadingText="[Loading Parent...]"

38 ServicePath="myWebServices.asmx" ServiceMethod="myWebMethod" BehaviorID="bIDParent" />

39 <asp:DropDownList ID="ddlChild" runat="server">

40 </asp:DropDownList>

41 <ajaxToolkit:CascadingDropDown ID="cdChild" runat="server" TargetControlID="ddlChild"

42 Category="Child" PromptText="Please select an Child" LoadingText="[Loading Child...]"

43 ServicePath="myWebServices.asmx" ServiceMethod="myWebMethod" BehaviorID="bIDChild"

44 ParentControlID="ddlParent" />

45 </div>

How turn off the beep sound in a virtual machine

2008-09-07T20:22:00.009+02:00

... e come direbbe una persona che conosco: "... off ..." :-)
Chi lavora su "virtual machine" prima o poi non arriva ad odiare quel fastidiosissimo "beep"!!!
Io sono uno di quelli :-( e visto che mi dimentico sempre come si "disabilita", ho deciso di "postarlo" qui:

net stop beep

Questo "service" se così possiamo chiamarlo si può anche disabilitare.
Qui è possibile trovare tutti i dettagli.

Ciao

Fibonacci numbers

2008-08-31T20:51:00.013+02:00

Beh, quanto {C}bonacci non potevo no fare un riferimento al mio avo!?! scherzo :-)

145 //...I primi 41 numeri di Fibonacci sono:

146 //...0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55 (=F10),

147 //...89, 144, 233, 377, 610, 987, 1597, 2584, 4181, 6765 (=F20),

148 //...

149 Func<int, int> _fibo = null;

150 _fibo = n => n > 1 ? _fibo(n - 1) + _fibo(n - 2) : n;

151 Console.WriteLine( _fibo(20) );

Ciao.

Generate and send by mail an Excel File using Office Open XML spreadsheet data format

2008-08-31T17:16:00.028+02:00

Qualche tempo fa ho avuto l'esigenza di siluppare una funzione che generasse un Excel File e lo inviasse come "attach" via email.
Questo il codice:

14 /// <summary>

15 /// Create a E-Mail Attach from Stream

16 /// </summary>

17 private static void StreamToAttachment()

18 {

19 //...create the mail message

20 MailMessage _mail = new MailMessage();

22 //...set the addresses and content

23 _mail.From = new MailAddress("mailFrom@cbonacci.net");

24 _mail.To.Add("mailFrom@cbonacci.net");

25 _mail.Subject = "Excel: Attachments and Streams";

26 _mail.Body = "... I love C# ...!";

28 //... retrieve binary data and save to a stream

29 byte[] _data = _streamBuilder();

30 MemoryStream _stream = new MemoryStream(_data);

32 _mail.Attachments.Add(

33 new Attachment(_stream,

34 "cb_example.xls",

35 MediaTypeNames.Text.Plain)

36 );

38 //...send the message

39 SmtpClient _smtp = new SmtpClient("127.0.0.1");

40 _smtp.Send(_mail);

41 }

43 /// <summary>

44 ///

45 /// </summary>

46 /// <returns></returns>

47 private static byte[] _streamBuilder()

48 {

49 string _xml = _createWorkbookFromdataSet(

50 //...get your data from dataBase

51 GetDataForDB() );

53 byte[] _byteData = Encoding.ASCII.GetBytes(_xml);

54 return _byteData;

55 }

57 /// <summary>

58 ///

59 /// </summary>

60 /// <param name="sourceData"></param>

61 /// <returns></returns>

62 private static string _createWorkbookFromdataSet(DataSet sourceData)

63 {

64 XmlDataDocument _xmlDataDoc =

65 new XmlDataDocument(sourceData);

66 XslCompiledTransform _xt =

67 new XslCompiledTransform();

68 StreamReader _reader = new

70 StreamReader("Excel.xsl");

71 XmlTextReader xRdr = new XmlTextReader(_reader);

73 _xt.Load(xRdr, null, null);

74 StringWriter _sw = new StringWriter();

75 _xt.Transform(_xmlDataDoc, null, _sw);

77 //...retunr string XML Worksheet.

78 return _sw.ToString();

79 }

... a very simple Excel/xls

1 <xsl:stylesheet version="1.0"

2 xmlns="urn:schemas-microsoft-com:office:spreadsheet"

3 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

4 xmlns:msxsl="urn:schemas-microsoft-com:xslt"

5 xmlns:user="urn:my-scripts"

6 xmlns:o="urn:schemas-microsoft-com:office:office"

7 xmlns:x="urn:schemas-microsoft-com:office:excel"

8 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" >

10 <xsl:template match="/">

11 <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

12 xmlns:o="urn:schemas-microsoft-com:office:office"

13 xmlns:x="urn:schemas-microsoft-com:office:excel"

14 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

15 xmlns:html="http://www.w3.org/TR/REC-html40">

16 <xsl:apply-templates/>

17 </Workbook>

18 </xsl:template>

20 <xsl:template match="/*">

21 <Worksheet>

22 <xsl:attribute name="ss:Name">

23 <xsl:value-of select="local-name(/*/*)"/>

24 </xsl:attribute>

25 <Table x:FullColumns="1" x:FullRows="1">

26 <Row>

27 <xsl:for-each select="*[position() = 1]/*">

28 <Cell><Data ss:Type="String">

29 <xsl:value-of select="local-name()"/>

30 </Data></Cell>

31 </xsl:for-each>

32 </Row>

33 <xsl:apply-templates/>

34 </Table>

35 </Worksheet>

36 </xsl:template>

38 <xsl:template match="/*/*">

39 <Row>

40 <xsl:apply-templates/>

41 </Row>

42 </xsl:template>

44 <xsl:template match="/*/*/*">

45 <Cell><Data ss:Type="String">

46 <xsl:value-of select="."/>

47 </Data></Cell>

48 </xsl:template>

Ciao

Extract only numbers from a String in SQL Server

2008-08-27T19:04:00.027+02:00

Circa una settimana fa, davanti ad un buon caffè, Guglielmo ovviamente :-), un mio carissimo amico mi chiese una Function in SQL Server che estraesse da una stringa solo numeri.
Lavorando da molti anni in Oracle ho subito pensato alle functions Translate or regexp_replace (10g).
Ma poi mi sono ricordato che in SQL Server, la funzione Translate non esiste e l’utilizzo delle “Regular Expression” è possibile sono by CLR .

Allora documentandomi un po’ in giro ecco una soluzione carina, spero!?! :-)

declare @in_string varchar(255)
declare @out_string varchar(255)

set @in_string='Carlopoli21082008Claudio&Rino&pureSergio'
set @out_string = ''

select @out_string = @out_string + a.sub_char
from
(
select substring(@in_string, b.number,1) as sub_char
from master..spt_values b
where b.type = 'p'
and b.number between 1 and len(@in_string)
) as a
where isnumeric(a.sub_char) = 1

print @out_string

Ciao.
PS: Ringrazio il "vecchio", ma sempre saggio, Arcuri ... :-)

Birth!!!

2008-08-23T12:44:00.000+02:00

... dopo 2 settimane di totale relax a Carlopoli :-) nasce qui questo nuovo blog!