SQL Server 2005 Mobile edition –> SQL Server 2005 Everywhere –> SQL Server 2005 Everywhere–>SQL Server 2005 Compact Edition

SQL Server 2005 Mobile edition SQL Server 2005 Compact Edition SQL Server 2005 Everywhere   What are they and how are they different….These are all almost same…J Actually first came Mobile Edition…then MS changed the License policy allowing it to be used everywhere it was named as t EveryWhere…then during the CTP partners complained that the…

1

SQL Server Compact Edition and Visual Studio

Let me start with a brief description of what SQL Server Compact Edition is and something about its internals. SQL Server Compact Edition is a file-based database that consists of seven DLLs that are approximately 1.4 MB and does not run as a service to keep the footprint low. When you create a SQL Server…

1

Recursively listing the files

This function will help you to list all the files with the specified extension recursively i.e. it will also list the files within the child directory. private static void BuildList(string searchPath, bool recursive, string ext, ArrayList files) {   DirectoryInfo parentDir = new DirectoryInfo(searchPath); DirectoryInfo[] children = parentDir.GetDirectories(); if (recursive && children.Length > 1) {…

2

Easy way to create a connection string

I am sure you are already using one tool or other ….but I always found UDL file as the easiest way to create a connection string……. What is UDL file? UDL is Universal Data Link file contains the connection information. So how to create one…. Step 1: Right click in the folder you want to create…


Using Tabular Data Control to display CSV files

One Easy Way to display smartly data from your excel sheet on webpage. I was recently trying to display some date from and excel sheet on a webpage. Yes save as webpage is alway and option. But then the data becomes static….So how to displaythe data smartly I mean with paging and sorting support..One cool…

1