I'm creating a webservice to return a number of items from a database. At the moment I'm returning a DataSet of my results in the file.This is working ok but I have noticed my results are grouped as "NewDataSet".Is there a way I can customise the format of the XML returned.
public class MySeat { public string Section { get; set; } public string Row { get; set; } public string Seat {get; set; } }
I want to group a list of seats by the Section and Row so that I can make a comma seperated list of the seats.
var groupedSeats = seats.GroupBy(x => new { x.Section, x.Row }); foreach (var group in groupedSeats) { htmlWriter.Write(group.Key.Section); List<string> seatNumbers = new List<string>(); foreach (var seat in group) seatNumbers.Add(seat.Seat); htmlWriter.Write(string.Join(@", ", seatNumbers.ToArray())); }
Is there a better way to do this with LINQ? This is just a small portion of the code I'm trying to clean up, I'm curious if there is a better way to grab the seat numbers for display rather than creating a list, looping through the groups and then doing a string.Join on it.
I've got a LINQ to SQL object, and I want to group the selected data and then pass it into a view. What's the correct way of doing this? I'm sure I need to group the data when I select it rather than grouping it in the view, as this will result in about 200 rather 50000 rows I need to pass into my view. Are there any good examples of this online that anyone has seen?
Here Group# and item# are checkboxes. Does anyone know how to do this in asp.net. I am getting data from DataSet. One limitation is that I am not allowed to use third party tool/controls or jQuery.
I need to create a grouped checklistbox dynamically from the database, I was able to do it using an TreeView Control, But I need to move it to a Checklistbox. Below is the logic in VB.NET for the TreeView
I have a number of products in a SQL2005 DB. I have the Stored Procedure set-up to return the info as grouped rows containing 'manufacturer, model, quantitiy'.
I need to then display this content on a c# Asp.Net 4 web form grouped by manufacturer with the manufacturer as the group header. The whole data should be displayed over a 3 column layout.
So, Ive used a Datalist as this allows for the number of columns to be stipulated.
However, I can't work out an effective way to show the various products groupd by manufacturer, eg as shown below;
I've got a DNN application using Telerik RadGrid. We're exporting some data from the Grid but when we drill down on the grid control and export the data we only see the initial top level data, never the updated Grid. Here's my table tag and supporting code. I'm not an expert in ASPX/C#so please forgive my newbie-ness.
I want to add 2 radio buttons in a gridview for 2 columns. In that I have to select any row in each column... How to implement this... Actually I ve added gridview and radiobuttons but the thing is I couldn't select 2 columns in a single row ,it wont allow to select 2 radiobuttons at a time...
I am writing a form which has a set of options (radio buttons), and under each option, there is another set of options. For example:
- Session 1 - New Book A - Used Book A - Session 2 - New Book B - Used Book B
I've tried using HTML <input type="radio", and <asp:RadioButton, but even though I assign the "name" attribute correctly, the buttons are not mutually exclusive -- i.e., you can click both within each group. I see in "View Source" that the name and ID are altered, and therefore become ungrouped by the ASP.NET processing. I've tried using <asp:RadioButtonList, and this works functionally, but the items are not grouped properly. They appear like this:
- Session 1 - Session 2 - New Book A - Used Book A - New Book B - Used Book B
Got some records in a sql table. What i would like to do is display all the records on a webpage and group them by state, so that the display would look something like:
California Entry 1 Entry 2 Entry 3 New York Entry 1 Entry 2 Entry 3
Other (for entries with no state)
Entry 1 Entry 2
What would be the best method to do this? And I'm open to using anything up to and including .net 4.0/vs2010
I'm building a music voting application, similar to stack overflow almost.I have 3 tables, Charts, ChartItems, Votes.I'm trying to bring back a list of chartitems, which link to a single chart, with the number of votes for each chart item counted.This is what I am trying currently
var firstList = from chartItem in db.ChartItems join vote in db.Votes on chartItem.ixChartId equals vote.ixChartId into j1 where chartItem.ixChartId == id[code]...
The problem is once I have performed the grouping, I can't get any of the other properties I need from the join to populate the model. For example each ChartItem should have a title, id etc...I have created a ViewModel to hold all the properties that I need, called ChartItemWithVotes(includes all entity values + int totalVotes)In the end I am looking for this
I have what is turning out to be a rather complicated issue - at least for me.
I have a table with TeamID, TeamName, TotalTeamSize, ArrivalDate adn DepartureDate.
I need to create a source for a bar chart that will show the number of people deployed each month. It can be assumed that the entire team is dployed for each of the days between the ArrivalDate and the DepartureDate. Sometimes the ArrivalDate/DepartureDate spans two months (very rarely more) and sometimes it does not.
Here is what I have so far. In this setup phase, I thought I'd get the code working for one team (using a DropDownList) and then cycle through the entire table in order to get the full dataset for the bar chart.
if i have the web application with many pages like add order page, edit order page, and delete order page actually they also interact with the Sql Server 2008 and i also create web service page call Sales_Service.asmx. i know just i need to put something like query into Web Method in Sales_Service.asmx but i have a lot of queries, i don't know which query i should put into it and how the web page call the Sales_Services.asmx
A customer reported that our asmx web service is continually increasing in memory (mem usage as well as private bytes). We are able to reproduce the problem in our lab with Windows 2003 Server SP2 (fully patched) on some of the machines. The customer is using Windows 2008.
We created a Hello World web service targeting the 2.0 framework built under VS2005 SP1 and a test client that continues to call it. The memory increases steadily - approximately 40K per client request. If the test app is paused, the memory remains the same. When it is closed, the memory drops. Explicit calling of GC.Collect does not drop the memory.
We have run the memory profiler on the service and the leak is all native memory. We have uninstalled/re-installed the Framework on one of the machines but no difference. To our knowledge all of the security and IIS settings are not modified. We have compared app pool, default web site and virtual directory properties to machines that have no problem and they are identical.
I have a .net app developed in .net 4.0 version. And I implemented an asmx web service in this. Now I want to call one of the webservice method in another classis ASP application java script function.
I have datatable consist of 20 records and i want to bulk insert into sqlserver through the asmx webservice. Can anybody guide to me or provide Sample BusinessLogic and webservice code.
Can I use the concept of the MS Chart Control in a web service page? Basically I want to send some data to my web service then create a graph, save the image and send the image URL back to the calling device so it can be displayed. How can I accomplish this?
Is it possible to return json data or content when using the HttpStatusCodeResult?I see it is possible to return a result description, but the ability to return an error object would be fantastic!