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.
e.g.
[Code]....
I need to consume and ASMX service on my website.
This service has to be authenticated and results would be displayed on my website.
I am using VS 2008 VB or C# is fine by me.
I had checked on various forums and its not really giving me the required steps (baby steps here)
I have the following class:
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?
View 1 RepliesI want to create List of Grouped Checkboxes as follows:
[]Group1
[] Item1
[] Item2
[]Group2
[]Item1
[]Item2
[]Item3
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 Have few radio buttons which are grouped together, and i want to reterive their values.But i am not sure how can i do that.
View 2 RepliesI 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
#Region "Generate Tree View"
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;
Toshiba
3401
3685
3699
[Code]....
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.
<mastertableview autogeneratecolumns="False" datakeynames="AccountId" datasourceid="SqlDataSource1"
groupsdefaultexpanded="False">
<DetailTables>
[code]...
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...
View 1 RepliesI 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
Chart Name
Votes Name
20 - ChartItemname
15 - ChartItemname
12 - ChartITemName
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.
[ASPX]
[Code]....
[VB]
[Code]....
In VS2010, when I "find in files", I often get doubled results in my find window.
View 5 Replies[URL]
with respect to above link, how to implement javascript validation on submit button outside gridview.
suppose if user doesn't select one of the any group or type it show alert message. it must select at least one row from each group.
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
View 2 RepliesOn my page I have a dropdown for country.
On my asmx service I want to get the value of the dropdownlist to filter the next input which will be state/providence.
My code on the asmx:
[Code]....
I want to add another clause to the WHERE statement to restrict Country = @Country so I will need to get that value to the web service.
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.
View 2 RepliesI 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.
View 1 RepliesI have spent a couple of days on this one. I have an ASP.NET website that has Linkbuttons on
the Default.aspx page.. I added a WebService to the Website because later on the WebService will
subscribe to a Provider(Feed) of News, Sports and Weather and things like that. So when a Linkbutton
on the Default.aspx page is clicked it will connect to the link in the WebService which will load the News,
Sports or Weather onto the Default.aspx web page.
The problem is I can't get the LinkButton to execute the Link in the WebService. The link will call the page up
to where you see all of the Web References. But then if you want to execute one of those references you
have to click its link and the Invoke button that will follow. My questioh is how can the link on my Default.aspx
page execute the link in the WebService. Now I changed the LinkButton into an <a href> but I still can't execute
the link in the WebServices. I always use www.Microsoft.com as the link when testing and I wasn't sure about the return type
so I put "void" for an HTTPRequest, so below is the link from the Default.aspx web page and below that is he asmx file:
[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?
View 7 RepliesIn my asp.net project I need to call another url with a parameter and display what the url returns in a label. What is the easiest way to do this?
View 2 RepliesIs 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!
View 5 Replies