Skip to content


Convert Sql to linq with groupby

I have view on which I use this request And it’s running sucessfully and get me this data How I need to write it using linq to get same data? I tried like this But on new HumpChartDto() {SpendBand = x.SpendBand} I got Cannot resolve symbol ‘SpendBand How I can solve this? Answer First, after grouping on SpendBand, you need

how do path at the final url like this “~” [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed last month. Improve this question what is code “~” from the end of this url ?, and what mean ? Answer Need more exemples in yout context, but in general

Between the time in SQL Server and ASP.NET

I am storing STARTTIME and ENDTIME in a SQL Server table by using ASP.NET webform. Now, as you can see in the row with timeTableID = 2, the inserted time value is 8:00 & 8:30 AM, But in the row with timeTableID = 3, the inserted time value is 8:15 & 8:25 AM, I don’t want this because its within

I didn’t true use order by in linq

Hi i develop web app with c#. I have sql query and i convert to linq but it’s not working true because of order by My sql query My linq Answer Here’s how you can do the order by on the count of each group and take the 3 with the highest count.

Cascading combo box

I am trying to bind 2 combo box, being the value of the second dependent from de first. All the solutions that i saw to this problem were by the use of Sql.Data (Datatable), which i cant use, due to the architecture of the application. I can do it 2 ways, by c# or through ASP Object Data Source. I’ve

On button click append OR… in SQL Query

Is it possible to append to an SQL query based on number of clicks on a button? Eg. For each time I click on the button (+) I want to add OR [PIN]=@LogID# Where # is a number increasing for everytime I press the plus (+) button. I also would like do be able to decrease the same way by