Software / Technology Tips

In ADO.NET we deals with DataTable and DataSet as the representations of different table of our actual database. So we can write complex queries to fetch information from different table by joining them ,adding subqueries to fetch particular information etc… . We can say it behaves same as the view of SQLServer. Here is a…

Recently I was working with jQGrid when I came across a major block, the solution of which I now wish to share through this tip. In case you don’t know, jQGrid is a free jQuery component which has a lot of features and can be used to display data in tabular format like you do…

Window.resize event in IE There are some cases when we will have to do something when the user will resize the window. This is very easy to do with the event window.resize() (except in IE). In IE if we will simply bind the window.resize() in JS, then most of the time there is possibility that…

Generally we write separate statements to INSERT, UPDATE or DELETE data based on certain conditions. But now in SQL Server 2008 there is a new feature present called MERGE statement using which we can INSERT, UPDATE or DELETE record in one statement. MERGE is a new feature which Microsoft has introduced with SQL Server 2008…

Working in Crystal Reports can be real messy, especially when it  becomes difficult to find the right system defined function to be used. Here is when user -defined functions come to the rescue. User defined functions are called custom functions. They can be created for: 1.Reports as Report Custom Functions 2.Repository as Repository Custom Functions.…

We are using light weight jQuery grid to display Data in a tabular format. But sometimes we need to place some controls(checkbox, button) inside the grid for specific operations. Consider an example where a column needs to display Checkbox in each row of a Grid. jQuery Code: var gridId = jQuery("#jqMyGrid").getDataIDs(); //loop through grid rows…

With Web 2.0 ,  websites are becoming more attractive as well as more interactive, so to keep up with the pace we have to make our validation process more interactive too with the help of Javascript and CSS. This code snippet demonstrates 6 different types of visual response to Javascript-based validation of a form. Different…

So what is it?? Just at that time I remembered that this table has a Child table in which we had records, but even if that is the case, ideally it should have given me an error, something like “The DELETE statement conflicted with the REFERENCE constraint “FK_BillOfMaterials_Product_ComponentID”. The conflict occurred in database “AdventureWorks”, table…

Using  the while loop you can get these values one by one  : //php part /**************************************************/ while($rst_results = mysql_fetch_array($results)) {      //showinf the difference string by passing 4 values      echo dateTimeDiff($rst_results,$rst_results,$rst_results,$rst_results); } /**************************************************/ You can see the php part we are calling the function dateTimeDiff with 4 parameters that we are getting from the…

“How do applications like Skype reside in System Tray? Can we do something like this for our application, so that the task tray shows our application icon too? Can we do it in JAVA?” These kinds of questions usually arise in our minds while working. This is what this TIP is all about. FEATURES: 1.…