GOPI's PORTAL

SEO: Adding Meta Tags to ASPX Page Programmatically

2012-02-14T11:09:00.005+05:30

Adding page-specific meta tags, like "Description" and "Keywords" is very important in SEO optimization. Meta tags could be added directly to the head section of the web pages, such as .html or plain .aspx,but it is less than trivial in case of .aspx page referring masterpage because the head section is included in master page, so by default all pages referring to it will share the same set of meta tags.

"HtmlMeta" is a class available in "System.Web.UI.HtmlControls" namespace, which allows to add page-specific meta tags to the .aspx pages referring the same masterpage from code behind.Following is the example for how to use this class This code snippet should be included in Page_Load event of.aspx page.

HtmlHead head = (HtmlHead)Page.Header;

HtmlMeta oMeta1 = new HtmlMeta();
oMeta1.Name = "Description";
oMeta1.Content = "this is the Page description";
head.Controls.Add(oMeta1);

HtmlMeta oMeta2 = new HtmlMeta();
oMeta2.Name = "Keywords";
oMeta2.Content = "Keyword1,Keyword2....";
head.Controls.Add(oMeta2);

For example if one page deals with .NET Articals, and another page deals with Java artical and both sharing the same master page, then code snippets are like below.

For .NET Articles Page

HtmlHead head = (HtmlHead)Page.Header;

HtmlMeta oMeta1 = new HtmlMeta();
oMeta1.Name = "Description";
oMeta1.Content = "this is the .NET Page description";
head.Controls.Add(oMeta1);

HtmlMeta oMeta2 = new HtmlMeta();
oMeta2.Name = "Keywords";
oMeta2.Content = "C#.NET,ASP.NET,Ajax,VB.NET,OOPs,Microsoft";
head.Controls.Add(oMeta2);

For Java Articles Page

HtmlHead head = (HtmlHead)Page.Header;

HtmlMeta oMeta1 = new HtmlMeta();
oMeta1.Name = "Description";
oMeta1.Content = "this is the Java Page description";
head.Controls.Add(oMeta1);

HtmlMeta oMeta2 = new HtmlMeta();
oMeta2.Name = "Keywords";
oMeta2.Content = "Java,Oracle,Sun,OOPs,J2EE";
head.Controls.Add(oMeta2);

Convert String into Title Case

2011-12-14T10:28:00.000+05:30

To convert a string into title case, use the following code

System.Globalization.TextInfo objTextInfo = new System.Globalization.CultureInfo("en-US").TextInfo;
objTextInfo.ToTitleCase(sString.ToLower());

Now Listen Posts From Gopi's Portal

2011-11-25T14:41:00.000+05:30

Hi All!
Are you feel boring to read posts, No problem from now on, you can listen posts instead of reading. While listening, you can do other tasks as well. You can navigate posts by clicking on Next and Previous buttons. Check it:

Thanks to iSpeech for giving this wonderful gadget.

Search in All Stored Procedures of a Database

2011-11-25T14:06:00.000+05:30

Some times to search for all the Stored Procedures having a given text in its definition. Then we can query like below to get the results

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%SearchWord%'

How to debug Windows Service Without installing it

2011-10-31T10:50:00.010+05:30

While developing a Windows service if you want to debug or run it will give you the following message.

"Cannot start service from the command line or a debugger.A Windows Service must first be installed (using installutil.exe) and then started with the ServerExplorer, Windows Services Administrative tool or the NET START command."

So for debugging you first install the service, but it is a long process because every time you make changes, you need to reinstall your service and debug it again.

Here is the solution for avoiding this long process.

For debugging your service without installing it, make changes in Program.cs like this.
Suppose if your Program.cs file is

static class Program
{
static void Main()
{
ServiceBase[] ServicesToRun;
ServicesToRun = new ServiceBase[]
{
new MyWindowsService()
};
ServiceBase.Run(ServicesToRun);
}
}

Change the above code like below

static class Program
{
static void Main()
{
#if(!DEBUG)
ServiceBase[] ServicesToRun;
ServicesToRun = new ServiceBase[]
{
new MyWindowsService()
};
ServiceBase.Run(ServicesToRun);
#else
MyWindowsService myWindowsServ = new MyWindowsService();
myWindowsServ.RunService();

#endif
}
}

Here RunService is My Service function that initiates the OnStart Event of the Service.

Now if you run your service then it will not show you the above message. It simply runs the service. Now you can debug you application by simply adding the breakpoints.

Change Model's value in View on Postback

2011-10-24T17:05:00.000+05:30

In MVC, if you change any value of the model in the postback action, it won't reflect in the View when it is redisplayed. It is because of the design of the HTML Helpers.

For example, if you have a view like below

<% using (Html.BeginForm()) { %>
<%= Html.TextBoxFor(m => m.FirstName) %>

<%= Html.TextBoxFor(m => m.LastName) %>
<input type="submit" value="OK" />
<% } %>

which you are posting to the following action:

[HttpPost]
public ActionResult Sample(SampleModel model)
{
model.FirstName = "Krish";
model.LastName = "S";
return View(model);
}

Here the 'FirstName' Property of the model is changed in the Action. But, when the view is redisplayed the old value will be used.

To avoid this remove the value from the 'ModelState'.So it will rebuild the control agin in the view with new data.

[HttpPost]
public ActionResult Sample(SampleModel model)
{
ModelState.Remove("FirstName");
ModelState.Remove("LastName");
model.FirstName = "Krish";
model.LastName = "S";
return View(model);
}

Extended Properties for Excel Connection String

2011-10-19T20:53:00.004+05:30

While Reading from Excel, we have two properties which help us to read correct data from excel sheet. Those are

HDR
"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

IMEX
"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text.
Note that this option might affect excel sheet write access negative.

Below is the Connection string to read from Excel sheet, which shows the usage of the above

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 12.0;HDR=Yes;IMEX=1";

I.e. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets.

While reading from excel sheet, by default it uses only the first 8 rows to guess the column datatype.
We can change this behavior by setting the value 0 to the registry key

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel] located registry REG_DWORD "TypeGuessRows".

This might hurt performance.
Please also note that adding the IMEX=1 option might cause the IMEX feature to set in after just 8 rows. Use IMEX=0 instead to be sure to force the registry TypeGuessRows=0 (scan all rows) to work.

Conditionally disable a Control in ASP.NET MVC

2011-10-14T15:41:00.004+05:30

In MVC, you can disable a control based on some property from the model using the following

<%: Html.TextBoxFor(m => m.date2,Model.VoiceMessage? null: new { @disabled = true })%>

Here, I am disabling the textbox based on the "VoiceMessage" field. It adds the "disabled" attribute, if "VoiceMessage" value is false.
If any other attributes are present then you can write like below

<%: Html.TextBoxFor(m => m.date2, Model.VoiceMessage?(object) new { @id = "textbox1" } : (object)new { @id = "textbox1",@disabled=true })%>

Detect Web Request device for Mobile

2011-10-13T15:45:00.001+05:30

Today most of the websites have mobile websites. Hence when mobile users go to main webpage,it should be redirected to their mobile site.
So we need to write a small piece of code in main webpage to detect whether the user is from PC or mobile device .If the user is detected to be from mobile, we can redirect to its corresponding mobile website. We can detect it using the "HTTP_USER_AGENT" data available in the user agent.
Below C#.net snippet checks whether the user is from mobile or PC

string u = Request.ServerVariables["HTTP_USER_AGENT"];

System.Text.RegularExpressions.Regex browser = new System.Text.RegularExpressions.Regex(@"android|avantgo|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\\/|plucker|pocket|psp|symbian|treo|up\\.(browser|link)|vodafone|wap|windows ce|phone)|xda|xiino", System.Text.RegularExpressions.RegexOptions.IgnoreCase | System.Text.RegularExpressions.RegexOptions.Multiline);

System.Text.RegularExpressions.Regex agent = new System.Text.RegularExpressions.Regex(@"1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\\-m|r|s)|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\\-(n|u)|c55\\/|capi|ccwa|cdm\\-|cell|chtm|cldc|cmd\\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\\-s|devi|dica|dmob|do(c|p)o|ds(12|\\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\\-|_)|g1 u|g560|gene|gf\\-5|g\\-mo|go(\\.w|od)|gr(ad|un)|haie|hcit|hd\\-(m|p|t)|hei\\-|hi(pt|ta)|hp( i|ip)|hs\\-c|ht(c(\\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\\-(20|go|ma)|i230|iac( |\\-|\\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\\/)|klon|kpt |kwc\\-|kyo(c|k)|le(no|xi)|lg( g|\\/(k|l|u)|50|54|e\\-|e\\/|\\-[a-w])|libw|lynx|m1\\-w|m3ga|m50\\/|ma(te|ui|xo)|mc(01|21|ca)|m\\-cr|me(di|rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\\-| |o|v)|zz)|
mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\\-on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\\-2|po(ck|rt|se)|prox|psio|pt\\-g|qa\\-a|qc(07|12|21|32|60|\\-[2-7]|i\\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\\-|oo|p\\-)|sdk\\/|se(c(\\-|0|1)|47|mc|nd|ri)|sgh\\-|shar|sie(\\-|m)|sk\\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\\-|v\\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\\-|tdg\\-|tel(i|m)|tim\\-|t\\-mo|to(pl|sh)|ts(70|m\\-|m3|m5)|tx\\-9|up(\\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\\-| )|webc|whit|wi(g|nc|nw)|wmlb|wonu|x700|xda(\\-|2|g)|yas\\-|your|zeto|zte\\-", System.Text.RegularExpressions.RegexOptions.IgnoreCase | System.Text.RegularExpressions.RegexOptions.Multiline);

if ((browser.IsMatch(u) || agent.IsMatch(u.Substring(0, 4))))
{
Response.Redirect("Mobile Site address");
}
else
{
Response.Redirect("PC Site address");
}

Query to Find Column From All Tables of Database

2011-05-26T14:01:00.000+05:30

Sometimes we need to find whether a column exists in any of the table in the entire database. If the tables count is smaller like 10 or 20, then we can find it with in few seconds or minutes. But if count is very large and each table has many no of columns then it becomes takes long time.

The following query returns all the table names in the database which have the given column name with in few seconds.

USE dbName
GO

SELECT SCHEMA_NAME(schema_id) AS SchemaName
,T.name AS TableName
,C.name AS ColumnName
FROM sys.tables AS T
INNER JOIN sys.columns C ON T.OBJECT_ID = C.OBJECT_ID
WHERE C.name='ColumnName'
ORDER BY SchemaName, TableName,C.column_id;

Restore a Database from the SQL Command

2011-01-19T17:36:00.000+05:30

Assume your Database "SampleDB" has full backup SampleDB.bak. It can be restored using following steps. Run this queries in the maste database.

1) Retrive the Logical file name of the database from backup.

RESTORE FILELISTONLY
FROM DISK = 'E:SampleDBBackupfile.bak'

2) Use the values in the LogicalName Column in following Step.

-- Make Database to single user Mode
ALTER DATABASE SampleDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE

-- Restore Database
RESTORE DATABASE SampleDB
FROM DISK = 'E:SampleDBBackupfile.bak'
WITH MOVE 'MDFLogicalName' TO 'D:SampleDBDataFile.mdf',
MOVE 'LDFLogicalName' TO 'D:SampleDBLDFFile.ldf',
REPLCE

/* Please run below statement if any error occures in the above Statement */
-- Convert Database again to Multi User Mode
ALTER DATABASE SampleDB SET MULTI_USER

In the above RESTORE Statement 'MDFLogicalName' and 'LDFLogicalName' are the logical names of the backup file which can be retrived from Step 1.

'D:SampleDBDataFile.mdf' and 'D:SampleDBLDFFile.ldf' are the physical File paths for the SampleDB.

Reference : blog.sqlauthority.com

Adding Parameter dynamically to the Entity Framework query

2010-12-28T14:17:00.001+05:30

We can pass the parameters dynamically to a entity framework where clause. Below is the code snippet for passing the parameters dynamically...

//Declare the instances for the Entities and ObjectParameter collection
MTEntities objMT = new MTEntities();
List ob = new List();

//Declare the query holder variable
string strDyn = "";

//Build the query based on the selected used inputs
if(txtName.text !="")
{
strDyn += "it.Organization =@Organization";
//Add the object parameter into the collection
ob.Add(new ObjectParameter("Organization", txtName.Text));
}

if(txtGuide.Text != "")
{
strDyn = strDyn.Length == 0 ? strDyn + "And" : strDyn;
strDyn += "it.CityName= @city";
ob.Add(New ObjectParameter("city", txtCity.Text));
}

// repeat the above if block for all the parameters you need to pass to the query
if (strDyn.Length > 0)
{
if (strDyn.EndsWith("And"))
strDyn = strDyn.Remove(strDyn.Length, -3); //Removes the Last 'And'
var query = objMT.MT_tblOrganizations.Where(strDyn, ob.ToArray()).Select(O => new { O.CreatedDate, O.OrganizationID, O.Organization, O.Verticals, O.Offerings, O.WebsiteURL});

//Execute and assign the result to the gridview
MyGridview.DataSource = query;
MyGridview.DataBind();
}

Gradient Fill Style for buttons and backgrounds

2010-12-14T11:29:00.004+05:30

We can apply Gradient Style for the Buttons and backgrounds easily.

Just add the below style to your application.

It is working fine in IE, Mozilla Firfox and Google chrome

.GradientFill
{
   filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#FdE0c0', endColorstr='#ffffff'); /* for IE */
   background: -webkit-gradient(linear, left top, left bottom, from(#FdE0c0), to(#fff)); /* for webkit browsers */
   background: -moz-linear-gradient(top, #FdE0c0, #fff); /* for firefox 3.6+ */
}

ASP.NET Security Vulnerability found

2010-09-25T15:12:00.003+05:30

According to Microsoft Security Advisory , "Microsoft is investigating a new public report of a vulnerability in ASP.NET. An attacker who exploited this vulnerability could view data, such as the View State, which was encrypted by the target server, or read data from files on the target server, such as web.config. This would allow the attacker to tamper with the contents of the data. By sending back the altered contents to an affected server, the attacker could observe the error codes returned by the server."
Please check the below links for more information about this.
1 ) Important: ASP.NET Security Vulnerability
2) Understanding the ASP.NET Vulnerability
3) ASP.NET POET Vulnerability - What Else Can I Do?
4) Oracle Padding Vulnerability in ASP.NET

Visual Studio Keyboard Shortcut Posters

2010-09-14T11:54:00.019+05:30

Here is a collection of .NET Framework and Visual Studio Posters available for free. The .NET Framework posters can be used to find important class library details and relationships in the .NET Framework.

Visual C# Shortcut Posters
Visual Studio 2005 Shortcuts
Visual Studio 2008 Shortcuts
Visual Studio 2010 Shortcuts

Visual Basic Shortcut Posters
Visual Studio 2005 Shortcuts
Visual Studio 2008 Shortcuts
Visual Studio 2010 Shortcuts

Visual C++ Shortcut Posters

Visual Studio 2005 Shortcuts

Visual Studio 2008 Shortcuts

Visual Studio 2010 Shortcuts

.NET Framework 3.5 Common Namespaces and Types Poster: The .NET Framework 3.5 Common Namespaces and Types Poster is downloadable as XPS or PDF format.

C# Language Specification 4.0: It is the Word document containing all the basic specifications of C# Language.

Thanks!..

View your mobile screen on your desktop

2010-09-09T19:03:00.011+05:30

Check the below link to view your mobile screen on your desktop.

MyMobiler

By using this tool, you can

View your mobile screen on your desktop.
Control your mobile by using desktop keyboard and mouse.
Copy/Cut/Paste text between mobile and desktop.
Capture mobile screen.
Drag and drop files to your mobile.
Support Mobile Explorer (File Browse)

Generating Comma Seperated List Using SELECT Clause From Table Column

2010-09-09T18:41:00.007+05:30

Following script will Generate comma separate values or comma separate list from tables.

Method 1):
DECLARE @CSV VARCHAR(MAX)
SELECT @CSV= COALESCE(@CSV+ ',', '') + < Column Name >
FROM <TableName >
WHERE <Condition >
SELECT @CSV

Method 2) :
DECLARE @Result AS VARCHAR(2000)
SET @Result = ''
SELECT @Result = < Column Name >+', '+ @Result
FROM <TableName >
WHERE <Condition >

SET @Result=SUBSTRING(@Result,0,LEN(@Result))
SELECT @Result

Example:
Below query gives "CourseName" as a table

SELECT CourseName
FROM Courses

Output:

CourseName
------------
ASP.NET
SQL Server 2005
Java
MVC

If you give the following query, it will returns the data as a comma seperated values

DECLARE @CSV VARCHAR(MAX)
SELECT @CSV= COALESCE(@CSV+ ',', '') + CourseName
FROM Courses
SELECT @CSV

Output:
ASP.NET,SQL Server 2005,Java,MVC

In the above methods First method is the efficient one. Because

COALESCE function deals with the null values.

COALESCE() :
According to MSDN, coalesce returns the first non-null expression among its arguments.
COALESCE() accepts a series of values and a value to use in the event that all items in the list are null; then, it returns the first not-null value

Fixing Error Messages Problem in windows CE

2010-09-08T19:53:00.002+05:30

With .Net Compact Framework 3.5 the resources that display error messages are not loaded onto device by default. So our application always shows the following message, instead of original message

"An error message is available for this exception but cannot be displayed because these messages are optional and are not currently installed on this device. Please install 'NETCFv35.Messages.EN.wm.cab' for Windows Mobile 5.0 and above or 'NETCFv35.Messages.EN.cab' for other platforms. Restart the application to see the message."

This 'NETCFv35.Messages.EN.wm.cab' can be found in the directory

C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\WindowsCE\DiagnosticsNETCFv35.Messages.EN.wm.cab (English messages)

If after doing this also you get the following message when an exception message is displayed, do the following

1) Open the 'NETCFv35.Messages.EN.wm.cab' file available in the above location with winzip or any cab extractor
2) Extract the file named "SYCCFA~1.001" and rename it "System.SR.dll"
3) Add System.SR.dll as a reference to your project
4) Deploy the application.

Then the application shows the correct exception messages.

Lock your folder with a batch file

2010-09-04T17:14:00.002+05:30

You can make the folder lock software by your own.
Just Copy and paste the following code into a notepad and save it as a batch file (i.e. with ".bat" extension).
Then close the notepad and click the batch file. It creates a folder with name "Locker" in the same location.
Now paste all the folders and files which you want to hide into the "Locker" folder. Double click the batch file and enter 'y' or 'Y' to lock the folder. It will locks your folder.
If you want to unlock your folder, double click the batch file again and you would be prompted for password.
Enter the password and access your files

if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK
if NOT EXIST Locker goto MDLOCKER
:CONFIRM
echo Are you sure u want to Lock the folder(Y/N)
set/p "cho=>"
if %cho%==Y goto LOCK
if %cho%==y goto LOCK
if %cho%==n goto END
if %cho%==N goto END
cls
echo Invalid choice.
goto CONFIRM
:LOCK
ren Locker "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
attrib +h +s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
cls
echo Folder locked
goto End
:UNLOCK
echo Enter password to Unlock folder
set/p "pass=>"
if NOT %pass%=="your password" goto FAIL
attrib -h -s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
ren "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" Locker
cls
echo Folder Unlocked successfully
goto End
:FAIL
cls
echo Invalid password
goto UNLOCK
:MDLOCKER
md Locker
cls
echo Locker created successfully
goto End
:End

In the above code change the "your password" with your password before saving as batch file(remove the double quotes also) It is the password to unlock your folder

Run Firefox inside Firefox

2010-09-04T15:25:00.002+05:30

How about opening a Firefox in Firefox window?
Not bad .. and it's very easy too....
Just type the following URL in the Firefox address bar

chrome://browser/content/browser.xul

Following is the screen shot of that one

Enjoy the trick....

Controlling a Windows Service from .NET Application

2010-08-03T17:16:00.001+05:30

You can use the ServiceController component to connect to and control the behavior of existing services. When you create an instance of the ServiceController class, you set its properties so that it interacts with a specific Windows service.

This class is available in namespace
"System.ServiceProcess"

First we need to create object for this class like below

ServiceController oService = new ServiceController("DataImportService");

Here "DataImportService" is the Service Name in my system.

Below are the methods to start,stop,Pause and Continue the services.

oService.Start();

oService.Stop();

oService.Pause();

oService.Continue();

At any time the service is in one of the below state

ContinuePending

Paused

PausePending

Running

StartPending

Start

Stopped

StopPending

We can know the status of the service also using status property

if (service.Status == ServiceControllerStatus.Stopped)

service.Start();

above statement checks whether the service is stopped and if yes, it starts the service.

if (service.Status == ServiceControllerStatus.Running)

service.Stop();

Some times ASP.net Worker process doesnot have permission to stop or pause the services.For that we can check using CanStop,CanPauseAndContinue,CanShutdown

If(oService.CanStop)

oService.Stop();

We have another 2 useful overloaded methods

"WaitForStatus(ServiceControllerStatus desiredStatus)" and

"WaitForStatus(ServiceControllerStatus desiredStatus,TimeSpan timeout)" .

First method Infinitely waits for the service to reach the specified status, and

the second method Waits for the service to reach the specified status or for the specified time-out to expire.

oService.WaitForStatus(ServiceControllerStatus.Stopped)

It waits until the Service is Stopped.

oService.WaitForStatus(ServiceControllerStatus.Stopped, TimeSpan.FromMinutes(5));

It waits until the Service is Stopped for fiveminutes. After five minutes it gives an Timeout Exception.

SQL Server Date Time Conversion Formats

2010-08-02T17:16:00.004+05:30

Below are the basic formats for converting the date time values into varchar in SQL Server 2005

SELECT convert(varchar, getdate(), 100) -- mon dd yyyy hh:mmAM (or PM)
-- Aug 2 2010 11:01AM
SELECT convert(varchar, getdate(), 101) -- mm/dd/yyyy - 08/02/2010
SELECT convert(varchar, getdate(), 102) -- yyyy.mm.dd - 2010.08.02
SELECT convert(varchar, getdate(), 103) -- dd/mm/yyyy
SELECT convert(varchar, getdate(), 104) -- dd.mm.yyyy
SELECT convert(varchar, getdate(), 105) -- dd-mm-yyyy
SELECT convert(varchar, getdate(), 106) -- dd mon yyyy
SELECT convert(varchar, getdate(), 107) -- mon dd, yyyy
SELECT convert(varchar, getdate(), 108) -- hh:mm:ss
SELECT convert(varchar, getdate(), 109) -- mon dd yyyy hh:mm:ss:mmmAM (or PM)
-- Aug 2 2010 11:02:44:013AM
SELECT convert(varchar, getdate(), 110) -- mm-dd-yyyy
SELECT convert(varchar, getdate(), 111) -- yyyy/mm/dd

SELECT convert(varchar, getdate(), 112) -- yyyymmdd ( ISO date format ,international standard - works with any language setting)
SELECT convert(varchar, getdate(), 113) -- dd mon yyyy hh:mm:ss:mmm
-- 02 Aug 2010 11:02:07:577
SELECT convert(varchar, getdate(), 114) -- hh:mm:ss:mmm(24h)
SELECT convert(varchar, getdate(), 120) -- yyyy-mm-dd hh:mm:ss(24h)
SELECT convert(varchar, getdate(), 121) -- yyyy-mm-dd hh:mm:ss.mmm
SELECT convert(varchar, getdate(), 126) -- yyyy-mm-ddThh:mm:ss.mmm
-- 2010-08-02T10:52:47.513

DateTime conversions - Without century (YY)

SELECT convert(varchar, getdate(), 0) -- mon dd yyyy hh:mmAM (or PM)
SELECT convert(varchar, getdate(), 1) -- mm/dd/yy
SELECT convert(varchar, getdate(), 2) -- yy.mm.dd
SELECT convert(varchar, getdate(), 3) -- dd/mm/yy
SELECT convert(varchar, getdate(), 4) -- dd.mm.yy
SELECT convert(varchar, getdate(), 5) -- dd-mm-yy
SELECT convert(varchar, getdate(), 6) -- dd mon yy
SELECT convert(varchar, getdate(), 7) -- mon dd, yy
SELECT convert(varchar, getdate(), 8) -- hh:mm:ss
SELECT convert(varchar, getdate(), 9) -- mon dd yyyy hh:mm:ss:mmmAM (or PM)
SELECT convert(varchar, getdate(), 10) -- mm-dd-yy
SELECT convert(varchar, getdate(), 11) -- yy/mm/dd
SELECT convert(varchar, getdate(), 12) -- yymmdd
SELECT convert(varchar, getdate(), 13) -- dd mon yyyy hh:mm:ss:mmm
SELECT convert(varchar, getdate(), 14) -- hh:mm:ss:mmm(24h)
SELECT convert(varchar, getdate(), 20) -- yyyy-mm-dd hh:mm:ss(24h)
SELECT convert(varchar, getdate(), 21) -- yyyy-mm-dd hh:mm:ss.mmm
SELECT convert(varchar, getdate(), 22) -- mm/dd/yy hh:mm:ss AM (or PM)
SELECT convert(varchar, getdate(), 23) -- yyyy-mm-dd
SELECT convert(varchar, getdate(), 24) -- hh:mm:ss
SELECT convert(varchar, getdate(), 25) -- yyyy-mm-dd hh:mm:ss.mmm

Different date styles with SQL string functions

SELECT replace(convert(varchar, getdate(), 111), '/', ' ') -- yyyy mm dd
SELECT convert(varchar(7), getdate(), 126) -- yyyy-mm
SELECT right(convert(varchar, getdate(), 106), 8) -- mon yyyy
SELECT substring(convert(varchar, getdate(), 120),6, 11) -- mm-dd hh:mm

Select Distinct Rows from a DataTable

2010-07-28T16:05:00.003+05:30

In ADO.NET 2.0 there is a feature that allows you to create a new table containing the distinct entries from an existing table like below.

DataTable distinctTable = originalTable.DefaultView.ToTable( /*distinct*/ true)

It gets all the distinct rows from the original Table.
If you want only a single column we can use...

DataTable distinctTable = originalTable.DefaultView.ToTable( /*distinct*/ true, /*Column Name*/ "Col1")