META tag info in SEO

We often miss to consider META tag in web development. Basically its very useful for Search Engine Optimization (SEO).

Content given in META tag :

Content returned by Search Engine :

.NET 3.5 Features

I just started on reading .Net 3.5 features and impressed with following great things, and listing for guys who want to start exploring .net 3.5.

1) LINQ - Gives differant ways of writing Data Access code,With new programming style. .Net uses built-in to execute this.

2) JS Intellisense - This was delivered in VS 2008. Same like our Server-Side code (i.e c#), even in JS we have auto-complete of methods and properties available for an JS objects. Explore more on :http://weblogs.asp.net/scottgu/archive/2007/06/21/vs-2008-javascript-intellisense.aspx

3) JS Debugger - Even this delivered in VS 2008. As like server-side debugging we can put breakpoint on any javascript code block and VS will execute that block when page get rendered. Now no need to use 'debugger' keyword on any JS block.This will work ASp.net 2.0 web page edited in VS 2008. Expore more on : http://weblogs.asp.net/scottgu/archive/2007/07/19/vs-2008-javascript-debugging.aspx

4)Debugging .Net Fx Classes - Using VS 2008, we can debug .Net framework class libraries by simple pression F11, With previous version by doing same will take to a meta-data information, but now will take to source code. This is very great feature and give good knowledge of exploring Microsoft development standards. Bit excited with feature .. !!!. Explore more on http://weblogs.asp.net/scottgu/archive/2007/10/03/releasing-the-source-code-for-the-net-framework-libraries.aspx.

Will keep editing these post by reading feature one-by-one.

Thanks,
Guna.

Converting any File to Byte[] and Byte[] to File.

Below C# code takes filepath, where file located as input parameter and gives byte array of that file.

public byte[] ReadFile(string sPath)
{
FileStream fStream = null;
try
{byte[] data = null;
FileInfo fInfo = new FileInfo(sPath);
long numBytes = fInfo.Length;
fStream = new FileStream(sPath, FileMode.Open, FileAccess.Read);
using (fStream)
{
BinaryReader br = new BinaryReader(fStream);
data = br.ReadBytes((int)numBytes);
}
return data;
}
catch { throw; }
finally { fStream.Dispose(); }
}


Below code snippets takes Byte array and File extention as input parameter and stores the file in application path under temp folder.

public byte[] ReadFile(string sPath)
{
FileStream fStream = null;
try
{byte[] data = null;
FileInfo fInfo = new FileInfo(sPath);
long numBytes = fInfo.Length;
fStream = new FileStream(sPath, FileMode.Open, FileAccess.Read);
using (fStream)
{
BinaryReader br = new BinaryReader(fStream);
data = br.ReadBytes((int)numBytes);
}
return data;
}
catch { throw; }
finally { fStream.Dispose(); }
}

Considering Comments in ASP.Net webpage.

“Even small thing make a big difference”, to prove this, commenting content in ASP.Net webpage page can be done using two methods.
1)<!—Normal HTML comment --><br /> 2)<%-- ASP.NET Comment --%>

Important and considerable difference between these two comments were, with HTML comments, content commented get rendered when web page requested and result in increasing download size. So its good to use ASP.NET comments.

SQL Script to find total records of all tables.

This T-SQL script will return number of rows for each table in a database and total records across all tables. This will be very much useful for SQL admin to watch the data growth in database.

SELECT Row_Number() over (Order by sysindx.rowcnt DESC ) AS SlNo

,sysObj.name AS ‘Table Name’,sysindx.rowcnt AS ‘Row Count’

FROM sysobjects sysObj

inner join sysindexes sysindx

on sysindx.id = sysObj.id

WHERE sysindx.indid IN(0,1)

AND sysObj.xtype = ‘u’

AND sysObj.name NOT IN(’sysdiagrams’)

COMPUTE SUM(sysindx.rowcnt);



Note: This will work only on MSSQL 2005 and later. Because Compute and Row_Number were introduced new in 2005.

Undocumented SQL pwdcompare function.

There will be some occasion, where we need to check SQL authentication programmatically, here is one SQL undocumented function pwdComapare, will return ‘1′ if password match with password hash in SQL server.


This SQL stuff will explains rest.

Declare @loginName as varchar(100)

Declare @Password as varchar(50)

set @loginname = ‘guna’

set @Password = ‘gunapwd123′

IF (select pwdcompare(@Password,Password_hash) from sys.sql_logins

where name = @loginName) = 1

Select ‘Success’

ELse

Select ‘Failure’

Opening Windows Image Viewer programmatically - C#.NET

Below Code open windows defalut Image and photo viewer from .Net

public void OpenImageFile(string FilePath)
{
Process objProcess = new Process();
objProcess.StartInfo.FileName = “rundll32.exe”;
objProcess.StartInfo.UseShellExecute = false;
objProcess.StartInfo.Arguments = ” shimgvw.dll ImageView_Fullscreen ” + FilePath;
objProcess.Start();
objProcess.WaitForExit();
objProcess.Close();
}