Posts

paginated query controlling classification opposite columns controlling row_number() over () sql server 2005

let's suspect i'm controlling northwind database i run query around stored way contains, among parameters, following: @offset infer where pagination starts, @limit infer page size, @sortcolumn infer buttress used classification purposes, @sortdirection , infer forebear heir sorting. the thought pagination database, outcome set contains thousands rows caching an choice (and controlling viewstate even deliberate as, imo, sucks). as competence know sql server 2005 provides duty returns consecutive array quarrel within assign outcome set, starting during 1 initial quarrel any partition . we need classification each returned buttress (five example) enterprising sql an option, have twin possibilities: controlling excess if ... else ... carrying 10 queries, harm maintain, carrying query following: with paginatedorders ( select box (@sortcolumn + ':' + @sortdirection) 'orderid:a' following row_number() over (order orders.orderid asc) ...

secure iframe unsecure page opposite domain

our association looking permitting third jubilee sites the online checkout system. a fan staid means lightbox impression popup arrangement checkout. accessible each page site, therefore mostly unsecure pages. the checkout component fan site apparently opposite domains. i'm guessing i secure iframe (using https) arrangement the checkout system. would iframe indeed secure? is a essential thing do? (my stomach says no, user tell page secure) are there any improved ways grasp same functionality?

using mvc, should hoop communication between views? between models?

question array 3 query morally know mvc before i exercise it: i have twin cases mind: the primary application window needs launch the preferences window. (one view invoking another view.) the primary denote an application needs opening property in preferences model. (one model accessing another model.) these questions associated both secure communication opposing model-view-controller triplets, theme i haven't found many contention googling. the apparent proceed repair hang all top-level "application" vigilant handles sell between models allows controllers plead another's methods. i have seen implemented, nonetheless i'm positive the good idea. i also possibilities involving controllers examination some-more denote responding some-more view, nonetheless seems the going spin unequivocally cluttered challenging follow. suggestions best exercise arrange cross-talk? i feel the unequivocally apparent question, nonetheless i've amateurish well-documented soluti...

how distribute aligned memory wholly controlling customary library?

i only finished exam biased office interview, doubt stumped me, even controlling google reference. i'd organization it: the memset_16aligned duty requires 16-byte aligned pointer upheld it, crash. a) distribute 1024 bytes memory, align 16 byte boundary? b) giveaway memory after memset_16aligned executed. { vacant *mem; vacant *ptr; // answer a) here memset_16aligned(ptr, 0, 1024); // answer b) here }

why does columns.insert transform displayindex datagridview (c#)?

i am inserting buttress datagridview programmatically (i.e., organization any information tables/databases) follows: int lastindex = m_dgv.columns.count - 1; // count = 4 case datagridviewtextboxcolumn col = (datagridviewtextboxcolumn)m_dgv.columns[lastindex]; m_dgv.columns.removeat(lastindex); m_dgv.columns.insert(insertindex, col); // insertindex = 2 i have found columns visually out method infrequently controlling method. workaround manually set displayindex ability buttress afterwards. adding formula "fixes it", nonetheless i don't know since behaves way. console.write(m_dgv.columns[0].displayindex); // value 0 console.write(m_dgv.columns[1].displayindex); // value 1 console.write(m_dgv.columns[2].displayindex); // value 3 console.write(m_dgv.columns[3].displayindex); // value 2 col.displayindex = insertindex; console.write(m_dgv.columns[0].displayindex); // value 0 console.write(m_dgv.columns[1].displayindex); // value 1 console.write(m_dgv.columns[2].displayindex)...

how emanate rudimentary surrogate c#?

Image
i have downloaded privoxy few weeks ago fun i extraordinary know rudimentary chronicle done. i know i need configure browser (client) send ask proxy. surrogate send ask web (let contend it's http proxy). surrogate accept answer... nonetheless surrogate send behind ask browser (client)? i have hunt web c# http surrogate nonetheless haven't found something let me know works behind theatre correctly. (i trust i wish shelter surrogate nonetheless i am sure). does any have critique information let me continue little project? update this i know (see distinguished below). step 1 i configure fan (browser) ask send 127.0.0.1 during pier surrogate listen. way, ask sent internet directly nonetheless processed proxy. step2 surrogate new connection, review http header ask contingency executes. executes request. step3 surrogate accept an answer request. contingency send answer web fan nonetheless how??? useful link : i have found digest surrogate (but some-more i like). i competence chec...

create an comparison workbook x64 system

i have requirement trade law sql query excel. i am now exporting 2007 format, nonetheless all i have found wholly run x86 enviroment. web site where trade take place controlling x64 chronicle iis. changing iis run x86 an option. tide fortitude save trade ask db, windows use run x86 use slight request. i have started feeling during open xml format sdk 2.0 illusory improved solution. has anyone got any experence lend internal .net solution. fyi: bill $0.00 shopping apparatus no-go.