Capturing Mouse Wheel event in C#

Microsoft chose not to display the MouseWheel event in the Event box. However, it is easy to hook it through the editor.

In the constructor of the Form / custom control, type - "MouseWheel+=", and press TAB twice. Once for completing the statement, and again to insert the handler in the class.

to catch the wheel rotation, if the value of e.Delta >0 then it scrolls up and if the value of e.Delta <0 then it scrolls down:

if (e.Delta < 0)
    x--;
else
    x++;

TeamViewer

TeamViewer connects to any PC or server around the world within a few seconds. You can remote control your partner's PC as if you were sitting right in front of it... more

Create Duplicate Table in MySQL

MySQL provides many methods to create duplicate table with its data or without its data. The following is a simple example to create a duplicate table along-with data of the original table:

CREATE TABLE new_table_name SELECT * FROM old_table_name; 

An important point to note is that this query will not create column attributes and indexes as defined in the original table.

If you also want to have such attributes, this can be done with another easy way. Below queries will create a copy of the original table with all its constraints and attributes and also insert entire data from the original table to the new on:

CREATE TABLE new_table_name LIKE old_table_name;

INSERT INTO new_table_name SELECT * FROM old_table_name;

Access To MySQL

Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL... more

Web Standards Update For Visual Studio 2010 and Activating HTML5/CSS3 intellisense/validation

Web Standard Update for Visual Studio 2010
Web Standards Update provides the much wanted HTML5 & CSS3 support to Visual Studio 2010 SP1. It brings VS 2010 intellisense & validation as close to W3C specification as we could get via means of an extension... more

Activating HTML5/CSS3 intellisense/validation for Visual Studio 2010
VS2010 was originally released without HTML5 support with VS2010 SP1 to some extend. The entire HTML5 specification isn’t supported but most of the new elements and attributes are. That means you get both intellisense and validation for HTML5 with SP1... more

Query Builder for MySQL

DBforge Query Builder is a brand-new solution for quick creation of complex queries and extended data management... more 

Iron Speed Designer builds visually stunning, feature-rich Web 2.0 applications that are easy to customize and ready to deploy... more

Teleric Radcontrol Combobox on SelectedIndexChanged

The SelectedIndexChanged event occurs when the user selects a new item in the drop-down list.

The SelectedIndexChanged event does not fire unless the AutoPostBack property is True.

The SelectedIndexChanged event handler receives two arguments:

1. The RadComboBox that is loading items. This argument is of type object, but can be cast to the RadComboBox type.
2. An EventArgs object. This object has the following properties for identifying what has changed:
   • Text is the text of the item that was just selected.
   • Value is the value of the item that was just selected.
   • OldText is the text of the item that was previously selected
   • OldValue is the value of the item that was previously selected

Use the SelectedIndexChanged event handler to respond in server-side code when the user changes the current selection:

  

ASPX code:

<telerik:radcombobox 
  id="RadComboBox1" 
    runat="server" 
    autopostback="True" 
    onselectedindexchanged="RadComboBox1_SelectedIndexChanged">
</telerik:radcombobox>

C# code behind:

private void RadComboBox1_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
    Label1.Text = "You selected " + e.Text + " item";
}

Visual Studio 2010 Productivity Power Tools

Visual Studio 2010 Productivity Power Tools is a set of extensions to Visual Studio Professional (and above) which improves developer productivity. This comprises of different tool set that definitely at least one will be very useful to developers more

Passing Parameters from C# Code to Telerik Reports

After creating a report with Telerik reporting tool, import it as reference library to the actual project. It is better to write the fields name to make sure the C# code address the right field. Then the following commands can talk to the report fields:

Telerik.Reporting.Report report = (Telerik.Reporting.Report) this.ReportViewer1.Report;
report.ReportParameters ["FIELD NAME"].Value = <VALUE>;

Telerik Reporting

(A) To create a Telerik report: 

• Create a 'C# class library project'
• Add a Telerik Report from C# toolbox
• Design the report (wizard or custom query)

(B) To use the created Telerik report: 

• Create a C# Winform of Web Application project
• Add the created Telerik report in step A as a reference to the project
• Add a 'Report Viewer' to the page and select the 'Report' property to point to the desired created report
• Overwrite the 'ConnectionString' in 'web.config' with the 'ConnectionString' in the 'app.config' of Telerik report created in step A

MS SQL Server Installation Failure

Sometimes re-installing the Microsoft SQL Server failed. One of the many causes is due to remaining old instances of database or user.config file. One of the many solutions to solve the problem is to delete the 'user.config' file (XML configuration of SQL Server) from the specific path refereed in the error message such as:

C:\Users\kioumarss\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config.xml

Registering ASP.Net/AJAX 3rd Party Controls

Registering Teleric Rad Controls for ASP/AJAX .NET:

Error Message: 
Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "AjaxControlToolkit.Properties.Resources.NET4.resources" was correctly embedded or linked into assembly "AjaxControlToolkit" at compile time, or that all the satellite assemblies required are loadable and fully signed.

Reason:
AjaxControlToolkit’s control load reference refers to the base System.Web.UI.Control method which is present as a part of the ASP.NET AJAX Libraries and those libraries are referenced only when the "ScriptManager" is referenced in the page.

Solution:
Add ScriptManager in the page and this error would be resolved... more

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolder ID = "MainContent">

    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
</asp:Content>


Ajax Control Toolkit
The Ajax Control Toolkit contains a rich set of controls that you can use to build highly responsive and interactive Ajax-enabled Web applications. The Ajax Control Toolkit contains more than 40 controls, including the AutoComplete, CollapsiblePanel, ColorPicker, MaskedEdit, Calendar, Accordion, HTML Editor Extender, and Watermark controls. Using the Ajax Control Toolkit, you can build Ajax-enabled ASP.NET Web Forms applications by dragging-and-dropping Toolkit controls from the Visual Studio Toolbox onto an ASP.NET Web Forms page... more

Spelling Check Probelm in MS Word

Sometimes spelling check in Microsoft Word stops working. There are a couple of solutions which might be considered:

Solution A:

1. Go to "File >Options >Proofing"
2. Tick "Check grammar while spelling" on
3. Tick "Mark grammar errors as you type" on

Solution B:

1. Go to "File >Options >Add-Ins"
2. Select "Disables Items" from "Manage" drop-down box
3. Click "Go" 
4. Select the proper items in the list and click "Enable"
   
   
   

MySQL vs Microst SQL Server

"If you're creating a web application using C# ASP .NET, you will more than likely be using one of the three top database engines MySQL, MS SQL (Microsoft SQL Server), or Oracle to store your online data. From the developer's view, all three databases are virtually the same. You use the same generic framework calls to connect, read, and write data. While it is more common to use Microsoft's MS SQL Server with a .NET application, a large number of web hosts offer the free MySQL database. Therefore, connecting to a MySQL database from C# ASP .NET is an important task and is actually quite easy to do" more

Installing MySQL Server

Download MySQL from MySQL community web site: http://dev.mysql.com/downloads/installer/ MySQL Installer provides an easy to use, wizard-based installation experience for all your MySQL software needs. It includes:

• MySQL Server
• All of our support connectors
• Workbench and sample models
• Sample databases
• Documentation 

In some cases, if MySQL Server failed during installation, it might displays the message "cannot connect to local host". In this case, it is recommended to remove all the unnecessary software (such as HP help assistance and so on). 

 

 

Software Engineering Book

Software Engineering: A Practitioner's Approach, 6/e

http://highered.mcgraw-hill.com/sites/0072853182/information_center_view0/

Installing IIS and deploying the ASP web application

• Install complete IIS package (check all items and sub-items)

• Change the ASP version in IIS by clicking on 'Application Pools'

• Fix .NET after installing the Visual Studio, MySQL and/or ... http://www.itcsolutions.eu/2010/09/06/solution-for-http-error-500-21-internal-server-error-bad-module-managedpipelinehandler-on-iis-7-5/

• Register .NET using: c:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i

• Make 'Web -> ASP.Net Application' for windows

• Compile the code and publish it as 'File System' to the desire directory under 'localhost/wwwroor'

• Convert the published web folder to 'Web Application' inside the 'IIS Manager'

• Make the 'temporary graph folder' manually on the server

• Select the proper "Application Pool' by clicking on the desire website and 'Basic Settings'

• Compile the project in Visual Studio and publish it under 'localhost/wwwroot/ <desire folder>'

•  Allow users to use 'CGI' and 'ASP' services by making them 'Enable'

Be Free to Communicate. Call and text anyone, anywhere.

Viber is an application for iPhone® and Android™ phones that lets you make free phone calls and send text messages to anyone who also has the application installed... more