datatable grouping

Posted in Labels: | at 8:54 PM

Ex : var masterGroups = (from row in dtRetCls.AsEnumerable()
group row by row["GroupDescription"] into groupedTable
select new
{
x = groupedTable.Key
}
).ToList();

Select data rows

DataRow[] drx = dtRetCls.Select("GroupDescription= '" + item.x + "' ");

Read Users' Comments (0)

Computed Column Specification

Posted in Labels: | at 8:52 PM

Ex :

(((isnull([AuthorizedQtyU1],isnull([InvoiceQtyU1],(0)))-isnull([ReceivedQtyU1],(0)))-isnull([DamagedQtyU1],(0)))-isnull([MissingQtyU1],(0)))

Is Persisted = no

(datediff(minute,[StartTime],[EndTime]))

Is Persisted = no

Read Users' Comments (0)

filter generic list items

Posted in Labels: | at 2:23 AM

BatchExeProduct batchExeProductObject = batchExeProducts.Find(delegate(BatchExeProduct ep) {return ep.ExecutiveCode == exeCode; });

Read Users' Comments (0)

Remove cache in asp.net page

Posted in Labels: | at 8:24 PM

So far I've tried the page directive:

@ OutputCache Duration="1" Location="None"

The Meta tags:

<meta http-equiv="Expires" CONTENT="0">

<meta http-equiv="Cache-Control" CONTENT="no-cache">

<meta http-equiv="Pragma" CONTENT="no-cache">

And the code:

Response.ExpiresAbsolute = DateTime.Now

Response.Expires = -1441

Response.CacheControl = "no-cache"

Response.AddHeader("Pragma", "no-cache")

Response.AddHeader("Pragma", "no-store")

Response.AddHeader("cache-control", "no-cache")

Response.Cache.SetCacheability(HttpCacheability.NoCache)

Response.Cache.SetNoServerCaching()

Read Users' Comments (0)

filter sql

Posted in Labels: | at 9:31 PM

WHERE convert (datetime, convert (varchar, datecol, 101), 101) = @yourdate

Read Users' Comments (0)

Subscribe to: Posts (Atom)