Search Issue when using Visual Studio 2003 on Windows Vista Operating system

A couple days ago, I faced a small issue when I tried to search specific value inside VS 2003 solutions while I have MS Windows Vista OS installed on my PC…. Doing searching will cause VS 2003 to be hanged and stop responding.. I overcome this issue by Disable Visual Themes for VS 2003.. To do so please follow the following steps

..... Click here to read more!

Develop .Net 1.1 Web Application on windows Vista (IIS 7)

To develop Web application using .Net 1.1 and Visual Studio 2003 on Vista OS (IIS 7), follow the below steps:

1. First of all you have to install Visual Studio 2003. this will install .Net 1.1 also
2. Install all service packs for .Net framework 1.1.

Click here to read more!

Content Management System (CMS)

Contenet Management System (CMS)

What is CMS?

Computer management system (CMS) is computer software that is used to create, edit and publish contents of websites. Typically, CMS is used to store, control, versioning and publish industry-specific documentations such as manuals, guides, articles…etc........ Click here to read more!

How to know the physical path of executing .Net assembly

In some cases you may come to a point where you want to know the physical path on your hard drive for the current assembly.. For example you might want to know the physical path of an Configuration XML file, .....

Click here to read more!

Substring Java Script function (left and right)

There is no built in functions inside Jscript to extract left or right substring from specific string… the following functions are customized to do so..

function LeftSubString(stringValue, length){

if (length <= 0)

return "";

else if (length > String(stringValue).length)

return stringValue;

else

return String(stringValue).substring(0,length);

}

function RightSubString(stringValue, length){

if (length <= 0)

return "";

else if (length > String(stringValue).length)

return stringValue;

else {

var iLen = String(stringValue).length;

return String(stringValue).substring(iLen, iLen - length);

}

}

How to know SQL Server version and SP

Many time I stuck with a question… what is this DB Server version and what Service pack is installed on it? What is the easiest way to know DB edition? I asked this question to a friend of mine and he gave me the following simple Select statement that answered my questions.

--------------------

SELECT SERVERPROPERTY('productversion') AS version

, SERVERPROPERTY ('productlevel') AS SP

, SERVERPROPERTY ('edition') AS DbEdition

--------------------

I hope you will find it useful :)

Reading Data from Excel by using SQL Statements & ODBC

In many cases I had to query data from excel sheet with large number of records … of course I can do this by using filtering feature from MS excel, many developer prefer writing sql statements instead of using filtering feature built into MS Excel. Using Sql statements to query data from Excel sheet will make developer life easier. You can load this sheet into DB server then query it using the ordinary tables, actually this is not the optimum solution for this case.. You can query excel sheet without load it into DB server.

By using ODBC you can query excel sheet's data without loading it into DB from inside Query analyzer or MS Sql Management studio…. It is very simple query and u can even filter by writing your own WHERE condition.

To query data form MS Excel 2003 you can use the following Select Statement:

----------------

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=FileNameWithPath.xls',

'Select * from [Sheet1$]')

----------------

And form MS Excel 2007 you can use the following select statement:

---------------

SELECT *

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=FileNameWithPath.xlsx;HDR=No;IMEX=1',

'select * from [Sheet1$]')

----------------

For example:

Suppose you have an excel sheet with 3 columns; firstName,lastName and Email.And this sheet is stored at C:\Filename.xsl on your hard drive… to query this file:

-----------

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=c:\filename.xls',

'Select * from [Sheet1$]')

------------