Quadtechindia

Could not load file or assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies

2012-02-02T16:50:00.000+05:30

It can be solved by installing the crystal run time package that can be found on your local computer (I believe it is installed with visual studio 2008). It is located in:

\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5

I found this information in the Local Help: ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.en/crystlmn/html/topic409.htm

Running the MSI on the production server installed the version 10.5.3700.0 files there and cleared the error.

Difference between Triggers and Stored Procedure

2012-01-04T12:08:00.003+05:30

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

2011-12-25T17:42:00.001+05:30

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

THINGS Your WEBCAM Can Do

2011-12-25T16:07:00.001+05:30

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

2010-09-01T13:37:00.000+05:30

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

2010-08-30T16:17:00.003+05:30

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#

2010-06-10T11:14:00.000+05:30

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

2010-05-25T18:06:00.001+05:30

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.

Function to Encrypt-Decrypt Connection String in Web.Config File

2010-04-07T15:10:00.001+05:30

Code to Encrypt Connection String in Web.Config File

using System.Configuration;
using System.Web.Configuration;
using System.Web.Security;

public void EncryptConnectionString()
{

Configuration config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (!section.SectionInformation.IsProtected)
{
section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
config.Save();
}
}

public void DecryptConnectionString()
{
Configuration config = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
ConfigurationSection section = config.GetSection("connectionStrings");
if (section.SectionInformation.IsProtected)
{
section.SectionInformation.UnprotectSection();
config.Save();
}

A potentially dangerous Request.Form value was detected from the client side

2010-02-19T05:12:00.001+05:30

If you face such above mentioned error on inserting a value then that value might be containing anchor tags(< or >). If you want to insert these values you have to write

ValidateRequest="false" in page directive (first line of .aspx file)

Example:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="xyx.aspx.cs" Inherits="xyz" ValidateRequest="false" %>

Code to identify sql server version and edition

2010-02-01T23:31:00.001+05:30

Write following statement in Query Window

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

* The product version (10.0.1600.24)
* The product level (RTM)
* The edition (Enterprise)

Inorder to find out version of sql server write the following statements in query window

SELECT @@VERSION

Code to export data to excel via asp.net

2010-01-20T02:25:00.004+05:30

if (GridView1.Rows.Count > 0)
{

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

Response.Write("Add anything (tag or text) as per requirement");

GridView1.HeaderStyle.Font.Bold = true;
GridView1.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(GridView1);
frm.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();

}

What is Literal ?

2010-01-19T02:17:00.001+05:30

A Literal Web Server control doesn't have any visual appearance on a Web Form but is used to insert literal text into a Web Form. This control makes it possible to add HTML code directly in the code designer window without switching to design view and clicking the HTML button to edit the HTML.
The notable property of this control is the text property which is the text that is inserted into the Web Form.

Example

The following line of code demonstrates that.

Literal1.Text = "Literal Demo"

Sql data adapter in C#

2009-11-04T14:10:00.003+05:30

using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApplication9
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
FillData();
}

void FillData()
{
// 1
// Open connection
using (SqlConnection c = new SqlConnection(
Properties.Settings.Default.DataConnectionString))
{
c.Open();
// 2
// Create new DataAdapter
using (SqlDataAdapter a = new SqlDataAdapter("SELECT * FROM EmployeeIDs", c))
{
// 3
// Use DataAdapter to fill DataTable
DataTable t = new DataTable();
a.Fill(t);

// 4
// Render data onto the screen
dataGridView1.DataSource = t; // <-- From your designer
}
}
}
}
}

Part 1. This creates a new SqlConnection instance. Note that you must include the System.Data.SqlClient namespace in your program. [See top of code]

Part 2. After calling Open() on the SqlConnection, we use another using block for the SqlDataAdapters. The using statements are ideal for disposing of resources, making your programs more efficient and reliable. [C# SqlClient Tutorial - dotnetperls.com]

Part 3. Here we instantiate and Fill a new DataTable. Note that the Fill method on DataTable will populate the internal rows and columns of the DataTable to match the SQL result.

Part 4. This part is commented out because it won't compile unless you have a DataGridView. We see the DataSource being assigned to the DataTable. The result will be a filled DataGridView with data from SQL Server.

Culture and UI Culture for ASP.NET Web Page Globalization

2009-11-04T14:00:00.004+05:30

In an ASP.NET Web page, you can set to two culture values, the Culture and UICulture properties. The Culture value determines the results of culture-dependent functions, such as the date, number, and currency formatting, and so on. The UICulture value determines which resources are loaded for the page.
The two culture settings do not have to have the same value. Depending on your application, it might be important to set them separately. An example is a Web auction site. The UICulture property might change for each Web browser, whereas the Culture stays constant. Therefore, prices are always displayed in the same currency and formatting.

<%@ Page Language="C#" uiculture="auto" %>
<%@ Import Namespace="System.Threading" %>
<%@ Import Namespace="System.Globalization" %>
script runat="server"
protected override void InitializeCulture()
{
if (Request.Form["ListBox1"] != null)
{
String selectedLanguage = Request.Form["ListBox1"];
UICulture = selectedLanguage ;
Culture = selectedLanguage ;

Thread.CurrentThread.CurrentCulture =
CultureInfo.CreateSpecificCulture(selectedLanguage);
Thread.CurrentThread.CurrentUICulture = new
CultureInfo(selectedLanguage);
}
base.InitializeCulture();
}
/script
html
body
form id="form1" runat="server"
div
asp:ListBox ID="ListBox1" runat="server"
asp:ListItem Value="en-US"
Selected="True"English /asp:ListItem
asp:ListItem Value="es-MX">Español /asp:ListItem
asp:ListItem Value="de-DE">Deutsch /asp:ListItem
/asp:ListBox
br /
asp:Button ID="Button1" runat="server"
Text="Set Language"
meta:resourcekey="Button1" /
br /
asp:Label ID="Label1" runat="server"
Text=""
meta:resourcekey="Label1" /
/div
/form
/body
/html

tags cannot be posted so please add angels brackets

Example to Insert and Update Trigger in Sql-Server

2009-10-08T09:54:00.001+05:30

Insert Trigger
CREATE TRIGGER trig_addAuthor ON [dbo].[Emp]
FOR INSERT
AS
DECLARE @newName VARCHAR(100)
SELECT @newName = (SELECT ename FROM Inserted)
-- Print the name of the new author
PRINT 'New author "' + @newName + '" added.'

Update Trigger
CREATE TRIGGER trig_updateemp
ON emp
FOR UPDATE
AS
DECLARE @oldName VARCHAR(100)
DECLARE @newName VARCHAR(100)
IF NOT UPDATE(ename)
BEGIN
RETURN
END
SELECT @oldName = (SELECT ename FROM Deleted)
SELECT @newName = (SELECT ename FROM Inserted)
PRINT 'Name changed from "' + @oldName + '" to "' + @newName + '"'

Code to clear cache in asp.net

2009-09-24T09:00:00.002+05:30

Response.Cache.SetNoStore();
Response.Cache.SetCacheability(HttpCacheability.NoCache);

write this code in page load
add using System.Web;