| Home Page |
|||||
![]() Programminghelp.com - ArticlesProgramming Help is a community collaboration for programming resources, tutorials, articles, forums, and help. Offering articles written by programmers and developers with years of experience. ProgrammingHelp.com strives to develop and create context and articles in which the beginning and most advanced level programmers/coders can use in everyday methods of development. We welcome you to come join us with your questions and knowledge to help us create an excelled programming community and open forum.
Sql: not in Vs. not EqualWhile writing SQL queries, have you ever strung several (not equals) together in the WHERE clause and just wondered if that was inefficient? Or have you used the NOT IN function, (both of which can be used to get the same result), and wondered the same thing? If you have or just are curious about either of these methods, keep reading. In this article, both of these functions will be explored to see how efficient they are, plus it will cover a few other methods to get the same results. Sql: Coalesce() FunctionWhen developing queries in SQL Server, dealing with nulls can often be challenging. The COALESCE function was included in SQL 2005 to help deal with these issues. First let’s take a look at what COALESCE can offer. Generally, COALESCE function receives a sequence of values and a default value to used when all of items in the sequence of values are null. From here the function returns the first not-null in the sequence of values list. Creating an Encryption Utility in C# Final PartIn part three of this three part series we are going to continue with our Encryption utility example and pick up where we left off. What we learned in the previous articles was how many various types of encryption algorithms there are and which one of those algorithms we will be using for our example. Creating an Encryption Utility in C# Part TwoIn part two of this three part series we are going to continue with our Encryption utility example and pick up where we left off. What we learned in the previous article was how many various types of encryption algorithms there are and which one of those algorithms we will be using for our example. Creating an Encryption Utility in C# Part OneIn this three part series we are going to create an Encryption utility that can take a string value and turn it into an Encrypted Binary value, and then we will take that Binary value and turn it into a Base 64 encoded string that you can cut and paste into a Web Config file or to be used as a password to pass back and forth between services. C# Web Multi-view ControlAt some point in developing web sites or web applications, there will come a time when a requirement of having tab functionality like there is for a Windows application. Before ASP.NET, JavaScript had to be used to achieve this. But when ASP.NET 2.0 came out, a new set of controls were introduced to give the ability of having tab functionality for the web. With the new controls of a multi-view and view when combined with a few basic buttons, the tab can be created. Sql Server Integrated Services Package DeploymentA decent amount of material has been covered in this introductory series on SQL Server 2005 Integration Services. Many of the basic data flow tasks have been covered along with some database maintenance tasks. It is now time to put these techniques into use. Sql Server Integration Services: Calling Ssis Package in C#During this series about SQL Server Integration Services, the basics of importing, exporting, manipulating data, typical database maintenance and deployment of SSIS packages have been covered. In this last article of this introductory series on SSIS, the technique of calling a SSIS package from C# will be covered. Creating a Simple Ajax Control in Asp.net 2.0 and C#In this article I will explain how you can easily create an AJAX enabled web site within Visual Studio 2005 utilizing C# and how to utilize the AJAX framework to add a simple control from the list of controls available in the AJAX Control Toolkit. Installing Ajax Toolkit for Visual Studio .net 2005In this article I will explain how you can integrate the AJAX framework into a web site and very easily create an AJAX enabled web site within Visual Studio 2005 utilizing C#.
|
|||||
|
Article Categories
|
|
||||
|
|
|||||