kishorgh wrote: wht SPAM That was not for you ! :-D Some one Spamming in this site and we have marked him. :) cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net View My Recent Article

got the solution...............:) SqlHelper.ExecuteNonQuery ( myConnectionString , "usp_InsertTrackingData" , iWeekNo , Convert.ToInt32(dtRow["InvCoID"]) , ((dtRow["LatestReportDateConsensus"] != DBNull.Value) ? dtRow["LatestReportDateConsensus"] : null) , ((dtRow["LatestReportDateVirtua"] != DBNull.Value) ? dtRow["LatestReportDateVirtua"] : null) ,dtFromDate ,dtToDate ,CreatedBy );

Hey thnx a lot...its working fine..:)

i have writ code in (!IsPostBack) still its not working..:(