Saturday, August 29, 2009

MIME - File Context Types

Ai  application/postscript
aif  audio/x-aiff
aifc  audio/x-aiff
aiff audio/x-aiff
asc  text/plain
atom  application/atom+xml
au   audio/basic
avi   video/x-msvideo
bcpio   application/x-bcpio
bin   application/octet-stream
bmp   image/bmp
cdf   application/x-netcdf
cgm   image/cgm
class   application/octet-stream
cpio   application/x-cpio
cpt   application/mac-compactpro
csh   application/x-csh
css   text/css
dcr   application/x-director
dif   video/x-dv
dir   application/x-director
djv   image/vnd.djvu
djvu   image/vnd.djvu
dll   application/octet-stream
dmg   application/octet-stream
dms   application/octet-stream
doc   application/msword
dtd   application/xml-dtd
dv   video/x-dv
dvi   application/x-dvi
dxr   application/x-director
eps   application/postscript
etx   text/x-setext
exe   application/octet-stream
ez   application/andrew-inset
gif   image/gif
gram   application/srgs
grxml   application/srgs+xml
gtar   application/x-gtar
hdf   application/x-hdf
hqx   application/mac-binhex40
htm   text/html
html   text/html
ice   x-conference/x-cooltalk
ico   image/x-icon
ics   text/calendar
ief   image/ief
ifb   text/calendar
iges   model/iges
igs   model/iges
jnlp   application/x-java-jnlp-file
jp2   image/jp2
jpe   image/jpeg
jpeg   image/jpeg
jpg   image/jpeg
js   application/x-javascript
kar   audio/midi
latex   application/x-latex
lha   application/octet-stream
lzh   application/octet-stream
m3u   audio/x-mpegurl
m4a   audio/mp4a-latm
m4b   audio/mp4a-latm
m4p   audio/mp4a-latm
m4u   video/vnd.mpegurl
m4v   video/x-m4v
mac   image/x-macpaint
man   application/x-troff-man
mathml  application/mathml+xml
me   application/x-troff-me
mesh   model/mesh
mid   audio/midi
midi   audio/midi
mif   application/vnd.mif
mov   video/quicktime
movie   video/x-sgi-movie
mp2   audio/mpeg
mp3   audio/mpeg
mp4   video/mp4
mpe   video/mpeg
mpeg   video/mpeg
mpg   video/mpeg
mpga   audio/mpeg
ms   application/x-troff-ms
msh   model/mesh
mxu   video/vnd.mpegurl
nc   application/x-netcdf
oda   application/oda
ogg   application/ogg
pbm   image/x-portable-bitmap
pct   image/pict
pdb   chemical/x-pdb
pdf   application/pdf
pgm   image/x-portable-graymap
pgn   application/x-chess-pgn
pic   image/pict
pict   image/pict
png   image/png
pnm   image/x-portable-anymap
pnt   image/x-macpaint
pntg   image/x-macpaint
ppm   image/x-portable-pixmap
ppt   application/vnd.ms-powerpoint
ps   application/postscript
qt   video/quicktime
qti   image/x-quicktime
qtif   image/x-quicktime
ra   audio/x-pn-realaudio
ram   audio/x-pn-realaudio
ras   image/x-cmu-raster
rdf   application/rdf+xml
rgb   image/x-rgb
rm   application/vnd.rn-realmedia
roff   application/x-troff
rtf   text/rtf
rtx   text/richtext
sgm   text/sgml
sgml   text/sgml
sh   application/x-sh
shar   application/x-shar
silo   model/mesh
sit   application/x-stuffit
skd   application/x-koan
skm   application/x-koan
skp   application/x-koan
skt   application/x-koan
smi   application/smil
smil   application/smil
snd   audio/basic
so   application/octet-stream
spl   application/x-futuresplash
src   application/x-wais-source
sv4cpio application/x-sv4cpio
sv4crc  application/x-sv4crc
svg   image/svg+xml
swf   application/x-shockwave-flash
t    application/x-troff
tar   application/x-tar
tcl   application/x-tcl
tex   application/x-tex
texi   application/x-texinfo
texinfo application/x-texinfo
tif   image/tiff
tiff   image/tiff
tr   application/x-troff
tsv   text/tab-separated-values
txt   text/plain
ustar   application/x-ustar
vcd   application/x-cdlink
vrml   model/vrml
vxml   application/voicexml+xml
wav   audio/x-wav
wbmp   image/vnd.wap.wbmp
wbmxl   application/vnd.wap.wbxml
wml   text/vnd.wap.wml
wmlc   application/vnd.wap.wmlc
wmls   text/vnd.wap.wmlscript
wmlsc   application/vnd.wap.wmlscriptc
wrl   model/vrml
xbm   image/x-xbitmap
xht   application/xhtml+xml
xhtml   application/xhtml+xml
xls   application/vnd.ms-excel
xml   application/xml
xpm   image/x-xpixmap
xsl   application/xml
xslt   application/xslt+xml
xul   application/vnd.mozilla.xul+xml
xwd   image/x-xwindowdump
xyz   chemical/x-xyz
zip   application/zip 

Friday, August 28, 2009

Read - Write SMTP settings Web.Config with Asp.net runtime

//Read SMTP Settings

System.Configuration.Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
System.Net.Configuration.MailSettingsSectionGroup settings = (System.Net.Configuration.MailSettingsSectionGroup)config.GetSectionGroup("system.net/mailSettings");
txtSmtpHostAddr.Text = settings.Smtp.Network.Host;
txtSmtpUserName.Text = settings.Smtp.Network.UserName;
txtSmtpPortNo.Text = settings.Smtp.Network.Port.ToString();
txtSmtpEmail.Text = settings.Smtp.From;

//Write SMTP Settings

System.Configuration.Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
System.Net.Configuration.MailSettingsSectionGroup settings = (System.Net.Configuration.MailSettingsSectionGroup)config.GetSectionGroup("system.net/mailSettings");
settings.Smtp.Network.Host = txtSmtpHostAddr.Text.Trim();
settings.Smtp.Network.UserName = txtSmtpUserName.Text.Trim();
settings.Smtp.Network.Password = txtSmtpPassword.Text.Trim();
settings.Smtp.Network.Port = txtSmtpPortNo.Text == "" ? 25 : Convert.ToInt32(txtSmtpPortNo.Text.Trim());
settings.Smtp.From = txtSmtpEmail.Text.Trim();
config.Save();

Thursday, August 27, 2009

Read,Write,Edit Resource File Asp.Net C#

//READ RESOURCE

ResXResourceReader reader = new ResXResourceReader(Server.MapPath("~/App_GlobalResources/test.resx"));

IDictionaryEnumerator ide = reader.GetEnumerator();

int i = 0;

//COUNTING FOR THE RESOURCE KEYS

while (ide.MoveNext())

{

i++;

}

//ASSIGN THE DICTIONARY ENTRY ARRAY FOR STORING KEYS

DictionaryEntry[] de = new DictionaryEntry[i];

i = 0;

//RESET DICTIONARY TO INITIAL POSITION

ide.Reset();

while (ide.MoveNext())

{

de[i] = ide.Entry;

Response.Write(ide.Key + " - " + ide.Value);

}

reader.Close();

//WRITE RESOURCE

ResXResourceWriter writer = new ResXResourceWriter(Server.MapPath("~/App_GlobalResources/test.resx"));

foreach (DictionaryEntry del in de)

{

//YOUR CODE HERE IF YOU WANT TO CHANGE VALUES

writer.AddResource(del.Key.ToString(), del.Value.ToString() + "*");

}

//SAVE CHANGES

writer.Generate();

//CLOSE RESOURCE FILE

writer.Close();

//DESPOSE RESOURCE

writer.Dispose();

Wednesday, August 12, 2009

Drop Everything in SQL Server 2005 Database

/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])
WHILE @name is not null
BEGIN
SELECT @SQL = 'DROP PROCEDURE [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Procedure: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP VIEW [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped View: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'V' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP FUNCTION [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Function: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
WHILE @name is not null
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint IS NOT NULL
BEGIN
SELECT @SQL = 'ALTER TABLE [' + RTRIM(@name) +'] DROP CONSTRAINT ' + RTRIM(@constraint)
EXEC (@SQL)
PRINT 'Dropped FK Constraint: ' + @constraint + ' on ' + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
END
GO
/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint is not null
BEGIN
SELECT @SQL = 'ALTER TABLE [' + RTRIM(@name) +'] DROP CONSTRAINT ' + RTRIM(@constraint)
EXEC (@SQL)
PRINT 'Dropped PK Constraint: ' + @constraint + ' on ' + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
END
GO
/* Drop all tables */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = 'DROP TABLE [' + RTRIM(@name) +']'
EXEC (@SQL)
PRINT 'Dropped Table: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'U' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

Thursday, August 6, 2009

SQL to Select a random row from a database table

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL:

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM table
ORDER BY NEWID()

Select a random row with IBM DB2

SELECT column, RAND() as IDX
FROM table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Select a random record with Oracle:

SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1