Reply to thread

Message: <blockquote data-quote="w0rl0ard" data-source="post: 16578018" data-attributes="member: 502723">math ekka piliwelata karapan ehema unoth wade thereyi.Want====TSQL, C# dan putha methana wela thiyenne N(Group) * N(Selections) neda?just like e-bay or amazones filtering list wage kiyane ekane.'Oya DB use karana nisa SQL walata bara dena eka lesi. Stored procedure ekak hadaganna. eke select statement danna one hama group ekatama EX:Group<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue    :p" loading="lazy" data-shortname=":p" />rocesor type :Selections=======AllCOrei3COrei5COrei7dan oyage table eka thiyanawane(Eka X kiyanna). ekata SQL statement eka dannaena result eka wenamama table ekaka save karanna (meka Y kiyanna )eka grid eke display karanna Now: Group:Condition Selections========AllWin XPWin 7Win 8Dan Y table eka Flush karala select statement eka danna X table ekataselect //// from //// where procesor type = selction and Condition = selectionena result eka ayimath Y eke save karaganna y display karaganna me SQL statement eka Genarate karaganna one. e kiyanne string x1 = "select * from table 1 where "user processor type 2k click kaloth    x+= "("loop karanna selections (api hithamu loop eka DX kiyala) haraha {    x1 += "processor type = 'DX' and"}    x+= ") And"     x+= "("user condition 3k click kaloth loop karanna selections (api hithamu loop eka DY kiyala) haraha {     x1 += "condition = DY and "}     x+= ")"mekedi group gana static wenna one ne... eka samanyen ehema thama e bay walath thiyenneithin group ekaka selections  1000 k thibbath awlak na SQL eka auto genarate wenne</blockquote>

Verification: Dahaya deken beduwama keeyada?

Top Bottom

Search

Latest ads

Reply to thread