Software / Technology Tips

Screen all incoming query-strings to prevent SQL injection

Description: Web sites initially started to show static information to the user on plain HTML pages with some graphics and colorful text. But with the growing pace of the IT, web sites not only dispaly dyanamic data but also capable of taking the orders from the customers and process them online. This whole process is…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

Disable row selection as well as the whole row in DevExpress gridview, based on the cell value in IE and Firefox.

The following tip demonstrates how to enable or disable a row based upon one of its column value Let us say we want to disable the whole row if OnHand column value of ASPXGridview is 0. 1.by handling ASPXGridview_HtmlRowCreated event of ASPXGridview. Protected Sub ASPXGridview_HtmlRowCreated(ByVal sender As Object, ByVal e As DevExpress.Web.ASPxGridView.ASPxGridViewTableRowEventArgs) Handles ASPXGridview.HtmlRowCreated If…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

Dynamic Allocation Of Vertical Scroll Space In JQGrid

 While using jQgrid, most of us have faced a situation when after displaying all the columns, there is an extra space for scrollbar at very end of the grid. The scrollbar helps us to scroll through records inside jQgrid, if it exceeds the page size. But usually we don’t need to show the last allocated…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

How to modify web.config file programmatically ?

Web.config plays an important role when we create web application in ASP.NET. Normally here we store some custom application level settings (like Database Connection String, Mail Server address, etc…). Some of the advantages of keeping values in web.config file are. 1. Easily Readable (As it is in XML file format). 2. Accessible through out our…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

How to get list of Local and Network Printers

To get the list of printer queue we call the method GetPrintQueues. This method has a number of signatures for populating different kind of printers. PrintServer localPrintServer = new PrintServer(); If you do not pass any argument  (i.e localPrintServer.GetPrintQueues()), it will just return the printer queue attached directly to your machine. But as we need…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

Execute sql stored procedure or sql query from Access.

If we need to execute sql stored procedure or a sql query from Access 2007, we can do it by following steps:- On the create tab, click Query design in the other group. Click close in the Show Table dialog box without adding any tables or queries. On the Design tab, click Pass-Through in the…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

Creating Downloadable PDF in ASP.NET With Client Side Event Call

Scenario : There will be a button, when user clicks it, a dialog box will open that provides user with two options, either user can directly view or save the pdf file in his/her local machine. The pdf will contain all the details of a perticuler user whose first and last name will be given…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

Cloning a XLS worksheet in PHP | Mindfire Solutions

Instead of designing and writing the data in a Excel file, it is much easier to have a template with all the designs embedded.  We have to just read the template file and write our data in the particular cells.  But if we are going to have, say, ‘n’ number of sheets, then the template file also should…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

How to merge CSS files in ASP.NET

ASP.NET provides ScriptManager using which we can combine our script files. There is already a tip which describes “How to merge your Javascript files in ASP.NET”. But ScriptManager in ASP.NET does not provide us the facility to merge CSS files. We can achieve it by the following steps: Step 1: Create an HTTP handler which…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!

How to use Savon in Ruby on Rails Application

In this tips I am going to introduce you to web service API call. I am using “WebserviceX.NET provides programmable business logic components and standing data that serve as “black boxes” to provide access to functionality and data via web services”. I am going to use one of its web service  which is “Currency Convertor…

read more
150 150 Burnignorance | Where Minds Meet And Sparks Fly!