Click here to Skip to main content
15,889,034 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionhow to create web setup project in asp.net and how to make it licensed one? Pin
vijayvelidi3-Aug-09 5:24
vijayvelidi3-Aug-09 5:24 
AnswerRe: how to create web setup project in asp.net and how to make it licensed one? Pin
Abhijit Jana3-Aug-09 5:40
professionalAbhijit Jana3-Aug-09 5:40 
Questiona browser inside my site Pin
nelsonpaixao3-Aug-09 4:28
nelsonpaixao3-Aug-09 4:28 
AnswerRe: a browser inside my site Pin
Parwej Ahamad3-Aug-09 5:55
professionalParwej Ahamad3-Aug-09 5:55 
GeneralRe: a browser inside my site Pin
nelsonpaixao3-Aug-09 12:20
nelsonpaixao3-Aug-09 12:20 
QuestionProblems with caching datatable Pin
livez3-Aug-09 3:29
livez3-Aug-09 3:29 
AnswerRe: Problems with caching datatable Pin
ToddHileHoffer3-Aug-09 3:48
ToddHileHoffer3-Aug-09 3:48 
GeneralRe: Problems with caching datatable [modified] Pin
livez3-Aug-09 3:58
livez3-Aug-09 3:58 
My cached datatable:

private static DataTable MyTable
{
	get
	{
		object obj = HttpContext.Current.Cache[SiteCacheEntries.MyTable];
		if (obj == null)
		{
			DataTable dt = Data.Specific.GetMyTable();

			DateTime nextMorning = DateTime.Now.Hour < 6 ?
				new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 6, 0, 0) :
				new DateTime(DateTime.Now.AddDays(1).Year, DateTime.Now.AddDays(1).Month, DateTime.Now.AddDays(1).Day, 6, 0, 0);
					
                        HttpContext.Current.Cache.Insert(SiteCacheEntries.MyTable, dt, null, nextMorning,    Cache.NoSlidingExpiration); 
					return dt;
		}
		return (DataTable)obj;
	}
}



Dataview is also cached:

public static DataView MyDataView
       {
           get
           {
               object obj = HttpContext.Current.Cache[SiteCacheEntries.MyDataView];
               if (obj == null)
               {
                   DataView dv = new DataView(MyTable);

                   HttpContext.Current.Cache.Insert(SiteCacheEntries.MyDataView, dv, null, DateTime.Now.AddYears(10), Cache.NoSlidingExpiration);
                   return dv;
               }
               return (DataView)obj;
           }
       }



My method to collect data from table

public static string GetPageConstant(PageConstants type, LanguageCode lang)
            {
                MyDataView.RowFilter = string.Format("{0} = '{1}' AND {2} = '{3}'", _nameOfTypeColumn,
                   typeColumn.ToString(), _nameOfLanguageColumn, lang);

                if (MyDataView.Count > 0)
                {
                    return MyDataView[0].Row[_nameOfValueToCollectColumn].ToString();
                }

                return string.Empty;
            }


And its in the GetPageConstant method the error occurs.

modified on Monday, August 3, 2009 10:06 AM

GeneralRe: Problems with caching datatable Pin
ToddHileHoffer3-Aug-09 5:51
ToddHileHoffer3-Aug-09 5:51 
GeneralRe: Problems with caching datatable Pin
ToddHileHoffer3-Aug-09 5:58
ToddHileHoffer3-Aug-09 5:58 
GeneralRe: Problems with caching datatable Pin
livez3-Aug-09 6:03
livez3-Aug-09 6:03 
QuestionWebservices : disco files Pin
vishwjeet3-Aug-09 1:06
vishwjeet3-Aug-09 1:06 
AnswerRe: Webservices : disco files Pin
Parwej Ahamad3-Aug-09 6:03
professionalParwej Ahamad3-Aug-09 6:03 
GeneralRe: Webservices : disco files Pin
vishwjeet3-Aug-09 6:05
vishwjeet3-Aug-09 6:05 
QuestionDeployement of web service on IIS6 Pin
Ben.Regaya.Hedi2-Aug-09 23:56
Ben.Regaya.Hedi2-Aug-09 23:56 
AnswerRe: Deployement of web service on IIS6 Pin
Abhijit Jana3-Aug-09 0:14
professionalAbhijit Jana3-Aug-09 0:14 
GeneralRe: Deployement of web service on IIS6 Pin
Ben.Regaya.Hedi3-Aug-09 0:38
Ben.Regaya.Hedi3-Aug-09 0:38 
GeneralRe: Deployement of web service on IIS6 Pin
Ben.Regaya.Hedi3-Aug-09 0:45
Ben.Regaya.Hedi3-Aug-09 0:45 
AnswerRe: Deployement of web service on IIS6 Pin
Robin_Roy3-Aug-09 0:27
Robin_Roy3-Aug-09 0:27 
GeneralRe: Deployement of web service on IIS6 Pin
Ben.Regaya.Hedi3-Aug-09 0:39
Ben.Regaya.Hedi3-Aug-09 0:39 
AnswerRe: Deployement of web service on IIS6 Pin
vishwjeet3-Aug-09 1:25
vishwjeet3-Aug-09 1:25 
QuestionTimer problem Pin
anushh2-Aug-09 23:38
anushh2-Aug-09 23:38 
AnswerRe: Timer problem Pin
Abhijit Jana3-Aug-09 0:16
professionalAbhijit Jana3-Aug-09 0:16 
GeneralRe: Timer problem Pin
anushh3-Aug-09 0:58
anushh3-Aug-09 0:58 
GeneralRe: Timer problem Pin
Abhishek Sur3-Aug-09 1:27
professionalAbhishek Sur3-Aug-09 1:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.