Rodan Sotto's Tech Blog

Web services are services provided over the web using standard technologies such as XML, a W3C standard. Any application on any platform can consume a web service as long as it is able to understand XML. XML is text based, thus it is quick and easy to download and even easier to use. To consume an ASP.NET web service, look for an .asmx ... Read More

If you have an application, say in .NET, that uses an Access database in some way or the other, or uses SQL Server that in turn links to an Access database through the Linked Server object, and you want to run your application and also the SQL Server on a 64-bit OS/machine, you might be in for a lot of surprises.   Here is why: The Microso... Read More

Error handling in SQL Server is similar to C#’s exception handling.  Syntax is below: BEGIN TRY -- this is where you put your statements END TRY BEGIN CATCH -- this is where you handle the error END CATCH     And of course you can get more information about the error using the following: ERROR_PROCEDURE() – returns name of stored... Read More

jQuery is one of the Javascript frameworks out there, and it’s the most popular.  Basically it lets you write less Javascript code and do complicated things using simple calls to the framework.  To use jQuery in your HTML page, first you need to download the library from it’s website jQuery.com.  Just like adding an external Javascript file, yo... Read More

On my previous post, I talked about HTML and CSS.  Now I’m going to talk about Javascript.  Javascript is a popular scripting language that makes an HTML page dynamic.  To add Javascript code, you use the _ <script type="text/javascript"\> function myFunction() { alert("Hello, Universe!!!"); ... Read More