Feeds:
Posts
Comments

Archive for September, 2007

How to get Excel sheet names

Posted in ASP .NET, Visual Studio 2005 Addins on September 28, 2007 | 12 Comments »

Here is a little piece of code to get your way around with Excel in VB .Net using VS 2005.
    Dim objExcel As Excel.Application
    Dim objWorkBook As Excel.Workbook
    Dim totalWorkSheets As Excel.Worksheet
    Dim objWorkSheets As Excel.Worksheet
    Dim ExcelSheetName As String = “”
    objExcel = CreateObject(“Excel.Application”)
    objWorkBook = objExcel.Workbooks.Open(“C:\myExcel.xls”)
    ‘ this code gets the names off [...]

Read Full Post »

Find and Replace Column values in a Table using T-SQL

Posted in SQL, SQL Server 2005, T-SQL, Tips and Tricks on September 20, 2007 | 1 Comment »

If you would like to find some charater/s in a column in the table and replace it here is a simple querry.
Note: For beginner please make sure you know what an update statement does. This query is going to update the column values in your table. So if you are just testing please use the Select statement [...]

Read Full Post »

Removing All HTML Tags from a String Using Regular Expressions

Posted in ASP .NET, RegEx, Regular Expressions, Tips and Tricks, VB .NET on September 7, 2007 | 1 Comment »

Once again I am blogging about the Regular expresisons at work.
Here is a link to my previous blog. I guess now I have become an addict to using Regular Expressions to make life easier and am now longer a newbie to them.
Today I just came accross the task of cleaning the users input string on one [...]

Read Full Post »

Disk drive information in vb.net System.IO.DriveInfo

Posted in .NET, .NET Framework 2.0, VB .NET on September 6, 2007 | 1 Comment »

I was taken by surprise when one of my servers hung up. No web site was showing I was getting an error of service not available message in my explorer. I remotely logged into my server and found out that one of  the drives had run out of space; and the disk cleaning utility had fired [...]

Read Full Post »

Silverlight 1.0 Officially Released

Posted in .NET, Microsoft, Silverlight on September 5, 2007 | Leave a Comment »

Well another revolution by Microsoft is on its way.
Silverlight has been officially released.
 
I have developed a little web application using Windows Expression Blend and Visual Studio Orcas and was really impressed. Well being a web developer I can forecast that this lethal combination of MS to integrate animation and the basic web is awesome. It [...]

Read Full Post »

Search Engine Optimization & Google AdWords Event Islamabad by Najam

Posted in Community News on September 4, 2007 | 5 Comments »

Hi folks this is the second time I am posting about yet another event by Mr. Syed Najam Ahmad who is the first Pakistani Qualified Google Advertising Professional.
Yep Najam is coming up with another workshop on the 9th of September in Islamabad a continuation of the one held in Feb this year. Link back.
Its a one day [...]

Read Full Post »