‘ Invert the case of all characters of the input string” Examples:’ Debug.WriteLine(FlipCase(“Hello World”)) ‘ => hELLO wORLD’ Debug.WriteLine(FlipCase(“hELLO wORLD”)) ‘ => Hello World’ Debug.WriteLine(FlipCase(“3) this is message n. 3”))

‘ Replace all accented characters in the input string’ Note: this function was written according to Italian rules. Rules for your ‘ language may vary, for example È may not

‘ Convert the input word from plural to singularFunction PluralToSingular(ByVal plural As String) As String ‘ convert to lowercase for easier comparison Dim lower As String = plural.ToLower() Dim res

‘ Convert the input word from singular to pluralFunction SingularToPlural(ByVal singular As String) As String ‘ convert to lowercase for easier comparison Dim lower As String = singular.ToLower() Dim res

‘ Return a boolean indicating whether the input connection string is for the ‘ ADO.NET’s Oracle managed provider” Examples:’ Debug.WriteLine(IsOracleProviderConnString’ (“Server=myserver;Uid=myid;Pwd=mypwd;”)) ‘ => TrueFunction IsOracleProviderConnString(ByVal connString As String) As Boolean

‘ Concatenate an array of strings with commas and a final “and”,’ or other separators” Example:’ Debug.WriteLine(“Choose one from ” & CreateStringList(New String() {“item1”,’ “item2”, “item3”}))’ ‘ => Choose one

In MDI applications, a user might have two or three or even more MDI child windows open at any given time. But in applications where you have user log-in and

Say you wanted to transfer data from an unnormalized source table in Excel (a worksheet) to SQL Server. Take a look at the columns in the source table, TABLE_A, with

There is a common and tricky problem that arises when you’re sending data from an HTML form to the server?the amount of data you can send depends on which method

To test if an integer is a power of 2 (1,2,4,8,16…256…), use the following code: if (!(x & (x-1)) then … Because 2^N-1 numbers have no common bits with 2^N

Say Employee_Table has fields like EMP_NO, EMP_NAME, etc. In java, try this: try{ Connection conn =…//opening connection. PreparedStament ps = con.prepareStatement(“Select conn.setAutoCommit(false); Statement stmt = conn.createStatement(); stmt.addBatch( sql 1st insert

When you use a web service’s proxy class, the calls to the web service might fail if you’re behind a proxy server. To solve the problem, you set the Proxy

‘ Return a boolean indicating whether the input connection string for the OLEDB ‘ managed provider points to a SQL Server DB” Examples:’ Debug.WriteLine(IsOleDbSqlConnString(“Provider=SQLOLEDB.1;Data ‘ Source=.;User ID=sa;Password=;Initial Catalog=MyDB”)) ‘ =>

‘ Return a boolean indicating whether the input connection string is for the’ ADO.NET’s SQL Server managed provider’ Note: the function assumes the input string is a valid OLEDB or

‘ Return the Database name if the input connection string points to a SQL ‘ Server DB, or the DB path if the connection string points to a Jet (Access)

It may happen that you have to define a lot of variable of some type, and you want the possibility to later change their type without manually change the declaration