Saturday, August 13, 2011

Solution Page Validation error with "EnableEventValidation=true" Command




Add the below line if grid bind in page load  :--
if (!Page.IsPostBack)
{
DataTable  dt=methodName_that_fill_datatable();
}

add
<%@ Page AutoEventWireup="true" >

and remove<%@ Page EnableEventValidation="true" >

Thursday, August 11, 2011

How to convert Null value of database to some value

If you need to change null value of database at the time of  fetching data from database
then use this method ISNULL
SELECT  ISNull(ColumnName,'Your Converted Value ')  FROM TABLENAME


SQL Optimization

  SQL Optimization  1. Add where on your query  2. If you remove some data after the data return then remove the remove condition in the sel...