Enabling Database Mail via TSQL


-- allow advanced options

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

-- enable database mail (0 disables , 1 enables)

sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO

-- hide advanced options again

sp_configure 'show advanced options', 0;
GO
RECONFIGURE;
GO



sql:Limit SQL Server memory

on SQL you can Set memory available to a sql instance
on below example we are setting Limit to the 500MB


sp_configure 'show advanced options',1
go
reconfigure
go

sp_configure 'max server memory', 500
go
reconfigure
go



like this way you can set the limit server memory, but for precaution you can try this on local machine without running diretly on live server.

Data Grids with(AJAX,jvaScript, Dhtml)

DataGrids is one of the useful control to show data in tabular format with different different records & result, on gridView you can show as many as option which is very much useful for the end user, to handle with Data Grid and all ,

Here are some Data Grid Controls Devlope with ajax/dhtml/and javascript

1. ExtJs Grid


2. Phatfusion Sortable


3. Table Kit


4.Unobtrusive Table Sort Script.


5.Yahoo UI Library’s DataTables.


6.Standardista Table Sorting


7.Mootable Sorting.


hope u like this collection,
if you know more then plz add it on Comments ,

List of CSS Galleries

css is one of the part of web applicaiton, you can say that without css your application is not perfect as per the coding standard.
here is an overview of css-galleries you can explore inspiration from.

CSS Clip

Web Design Inspiration and Gallery

CSS Blast

Russian CSS Showcase

CSS Collection

CSS collection web sites without tables

CSS-Demo

CSS Showcase

CSSBloom

CSS Gallery with Blog’s and Online Portfolio’s

CSS Drive- Categorized CSS gallery and examples

CSS gallery, code samples, tutorials, and moreCSS Collection

CSS Design Yorkshire

A gallery of CSS web design in Yorkshire UK

CSS ImportCSS

The no-frills CSS Gallery

Liquid Designs

Liquid Designs is a gallery of websites designed with liquid layouts using XHTML and CSS

Piepmatzel

collecting best practice web standards design examples

Webdigity

CSS gallery

Web Standards Awards

Awarding web sites that successfully combine form and function

Well Designed CSS Sites

Andy Budds List of well styled sites.

if you know more plz add it on comments more.
thanx

Cannot implicitly convert type 'object' to 'Microsoft.Office.Interop.Excel.Worksheet'.

on C#, there was an Error when you are using Interop Excel Object:-

Cannot implicitly convert type 'object' to 'Microsoft.Office.Interop.Excel.Worksheet'. An explicit conversion exists (are you missing a cast?) throws up when there is no Explicit casting - (Excel.Worksheet)

Excel.Worksheet oWorkSt =oWB.Worksheets[1];

To

Excel.Worksheet oWorkSt = (Excel.Worksheet)oWorkSt.Worksheets[1];

Getting Local Network Information

on C# when you are performing any application realated with network and in this case if you want information regarding the local network adaptors or local machines network configuration, then you can use the static method System.Net.NetworkInformation.GetAllNetworkInterfaces. it will returns objects of type NetworkInterface.
The properties of the NetworkInterface object will unravel a rich set of information regarding network configuration and network statistics.

here is Sample Code:



using System.Net.NetworkInformation;

if(NetworkInterface.GetIsNetworkAvailable()){

NetworkInterface[] nInterface = NetworkInterface.GetAllNetworkInterfaces();

foreach(NetworkInterface ni in nInterface ){
string NetworkName = ni.Name;
}
}


hope it will helps you.

Asp.Net with Ajax

Before starting with Ajax + asp.net Application you need to do follow.

at first you know how to configure the ajax framwork to your asp.net application
1. configure ajax framwork on asp.net application

2. Sample code

3. Tutorial

4. ajax + .Net Video

5. and if you have any question please ask Here

6. AJAX Application Architecture

7. ASP.NET AJAX 4.0 Preview 4


hope it will helps you.

Telos SE7EN next generation application framework

hi, today i come up with very much new and cool feature of Mircosoft its a Telos SE7EN next generation application framework , its really nice which is base on the Microsoft Surface platform.SE7EN: Green Initiative is designed to provide a secure view of your organizations power and processing efficiency, reporting energy consumption, carbon footprint, and facility benchmark and assessment data sets.

its basically performed using Natural User Interface (NUI). user can do multitasking with the digital content through the natural hands.

refer : 1. http://www.telos.com/solutions/secure%20networks/se7en/green/
2.http://www.microsoft.com/surface/Default.aspx
hope you like it .

Runtime Editing Web.config App.config

You can Edit web.config and app.config file on run time also.
Web.config configuration files & app.config project item files, which get converted to "ExecutableName.exe.config" at build time, both support the convenient appSettings section with its own read method in the System.Configuration.ConfigurationSettngs class. The appSettings section stores element name / value pairs in the format:

<add key="elementName" value="elementValue" />..... more

Add Feedburner Email subscription to your site

you have see most of the sites,blogs have there email subscription option on there site basically its useful for the out site reader to directly read our new feed . in this process there are so many third party site , tool are available to do that ,

"FeedBurner is one of them". if you want to add feedburenr account on your site do follow below steps to configure feed burner email subscription tp your site or blog.

Steps.
1. At first you need Feed burner account. if you dont have account with feedburner click here
if you have account with google then also ok, you can use that.

2.now next steps is if your new FeedBurner user then you have to burn your feed at first,

3.now you burned a feed to your site or blog.


4.now configure your site or blog to show fedburner url for that you have add some htmlcode in your back end,to retrieve this code you need to select publicize > Email Subscription


5.click on that link it , in that page you will get one form tag code simply copy that code and paste it on your site or blog.You can even select your blog type like (Typepad, wordpress, blogger) and it will automatically take to widget option for corresponding blogs system.

6.now u finish with the coding part , open that page and enter your email id and click subscribe , that it..

if you want to Subscribe my blog click here , you will get the updates of my blog via email
thank you.

jquery Fadein Fadeout Effect

Jquery has Great features , here are some collections of Fade Efects , fade effect is very popular on most of the web application , mostly you can use that for image gallary ,animation and so many purpose. Fade in - Fade out is also one of them.

try this example hope you like it .

  

Example of Fade in and Fadeout

1.CrossSlide
Cross-site is a plugin which is mostly used to show animation,Slide-show effects but in very nice manner you can do that animation on left side ,zoomin-zoomout like features are there.

2.
Slide Show(Semi-Transparent Caption)
in this slide show you can add a caption about that images its look very nice, you can do that using css,html and javascript.

3.Supervised
this is fullscreen sildeshow/background plugin it has some great features like on hover it get pause,cycle preloading,Resizes images

4.JQuery with InnerFade
its a very small plugin basically used inside the container. you can add anything with this like images , list-items ,div and many more.

5.Cycle Plugin
its a very lightwaight slidshow plugin , basically implment on innerfade , it has may combinations like shuffle images,zoom , fadeturnout, turnover, and so on

6.Hover Fade

7. Pikachoose
its just like a Presentation control on which you can show slideshow, navigation buttons and pause , play stop option ,implemantation of pikachoose is very simple.


8.an image Gallery
simple image gallery ,with auto play options.



hope it likes you.