Code In Action

The new office suite version 2007 comes with brand-new file formats. One of them is the new Access database format version 2007 with accdb extension. Of course there is a new connection string for those new access databases. You can use the connection string below to access your accdb databases through asp.net. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Persist Security Info=False; In addition, if you are using passwords to access your database, you can include it in your connection string like below; Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Jet OLEDB:Database Password=MyDbPassword; However, your hosting provider will not be aware of this upgrade or probably you don’t want to install Access 2007 on your server. Actually, you don’t need to. Just install 2007 Office System Driver: Data Connectivity Components

You have created an application say for example a web service and want to secure it but wondering how to create and install SSL certificate in order to test it?, then do not worry; just read this article :) So before proceeding, let’s make sure you have Internet Information Services (IIS) 6.0 Resource Kit Tools installed on your machine. You can download this from here: http://www.microsoft.com/downloads/details.aspx?familyid=56FC92EE-A71A-4C73-B628-ADE629C89499&displaylang=en Size: 5.8 MB. Once you finish downloading, install it. Now go to Start menu and look for “ IIS Resources ” and under this, look for “ Self SSL ”. Run the exe (which looks similar to command prompt). The syntax of the command is: SelfSSL [/T] [/N:CN] [/K:key Size] [/S:site id] [/P:port] Now type the following command: selfssl.exe /T /N:CN="your machine name" /K:1024 /V:7 /S:1 /P:443 Just specify your machine’s name. You can also change the parameters if required. Meaning of these para...

Wow! What a gr88 feature in .Net… Now you can create your own executable file directly on the runtime. Just supply the source code and create an .exe as you want it to be. Here is the code snippet; I was surprised to see how easy it was. Then just place this code in a Button Click event. Microsoft.CSharp.CSharpCodeProvider cp = new Microsoft.CSharp.CSharpCodeProvider(); System.CodeDom.Compiler.ICodeCompiler ic = cp.CreateCompiler(); System.CodeDom.Compiler.CompilerParameters cpar = new System.CodeDom.Compiler.CompilerParameters(); string pathIcon = Application.StartupPath + "\\icon.ico"; cpar.CompilerOptions = "/target:winexe" + " " + "/win32icon:" + "\"" + pathIcon + "\""; cpar.IncludeDebugInformation = false; cpar.TreatWarningsAsErrors = false; cpar.OutputAssembly = Application.StartupPath + "\\MyApplication.exe"; cpar.GenerateInMemory = false; cpar.GenerateExecutable = true; cpar.ReferencedAssemblies.Add...

In this article you will learn how to: Add or delete controls at runtime. Access controls with the indexer. Create control collection using Hash Table. Download full source code. To start with, create a windows application project and add a class to it. We will create a button array so name it as “ButtonArray.cs”. Add the following code to it: Class “ButtonArray” is inherited from the Hash table, so it will be easy for us to add buttons in the collection. Let’s have a look into the “AddButton” method. In this method, we create an instance of a button with the necessary properties and add it to the hash table as well as to the form’s control collection. Each time the control is added in the hash table with its unique key. This helps us to access the controls when required. Now we’ll see how to remove control from the hash table and form’s control collection. In order to remove the control, just pass the key. That’s simple! Isn’t it? :-) Ok! That w...