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
Tag: asp.net
How link/bind textbox, dropdown list and SQL database together on C#?
Basically what the task is that you search someone’s name in the textbox, click search, the users with that name will populate the dropdown list. SQL Server: this is the query I am try to add to the search button on my page: Aspx side: C# side: I’ve got this already (this is me attempting to fetch data from the
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 ? udel.edu/~, and what mean ? Answer Need more exemples in yout context, but in general
How to get a list of all Table names through asp.net API controller
So I want to get a list of all the table names from the database through a controller as an ASP.net API project. I tried to do it through raw sql query without entity and it looked something like this. But when I try to use the SqlQuery method I get the error ” ‘DatabaseFacade’ does not contain a definition
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.
Could not find control ‘DropCity’ in ControlParameter ‘City’ ERROR
Context: I am trying to nest two dropdownlist(ddl) inside a gridview, the first ddl is called “Ciudad” and the second one is called “Comuna”, I want that according to the “Ciudad” I choose the “Comunas” change to that corresponding “ciudad”. but I get an error and I can not solve it. My GridView: My SqlDataSource’s: Answer This can be a
Insert multiple values from ListBox with stored procedure
I have two related tables, the first called postaDip (IDpostaDip, CODdip, CODposta, from) and the second called cassPosta (IDposta, Desc). I am trying to insert multiple rows into the postaDip table through a listbox that loads the table cassPosta. For example I would like to insert multiple lines of as many lines as IDs I select in the listbox. With
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