Siccolo - Free Management Tool For SQL Server!

Exception handling -> "bubble up

2020-02-17T14:43:00.001-05:00

Exception handling -> "bubble up"

Exception handling

(#1)


 try
 {
  ...
  // might fail
  ...
 }
 catch (Exception ex)
 {
  ...
  Log(ex);
  throw ex;
 }

where throw ex bubbles the exception up the chain. Creates a new exception to throw - Stack Trace is truncated below the method that failed, no longer have the full stack trace information.

(#2) Compare to


...
catch (Exception ex)
{
 ...
 throw;
}
...

Here throw "rethrows" exception, and Stack trace information is preserved.

So, if (#1) wants to add user-friendly throw new ApplicationException("failed for certain"), then proper way would be throw new ApplicationException("failed for certain", ex)

more at siccolo blurbs

Rotate Array Left N-times c#

2020-02-17T14:36:00.001-05:00

Rotate Array Left N-times c#:


public static int[] RotateArrayLeft(int[] ins, int startindex = 1)
 {
  if (ins == null || ins.Length == 0) { return ins; }
  var outs = new int[ins.Length];
  //Copy(Array sourceArray, int sourceIndex, Array destinationArray, int destinationIndex, int length):
  Array.Copy(ins, startindex, outs, 0, ins.Length - startindex);
  var q = new Queue(ins);
  for (int i = outs.Length - startindex; i < outs.Length; i++)
  {
   outs[i] = q.Dequeue();
  }

  return outs;
 }

more at siccolo blurbs

Shift array

2020-02-17T14:34:00.001-05:00

Shift array:


public static int?[] ShiftArray(int?[] ins)
 {
  if (ins == null || ins.Length == 0) { return ins; }
  var outs = new int?[ins.Length];
  Array.Copy(ins, 1, outs, 0, ins.Length - 1);
  outs[outs.Length - 1] = ins[0];
  return outs;
 }

more at siccolo blurbs

2020-02-17T14:13:00.000-05:00

manually reverse a string:


 public static string ReverseStringManual(string ins)
 {
  StringBuilder outs = new StringBuilder(ins.Length);
  for (int i = ins.Length; i > 0; i--) { outs.Append(ins[i - 1]); };
  return outs.ToString();
 }

more at siccolo blurbs

next article in Developing Facebook Application with FBML FBJS FQL and .NET series at CodeProject

2008-05-22T12:46:00.000-04:00

see at Developing Facebook Application with .NET - part 2

next article in Developing Facebook Application with FBML FBJS FQL and .NET series

2008-05-22T11:44:00.003-04:00

next article in Developing Facebook Application with FBML FBJS FQL and .NET series:

ASP.NET - using FBML Tabs - <fb-tabs/> and <fb:tab-item/> in ASP.NET

ASP.NET - using <fb:request-form/> in ASP.NET

ASP.NET - building Invite page with FBML multi friend selector from ASP.NET

access Facebook Data from ASP.NET (C#) using FQL and DirectFQLQuery()

ASP.NET - update Facebook user profile using SetFBML, <fb:subtitle/>, <fb:wide/> in ASP.NET

ASP.NET - update Facebook user profile using <fb:ref/>, SetRefHandle

ASP.NET - build scheduled updates for Facebook - "cron job" for Facebook using ASP.NET

ASP.NET - populate user profile mini-feed using PublishAction(), Feed.publishActionOfUser using ASP.NET

ASP.NET - handle Application unsintall/remove using Post Remove URL in ASP.NET

Comma delimited files - Load Dataset from CSV File - Reading CSV and Parsing CSV Files

2008-05-20T10:47:00.002-04:00

new artcle at Siccolo -

How to open Dataset From Comma delimited (CSV) File - Reading CSV files - Parsing CSV Files

fix for Error: FacebookAPI.CreateSession() -> FacebookAPI.ErrorCheck(): Invalid Parameter

2008-03-07T13:30:00.000-05:00

Fix for FacebookAPI.CreateSession() - FacebookAPI.ErrorCheck() - Invalid Parameter problem in Facebook Developer Toolkit -
see it at Siccolo articles

Developing Facebook Application with FBML and .NET article on www.codeproject.com

2008-03-06T16:59:00.000-05:00

Siccolo development article on www.codeproject.com - Developing Facebook Application with FBML FBJS and .NET, with C#

Developing Facebook Application with FBML and .NET article on www.lottext.com

2008-03-06T16:23:00.000-05:00

Siccolo development article on www.lottext.com - Developing Facebook Application with FBML FBJS and .NET, with C#

Developing Facebook Application with FBML and .NET

2008-03-06T15:59:00.001-05:00

Developing Facebook Application with FBML FBJS and .NET -
how to build a sophisticated Facebook application that interacts with Facebook users and with a SQL Server database - see it at Siccolo articles

Develop Custom File Upload article on www.lottext.com

2008-03-04T15:15:00.003-05:00

Siccolo development article on www.lottext.com - Develop Custom File Upload with Javascript and Scripting.FileSystemObject

Create Custom File Upload - .NET Software Development - Javascript and Scripting.FileSystemObject

2008-03-04T14:49:00.001-05:00

How to create Custom File Upload - .NET Software Development - Javascript and Scripting.FileSystemObject - a new Siccolo development article -
Custom File Upload with Javascript and Scripting.FileSystemObject, Web Service/ASP.NET and C#

address showModalDialog() problem and javascript

2008-03-04T09:45:00.003-05:00

new article on Siccolo - address showModalDialog() problem and javascript

Personal Security Certificate PFX article on www.lottext.com

2008-03-03T09:44:00.002-05:00

posted article on Windows Mobile - How to Install Personal Security Certificate PFX

sql number format and sql format number

2008-02-26T11:45:00.001-05:00

Creating user defined number format function to

dbo.format_number (1234), dbo.format_number (-1234.05), results are:
1,234 and -1,234.

sql currency format and sql format currency

2008-02-26T11:43:00.001-05:00

Creating user defined currency format function to

select dbo.format_currency (1234), dbo.format_currency (-1234.05), results are:
1,234.00 and -1,234.05.

Hubba-Hubba

2008-02-14T10:44:00.000-05:00

hubbing at Siccolo Hub

How to Install Personal Security Certificate in C# compact framework using PFXIsPFXBlob(), CertAddCertificateContextToStore() functions

2008-02-01T14:08:00.003-05:00

Access web service with required personal security certificate - using x509 PFX personal certificate - Install Personal Security Certificate in C# compact framework. :


...
byte[] pfxData = GetFile(certificatePath);
...
CRYPT_DATA_BLOB pPFX = new CRYPT_DATA_BLOB();
pPFX.cbData = pfxData.Length;
pPFX.pbData = Marshal.AllocHGlobal(pfxData.Length);
Marshal.Copy(pfxData, 0, pPFX.pbData, pfxData.Length);
...
hMemStore  = PFXImportCertStore(ref pPFX, password, CRYPT_USER_KEYSET);
...
cert_MY_store = CryptoAPI.CertOpenStore(new IntPtr(CERT_STORE_PROV_SYSTEM_W),
                                                           0, 
                                                            IntPtr.Zero,
                                                            CERT_SYSTEM_STORE_CURRENT_USER, 
                                                            "MY");

...
...
CertAddCertificateContextToStore(cert_MY_store,
                                                               hCertCntxt,
                                                               (int)CERT_STORE_ADD_REPLACE_EXISTING, IntPtr.Zero)

.NET Compact Framework Miscellaneous Development Tips...

2008-02-01T14:02:00.000-05:00

How to open Dataset from a Text File and display Text File in GridView or in ListView

2008-01-15T12:45:00.000-05:00

New article at Siccolo .NET Development Articles - Open Dataset from Text File - Load ListView and GridView in .NET from TextFile - using OleDB namespace and OleDbConnection, OleDbCommand, OleDbAdapter, DataSet, DataRow, DataColumn objects...

[off topick] - what is NETWORK MARKETING

2007-12-26T12:28:00.000-05:00

How to enumerate running processes using WMI and Win32_Process class

2007-12-11T13:34:00.001-05:00

see at How to enumerate running processes using WMI and Win32_Process class

SQL Sever - How to Create a Directory (Folder) - Using xp_cmdshell and mkdir command

2007-12-06T16:30:00.000-05:00

SQL Sever - How to Create a Directory (Folder) - Using xp_cmdshell and mkdir command

How to Mass Rename Files from SQL using xp_cmdshell and rename command

2007-12-06T16:26:00.000-05:00

SQL Server - using xp_cmdshell and rename command to mass rename files