C#: How to Get Machine name of the webserver

Here is how you can do using C#,

Response.Write("machinename " +System.Environment.MachineName +"<BR>" )

This gives you name computer where your webserver is located.

If you need with the domain name here is how you can achieve using the following code snippet:

You need to import following namespace to use this,

using System.Net; 

public static string GetServerMachineName()
{            
    string domainName = System.Net.NetworkInformation.IPGlobalProperties.GetIPGlobalProperties().DomainName;
    string hostName = Dns.GetHostName();
    string sysdn = "";
    if (!hostName.Contains(domainName))
        sysdn = hostName + "." + domainName;
    else
        sysdn = hostName;

    return sysdn;
}

Happy Coding

How to: change DB owner name using T-SQL

Here is how you can do it using SQL Statement.

Method 1:

Using this method first we’ll get all the db objects and update with new db owner name.

DECLARE tabcurs CURSOR
FOR
    SELECT 'olddbowner.' + [name]
      FROM sysobjects
     WHERE xtype = 'u'

OPEN tabcurs
DECLARE @tname NVARCHAR(517)
FETCH NEXT FROM tabcurs INTO @tname

WHILE @@fetch_status = 0
BEGIN

    EXEC sp_changeobjectowner @tname, 'dbo'

    FETCH NEXT FROM tabcurs INTO @tname
END
CLOSE tabcurs
DEALLOCATE tabcurs

Method 2:

This approach is simple and straight forward. Using this we will build the statements and you can copy them from the result window and execute

declare @OldOwner varchar(100) declare @NewOwner varchar(100) 
set @OldOwner = '353446_eda_db' 
set @NewOwner = 'dbo' 


SELECT 'sp_changeobjectowner ''[' + s.name + '].[' + p.name + ']'', ''' + @NewOwner + '''
 GO'
FROm sys.Procedures p INNER JOIN 
sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = @OldOwner
union
select 'sp_changeobjectowner ''[' + table_schema + '].[' + table_name + ']'', ''' + @NewOwner + '''
 GO'
 from information_schema.tables where Table_schema = @OldOwner

Hope this helps.

Regex validate Email address C#

This is how we can validating email address through C# using Regular Expression. Here is the sample code,

using System.Text.RegularExpressions;

public bool vaildateEmail(string useremail)
{
    bool istrue = false;
    Regex reNum = new Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
    CaptureCollection cc = reNum.Match(useremail).Captures;
    if (cc.Count == 1)
    {
        istrue = true;
    }
    return istrue;
}

Delete All Files using C#

For Deleting all the files first you need to get the list of file names from the specified directory (using static method Directory.Get­Files. Then delete all files from the list.

Method 1

using System.IO;

string[] filePaths = Directory.GetFiles(@"c:\Directory\");
foreach (string filePath in filePaths)
  File.Delete(filePath)

Method 2

To Delete all files using one code line, you can use Array.ForEach with combination of anonymous method.

Array.ForEach(Directory.GetFiles(@"c:\MyDirectory\"),delegate(string path) 
{ File.Delete(path); });

Convert DateTime values to W3C DateTime format in C#

ConvertDateToW3CTime() function takes a C# DateTime value and converts it to a W3C formatted date/time value.
The function works by first converting the date/time parameter to a UTC (Coordinated Universal Time) value and formatting it. It then appends the UTC offset time to the previously formatted string.

The T placed between the date and time simply indicates that the numbers following it are Time values. The UTC offset can be one 3 states, zero e.g. there is not difference in time between the UTC value and the local value. A zero value is identified by simply appending the letter Z to the end of the formatted datetime value. If the offset time is greater than 0 then it is preceded with a + sign, e.g. 2 hours and 30 minutes over the UTC time would be written as +02:30. If the offset is less than the UTC value then it is preceded with a – sign e.g. -01:00.

/// <summary>
/// Converts a datetime value to w3c format
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public static string ConvertDateToW3CTime(DateTime date)
{
    //Get the utc offset from the date value
    var utcOffset = TimeZone.CurrentTimeZone.GetUtcOffset(date); 
    string w3CTime = date.ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss");
    //append the offset e.g. z=0, add 1 hour is +01:00
    w3CTime += utcOffset == TimeSpan.Zero ? "Z" :
        String.Format("{0}{1:00}:{2:00}", (utcOffset > TimeSpan.Zero ? "+" : "-")
        , utcOffset.Hours, utcOffset.Minutes);
 
    return w3CTime;
}

Here is an example, how to use it

ConvertDateToW3CTime(DateTime.Now);
//Output 2011-10-17T19:10:48+01:00

Date Formatting in C#

Date formatting in C# using string object

Specifier	Description	Output
d	Short Date	20/10/1983
D	Long Date	20 October 1983
t	Short Time	21:20
T	Long Time	21:20:59
f	Full date and time	20 October 1983 21:20
F	Full date and time (long)	20 October 1983 21:20:59
g	Default date and time	20/10/1983 21:20
G	Default date and time (long)	20/10/1983 21:20:59
M	Day / Month	20 October
r	RFC1123 date	Thu, 20 Apr 1983 21:20:59 GMT
s	Sortable date/time	1983-10-20T21:20:59
u	Universal time, local timezone	1983-10-20 21:20:59Z
Y	Month / Year	October 1983
dd	Day	20
ddd	Short Day Name	Thu
dddd	Full Day Name	Thursday
hh	2 digit hour	09
HH	2 digit hour (24 hour)	21
mm	2 digit minute	20
MM	Month	10
MMM	Short Month name	Apr
MMMM	Month name	October
ss	seconds	59
tt	AM/PM	PM
yy	2 digit year	07
yyyy	4 digit year	1983
:	seperator, e.g. {0:hh:mm:ss}	09:20:59
/	seperator, e.g. {0:dd/MM/yyyy}	20/10/1983

Example using the specifier with data object

DateTime now = DateTime.Now;
Console.WriteLine(now.ToString("d"));

JavaScript: Display Clock

Displaying a clock is very similar to making a countdown timer. All we have to do is to create a new date and get it's hours, minutes, and seconds.

Here is a example:

<!-- This span is where the clock will appear -->
<div id='clockDiv'></div>
<script type="text/javascript">
function clock() {
   var now = new Date();
   var outStr = now.getHours()+':'+now.getMinutes()+':'+now.getSeconds();
   document.getElementById('clockDiv').innerHTML=outStr;
   setTimeout('clock()',1000);
}
clock();
</script>

Hope this helps :-)