Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two formats: · The simple CASE function compares an expression to a set of simple expressions to determine the result. · The searched CASE function evaluates a set of Boolean expressions to determine the result. Examples: A. Using a SELECT […]
Tag: zonix Software Solutions
CASE (Transact SQL)
Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two formats: · The simple CASE function compares an expression to a set of simple expressions to determine the result. · The searched CASE function evaluates a set of Boolean expressions to determine the result. Examples: A. Using a SELECT […]
Paging in SQL Server
Visit: https://zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView cause the Performance issue when we have thousands and thousands of records in our database; because with every roundtrip to the data-server, […]
Paging in SQL Server
Visit: https://zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView cause the Performance issue when we have thousands and thousands of records in our database; because with every roundtrip to the data-server, […]
Using TRY-CATCH to Rollback a Transaction in the Face of an Error
Visit : https://zonixsoft.com (our official website) Error Handing in Sql Server 2005. The release of Sql Server 2005 has provided us somany features over its predecessor. No doubt that more preference is given to the tasks performed by the administrator. But there are some new development features added to make your Sql Code more powerful […]
Passing lists to SQL server stored procedures
Visit : https://zonixsoft.com (our official wbsite) Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: · INSERT […]
Passing lists to SQL server stored procedures
Visit : https://zonixsoft.com (our official wbsite) Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: · INSERT […]
Events and Delegates
Visit: https://zonixsoft.com Delegate Delegates act as an intermediary between an event source and an event destination. Technically, a delegate is a reference type used to encapsulate a method with a specific signature and return type. You can encapsulate any matching method in that delegate. To be even precise delegates are similar to function pointers. They […]
Threading
Visit: https://zonixsoft.com C# supports parallel execution of code through multithreading. A thread is an independent execution path, able to run simultaneously with other threads.A C# program starts in a single thread created automatically by the CLR and operating system (the “main” thread), and is made multi-threaded by creating additional threads.The CLR assigns each thread its […]
Some very special features of crystal reports
Visit: .comhttp://www.zonixsoft Create a Watermark A watermark is a graphical or textual element that is placed behind the rest of yourreport. Examples of useful watermarks are your company logo, the word “Draft,”or other items that you may want to appear right behind the rest of the elements of your report. 1. Open the report […]