How to write WhoIs domain

you can easily send Query to http://www.directnic.com/whois/?query=badragheh.com

and then get the response and show it in your blog.

Show number of active database connections in SQL Server

one of common problems in Sql serverl is pool over because of open connections are not closed.

sp_who2 will help you to see open connections to your SQL database engine.

this is screenshot of the result of the run



SELECT @@MAX_CONNECTIONS AS 'Max Allowed Connections'

to have select query on sp_who to see the connection of specific database

SELECT SPID, STATUS, PROGRAM_NAME, LOGINAME=RTRIM(LOGINAME), HOSTNAME, CMD FROM MASTER.DBO.SYSPROCESSES WHERE DB_NAME(DBID) = 'DB_Name' AND DBID != 0

Sleep in C#.net

Thread.Sleep Method
system.threading.thread.sleep(int32 milisecond)

Create loading icon online

you can easily create your Ajax loading icon from here http://www.ajaxload.info/

How to write sharp # in Latex

if you want to write C#.net in csharp in unicode just write C\#.net

MD5 C#.NET hash funciton

public static string Md5(string strChange)
{
//Declarations
Byte[] originalBytes;
Byte[] encodedBytes;
MD5 md5;

md5 = new MD5CryptoServiceProvider();
originalBytes = ASCIIEncoding.Default.GetBytes(strChange);
encodedBytes = md5.ComputeHash(originalBytes);



//Convert encoded bytes back to a 'readable' string

string result = BitConverter.ToString(encodedBytes);
return result;

}

Encode and Decode function in C#

public string base64Encode(string data)
{
try
{
byte[] encData_byte = new byte[data.Length];
encData_byte = System.Text.Encoding.UTF8.GetBytes(data);
string encodedData = Convert.ToBase64String(encData_byte);
return encodedData;
}
catch(Exception e)
{
throw new Exception("Error in base64Encode" + e.Message);
}
}

public string base64Decode(string data)
{
try
{
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
System.Text.Decoder utf8Decode = encoder.GetDecoder();

byte[] todecode_byte = Convert.FromBase64String(data);
int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);
char[] decoded_char = new char[charCount];
utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);
string result = new String(decoded_char);
return result;
}
catch(Exception e)
{
throw new Exception("Error in base64Decode" + e.Message);
}
}

iContact for Windows Mobile Pocket PC 5 / 6

iContact is a simple contacts applications for your Windows Mobile device which will help you scroll your contact list in iPhone style by sliding down your finger in the screen.




Download

Email Extractor from text file

a tiny DOS command program to extract Email from text file.
download link
PS: you can download free version here

Get Directory Name in Windows Mobile in C#.net

in C#.net if you try
string dr = System.IO.Path.GetDirectoryName();
this will not work, so you have to use this

System.IO.Path.GetDirectoryNameSystem.IO.Path.
GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

which returns the directory.

Change Master page in Runtime ASP.NET 2

the lable lblName is in MasterPage and you want to change it in Code behind.

Label Mylabel = (Label)Master.FindControl("lblName");
Mylabel.Text = "New Text";

How to add search to blogger

<form id="searchthis" action="http://www.softminer.net/search" style="display:inline;" method="get">

<input id="b-query" maxlength="255" name="q" size="20" type="text"/>

<input id="b-searchbtn" value="Search" type="submit"/>

form>

Download Microsoft SQL Server 2008 Enterprise Evaluation

Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for Developers


Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for IT Professionals

Start with Latex

Update 2023 VS code can be used as Editor Installation 

Prequisit:Basic Miktext arround 138 MB 

VS Code 

 VS extension: Latext Workshop 

 Hint: Run VS as Administrator  & No need for PERL

 1.Download TexMaker ( Free Latex Editor ) from http://www.xm1math.net/texmaker/download.html

2.Download "Basic MiKTeX 2.7" Installer Size: 82.33 MB from http://miktex.org/2.7/setup


3. Run TexMaker and Set the configuration of MikTex ( by default every thing should work)

PS: I tested all in Windows XP and I just installed and run

How to add Created and Modified to SQL server tables using Trigger

1. to add Created and Modified column to Table
2. add Update trigger
3. add Insert trigger

ALTER TABLE Table1
ADD Created datetime null,Modified datetime null
go

CREATE TRIGGER [TriggerUpdate]
ON [dbo].[Table1]
FOR UPDATE
AS
update Table1 set Modified = getdate() where Id in (SELECT Id FROM inserted)
go

CREATE TRIGGER [TriggerInsert]
ON [dbo].[Table1]
FOR INSERT
AS
update Table1 set Created= getdate() where Id in (SELECT Id FROM inserted)

Best Employer 2008 Germany

source audimax Dez 2008

Sizer - Web design

to see your browser in different size just intall this small program called sizer
http://www.brianapps.net/sizer.html