Difference between Triggers and Stored Procedure  

Posted by: Quadtechindia in

1. SP may Return a value but Trigger Not,
2. In SP you can pass parameter But in trigger you can't
3. we explicitly call the Sp when Trigger are implicitly
fired
4. you can write a sp in Trigger but in a Trigger you cant
write SP.
5. Trigger written on an individual Table or View where SP
is written for an Database

USB Flash drive automatic back up  

Posted by: Quadtechindia in

Automatically backup USB flash drives with help of an application available on www . usbflashcopy . com , a free utility..

THINGS Your WEBCAM Can Do  

Posted by: Quadtechindia in

1. HOME SECURITY SYSTEM : -
Free Softwares are available over internet for download, which you can use to turn a webcam into a remote security system.
Check out www.yawcam. com (For Windows)or www. vitamindinc.com (Windows and MAC).

2. Gaming : -
Try www.newgrounds. com, which have plenty of games which uses web cam as an input like keyboard and mouse. Check it out!!

3. Unlock your laptop / desktop using face recognition
Visit http://bananascreen.en.softonic.com and download the free software.

4. Funny Effects on Photo
Check out www.cameroid.com or www.seenly.com and have fun.

5. BAR CODE READER
Shocked but its true. Download the software from www.bcwebcam.

6. MAKE A FONT OF YOUR HANDWRITING
Head over to www.pilothandwriting.com and create one and show your friends your handwriting is one of fonts which systems supports

Difference between website and web application : ASP.NET  

Posted by: Quadtechindia in ,

A "web site" has its code in a special App_Code directory and it's compiled into several DLLs at runtime. A "web application" is precompiled into one single DLL that is built and copied in the Bin directory.

A web site is just a group of all files in a folder and sub folders. There is no project file. All files under the specific folder - including your word documents, text files, images etc are part of the web site.

You have to deploy all files including source files (unless you pre compile them) to the server. Files are compiled dynamically during run time.

In website since there is no project file, there is nothing that you can double click to open the web site in Visual Studio for editing. You have to open Visual Studio first and then open the site from Visual Studio

Terminate a process in task manager  

Posted by: Quadtechindia in

public void terminate()
{
Process[] plist = Process.GetProcesses();
foreach (Process p in plist)
{
try
{
if (p.MainModule.ModuleName.ToUpper() == "WEBDEV.WEBSERVER.EXE")
{
//p.Kill();
}

if (p.MainModule.ModuleName.ToUpper() == "IEXPLORE.EXE")
{
p.Kill();
}
}
catch
{
}

}
}

Code to export data to excel in asp.net using c#  

Posted by: Quadtechindia in

if (GridView1.Rows.Count > 0)
{

Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;

Response.Write("

");
Response.Write("
logo image
Title
");
Response.Write("

");
Response.Write("
");


gvRes.HeaderStyle.Font.Bold = true;
gvRes.HeaderStyle.BackColor = System.Drawing.Color.Black;


System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
HtmlForm frm = new HtmlForm();
this.Controls.Add(frm);

frm.Controls.Add(gvRes);
frm.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();

}

How to Enable saving of changes in SQL server 2008  

Posted by: Quadtechindia in

you can get the details by clicking on ? on the dialog box that shows this error

or the flow is

Open the following
Tools > Options > Designers > Table and Database Designers > Prevent saving changes that require table re-creation. Just Turn this option off and you will be able to save the tables again.

and now you can save changes to all tables of any database.