C# MVC get .Distinct() data

<p>I have some data in SQL Server:</p><pre><br /><code>[<br /> {<br /> "code": 1,<br /> "name": "qweee",<br /> "IDNO": "ff2222"<br /> },<br /> {<br /> "code": 2,<br /> "name": "test2",<br /> "IDNO": "ff2222211"<br /> },<br /> {<br /> "code": 3,<br /> "name": "fsdfasdf",<br /> "IDNO": "ddaaa"<br /> },<br /> {<br /> "code": 4,<br /> "name": "qweee",<br /> "IDNO": "ff2222"<br /> },<br /> {<br /> "code": 5,<br /> "name": "123",<br /> "IDNO": "U120000005"<br /> }<br />]<br /></code><br /></pre><p>I need to use the following SQL in C # MVC</p><pre><br /><code>SELECT DISTINCT <br /> A1.IDNO , A1.name ,<br /> (SELECT COUNT(cnt_tab.IDNO) <br /> FROM Postpartum_AccountsManagement AS cnt_tab<br /> WHERE cnt_tab.IDNO = A1.IDNO) AS data_cnt<br />FROM <br /> Postpartum_AccountsManagement AS A1<br /></code><br /></pre><p>Then I will get</p><pre><br /><code>[<br /> {<br /> "name": "test2",<br /> "IDNO": "ff2222211",<br /> "data_cnt": 1<br /> },<br /> {<br /> "name": "qweee",<br /> "IDNO": "ff2222",<br /> "data_cnt": 2<br /> },<br /> {<br /> "name": "fsdfasdf",<br /> "IDNO": "ddaaa",<br /> "data_cnt": 1<br /> },<br /> {<br /> "name": "123",<br /> "IDNO": "U120000005",<br /> "data_cnt": 1<br /> }<br />]<br /></code><br /></pre><p>I need to get the same data in C# MVC.</p><br /><h2>Click here view more answers <a href="http://ift.tt/1KG77bK">http://ift.tt/1KG77bK</a></h2>

Nhận xét

Đăng nhận xét

Bài đăng phổ biến từ blog này

Align div to bottom of the page in bootstrap

<p>I tried to use methods from stack questions, but nothing works for me, despite project is very simple.</p><pre><br /><code><div class="fluid-container"><br /> <div id="app-row" class="row"><br /> <div id="app" class="col-xs-5"><br /> <div class="top-navbar"><br /> Top<br /> </div><br /> <div class="bottom-navbar"><br /> Bottom<br /> </div><br /> </div><br /> <div id="map-container" class="col-xs-7"><br /> <div id="map"></div><br /> </div><br /> </div><br /></div><br /></code><br /></pre><p>style.css</p><pre><br /><code>.fluid-co...
Đọc thêm

Align elements inside an tag vertically

<p>I have an <code><a></code> tag (which is part of multiple <code><li></code> tags). In the <code><a></code> tag I have an <code><i></code> tag and some text - the text of the link.</p><p>What I would like to achieve is to have the icon on top and the text under it (and then centered). So it would look like:</p><pre><br /><code> ICON<br />MYTEXTHERE<br /></code><br /></pre><p>However they are always placed next to each other. I tried using <code>display: inline-block</code> - because my <code><a></code> is <em>inline</em> and the content inside should be <em>block</em> but without success.</p><p>The fiddle is here: <a href="http://ift.tt/1mFkDBp" rel="nofollow">http://ift.tt/1mFkDBp</a></p><br /><h2>Click here view more a...
Đọc thêm

Javascript is unable to stop page loading

<p>I have a sign-up page having proper validation's every place. But whenever i click "Sign-Up" on a blank form. It shows the validation, but gets loaded. I want to stop the loading. How's that possible.</p><p>I am primarily checking on chrome, where i checked on settings, whether javascript is disabled or not, but it is enabled.</p><p>it's happening in an .cshtml page.</p><p>Feel free to ask any question</p><br /><h2>Click here view more answers <a href="http://ift.tt/1PUkVhE">http://ift.tt/1PUkVhE</a></h2>
Đọc thêm