jQuery Examples

// ajax callback functions
success(data, textStatus, jqXHR)
A function to be called if the request succeeds.

error(jqXHR, textStatus, errorThrown)
A function to be called if the request fails.

complete(jqXHR, textStatus)
A function to be called when the request finishes
(after success and error callbacks are executed).

How to sned mail using gmail SMTP in c#

string subject = "gmail test ";
        string message = "<h3>test sending gmail message content in HTML body</h3>";
        MailMessage mailMsg = new MailMessage();
        mailMsg.From = new System.Net.Mail.MailAddress("sender@gmail.com", "display name", System.Text.Encoding.UTF8);
        mailMsg.To.Add(new MailAddress("reciver@gmail.com"));
        mailMsg.SubjectEncoding = System.Text.Encoding.UTF8;
        mailMsg.BodyEncoding = Encoding.UTF8;
        //
        mailMsg.Subject = subject;
        mailMsg.Body = message;
        mailMsg.IsBodyHtml = true;
        System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient();
        // user name and password to SMTP
        client.Credentials = new System.Net.NetworkCredential("sender", "1234");
        //gmail smtp port: 587
        client.Port = 587;
        client.Host = "smtp.gmail.com";
        // gmail required SSL
        client.EnableSsl = true;
        client.Send(mailMsg);

How to Export & Import Database Schema with all data and object to script file

SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

How to disable IE prompt message: A script is accessing some software (an ActiveX control) on this page which has been marked safe for scripting

the marked safe for scripting which means some activeX control have been authenticated by Microsoft, therefor 
Microsoft marked it as a safe script and you can use it less risk.

How to disable message prompt to you
in Internet Explorer menu
1. Tools -> Internet Options
2. Security Tab
3. Select a zone to Internet
4. Custom level
5. ActiveX controls and plug-ins
       Script ActiveX controls marked safe for scripting

Convert List or Array to String

// Sample 1
StringBuilder builder = new StringBuilder();
foreach (string value in array)
{
    builder.Append(value);
    builder.Append(',');
}

// Sample 2

string result = string.Join(",", array);

List all the columns in the database which are used as identity key

-- List all columns which are used as identity key
-- sample1
SELECT SCHEMA_NAME(schema_id) AS schema_name,
t.name AS table_name,
c.name AS column_name
FROM sys.tables AS t
JOIN sys.identity_columns c ON t.OBJECT_ID = c.OBJECT_ID
ORDER BY schema_name, table_name;

-- On/Off to disable identity key constrain

SET IDENTITY_INSERT [MyTableName] ON;
....
SET IDENTITY_INSERT [MyTableName] OFF;


source from: http://blog.sqlauthority.com/2008/03/29/sql-server-2005-list-all-column-with-indentity-key-in-specific-database/

Query Data Type, Length and other information of table columns

--Query Data Type, Length and other information of table columns
SELECT
OBJECT_NAME(c.OBJECT_ID) TableName
,c.name AS ColumnName
,SCHEMA_NAME(t.schema_id) AS SchemaName
,t.name AS TypeName
,t.is_user_defined
,t.is_assembly_type
,c.max_length
,c.PRECISION
,c.scale
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
WHERE OBJECT_NAME(c.OBJECT_ID) = 'myTableName'
ORDER BY c.OBJECT_ID;

-- Check Table Row Size and Sort by maximum size
-- SQL Server 2000 the Maximum Row Size limit is 8060 Bytes
SELECT OBJECT_NAME (sc.[id]) tablename
     , COUNT (1) nr_columns
     , SUM (sc.length) maxrowlength
  FROM syscolumns sc join sysobjects so on sc.[id] = so.[id]
 WHERE so.xtype = 'U'
 GROUP BY OBJECT_NAME (sc.[id])
 ORDER BY SUM (sc.length) desc