pagination in asp, plays major roll when you want to display page wise results , what if the recordset size is more or huge, in that case the processing of the page will become slow… for that here is the query , which will really help you the following query is mssql query for example if you want employee name whose salaries are 2nd highest and 1oth highest now, step 1 :select *, .. .. ..
Retrieving Column Names of Table in MySQL, SQL Server
when you do select query that will give you only records available, in some conditions we may require column names of table for dynamic query generating programs for that purpose here is the query for retrieving column names in mysql : show columns from <table name> in sqlserver select column_name from information_schema.columns where table_name =<tablename> for more infomation .. .. ..
Sessions in PHP
using sessions in php session variables hold information about one single user, and are available to all pages in one application. over internet to maintain state of the user we will use sessions, sessions are temporary, by a unique id web server will keep the user data in the web server with which user state can be maintained across the pages in the website. before we start using the session .. .. ..
Creating and Using Own Templates using ASP
when ever the scripts on your pages will become complex, templates are the best solution. working on asp templates is quite easy, 1. stick to page layout eg:. pregare a static html page with your requirements 2. change the content part of each division to one standard identification string eg:. <div id='leftpanel'> <ul> .. .. ..
How to Make Read only Check Boxes
how we can make a chek box readonly? even if we provide readonly attribute you still can check or uncheck the checkbox.. then how we can make a checkbox readonly ?? here is the simple solution, we can do this with javascript. here is how it goes write a onclick even for the desired checkbox, and check weather it is checked , if it is check then make that checked as false vice .. .. ..
Adding Sub MenuItems to the Context Menu Item Dynamically
you can’t add sub menuitems to a context menu item programatically for more than one time. if you try to add first sub menu item it will add up into the list then again if you try to add then the sub menu items wont be displayed, but if you debug it you will find the submenu items will still there . this is bug in .net to over come this problem , toggle the visiblity of the .. .. ..
Strip HTML tags ,Script blocks,Forms, style blocks using Regex in C#.net
many times in many cases we may come across this problem how to strip html tags, how to remove script blocks ? how to remove form blocks and how to remove style sheet blocks ? for those questions here is the simple and best answer read the rest of this entry .. .. ..
Processing Web Request from c#.net/vb.net
to process web request from c#.net/vb.net windows application we have webrequest class. import system.net,system.io name spaces for requesting and processing the result here is the example code 1. create a uri with the required url uri wsn=new uri(\”http://www.ittreats.com\”); 2.next create a webrequest class and pass the above uri object to it webrequest .. .. ..
How to Hide when form is minimized
to hide a form when minimize button is pressed, we have to write a event for form sized changed event in that, add this condition if (this.windowstate == system.windows.forms.formwindowstate.minimized) { this.visible = false; .. .. ..
