I need to create a web service in which will list about 6000 record (50 columns).
One existing program will call this web service and pass a parameter (e.g. MemberName) to retrieve records.
Is it possible? How to do it?
I created a gridview that is made up of 4 gridviews and using a stored procedure to populate it. I create columns at runtime because the number of columns changes all the time.To make the grids editable I am adding template fields at runtime as I create the columns, this is to ensure that a user is able to edit the cells and some foot values update. Reason why I have four grids is to freeze rows and columns like in excel using javascript. The problem is that performance is very bad especially in IE, the grids take a long time to load. I am not sure if this is caused by the data load or the creation of text boxes. see some of the code below for my _aspx page:
[Code]....
I have drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.
View 2 RepliesI have built a WCF Service that is being consumed by a Silverlight app. At first I created one method that was very simple:
public String SfTest()
{
return "SF Test";
}
No poblem. My silverlight app references my service and displays "SF Test" in a textbox. Now I add a method to my wcf service like this:
public List<String> GetTest()
{
List<String> list = new List<string>();
String a = "a";
list.Add(a);
String b = "b";
list.Add(b);
return list;
}
I update the reference to the service in my Silverlight app and the using statement in my xaml cs page throws an error like the service doesn't even exist although it is there. I am assuming the problem has to do with datatypes or serialization or something like that but it is driving me up the wall. Why can't I consume a simple generic list in my Silverlight app through the WCF service.
I've created a simple WCF service hosted by ASP.NET web site:
[Code]....
I can add references to this service as to WCF service, as to WebService.WcfTestClient application successfully recognized service and its methods.
But "Web Service Studio" [URL] can't get a list of operations... Why? How to diagnose/resolve that?
P.S. I work under VS 2008 using .NET 3.5
I developed a web service in VS2010 on my local machine, wrote a consumer of it also locally, and that all works.
I copied the dll and the asmx file to our server, and I am getting an error when I try to invoke it from a browser (also still on the server machine) to make sure it correctly exposes its web methods, but it is not, it is saying "Could not create type 'Service'". That error comes from this line:
Line 1: <%@ WebService Language="C#" CodeBehind="~/App_Code/WarrantyDuplicate.cs" Class="Service" %>
There other web services in the same folder on the server that all work fine so I don't believe it's an IIS setup thing.
This is my first web service in C# and when I created it in VS I did think it odd that the code behind file went into App_Code (as you can see from the line in the asmx file) and is just named dot-cs rather than asmx-dot-cs. But since it worked fine locally, I wasn't sure that mattered.
How to create an instance of web service without adding web service reference? How to identify the server address/name where the web service is hosted from C# code?
View 1 RepliesI have a very irritating problem. I'm working with a list of documents, but it's too big for the web service to handle correctly. Basically, it's a simple setup:
An entity framework wraps around a table that contains thousands of large XML files as Text fields, with additional data. (1 GB in data.)A DataServiceHost REST service wraps around this document entity to send the data to a client application. A client application is calling the REST service to retrieve documents.
I cannot modify the server/service code. All I can work with is the client. And the client connects easily to this REST/web service and is able to retrieve data. But when accessing the documents that it has stored, I run into problems, most likely because it tries to send the whole list from server to client. And 1 GB of data is way too much. So, the service is called XMLData, the data is DocumentEntity. Something like:
foreach (DocumentEntity Document in XMLData.Documents)
{
DoSomething(Document);
}
Fails, since it loads all documents first. It then fails with "Object reference not set to an instance of an object." possibly because the server times out or whatever. Doing the same with another table/entity on the same server just works fine. Now, by using XMLData.Documents.First() I can access the first record without any problems. But how do I tell the system to get the next one? That way, I can iterate through all documents one by one...
And again, I cannot modify the service code. Only the client code. The service is fixed in production.
How to create simple web service in VS2010 Professional (trial version). There is no template to do this. I am not trying to create WCF service here.
View 2 RepliesI am using asp.net 3.5 and in a page i want to make 3 coulmns editable. I don't want to add Edit button. I have Save Button, which i want to use save all the record.
[Code]....
When I am running the page coulmns are not editable. How can we make editable coulmn.
i am trying to create an asp.net service where it can delete specific records from the databas, this is by code so far:
[Code]....
this is the error i am getting
[Code]....
the code that it refers to by line 134 is myDataAdapter.Fill(delds, "comments"); so i guest is somthing to do with the .fill
i want to create a web service which consists of CRUD operations Create, Retrieve, Update and Delete. creating web methods on insert and update operations.
View 2 Replies1 My DataTable Return following Data
Acct Books Annual
Acct Books Monthly
Acct Tax Income Tax
Admin GH Eqpt
Admin Offc Eqpt
Admin Offc Misc
Admin Offc Eqpt
[code]...
I would like to locate the new record in a paged list after the record is inserted to the database. Say there are 10 pages of records. Each page is size of 20 records and sorted by last namez of people. I add a new record with last name Murray. Using MVC, how do I position to the page where Murray is after a post back? The controller's New action return to Index view, but it always return to the first page.
1. How do I make the Index method or some other method to go to page where newly inserted record is.?
2. How do I make the browser scroll to the row where the newly inserted record is in a NON-paged list?
how can i display two columns in a list box?
View 5 RepliesI am using VS 2010, C# and Sql Server 2008.From the database, i am returing a list, which contains around 25 columns. am binding the list to the grid. After the list is binded, i am trying to create a dataset from the list. But I would like to have only 5 columns in the dataset, out of the 25 columns returned from the list. How to achieve this?This is the code I have used now:
[Code]....
I want to pass columns like, schoolid, schoolname,courseoffered,Ranking,Dateofopening from the list to the dataset .How to pass the columns from the list to create the Dataset
I have three dropdown lists which perform as cascading lists. #1 sets the filter for #2 and then #2 does the same for #3 (standard stuff). Each dropdown gets its data from queries to separate tables.
My problem is when I pull data from an existing record and assign the data fields to the controls using the datareader the second list will not allow me to assign a value to it.
The dropDownAssetGroup.SelectedValue sets easily to assetGroupID but the dropDownAssetType.SelectedValue won't take the value of it assetTypeID (which does get the correct value), it stays as "". The values in the existing records are contained in the dropdown's items, and were even populated from the same controls.
[Code]....
why my code to populate a drop down list is skipping the first recrod in the database?
Private
Sub Engine()Try
conn =
Dim conn
[Code]....
I use MySQL database and SqlDataSource controls. I generate update and insert queries in my code behind.how I can get a list of columns from the SqlDataSource control?
View 2 RepliesI am having trouble listing two columns from a SQL database into a DDL. I dont want to concatenate them but just want to list them down as a list in the DDL.Here is the code for the DDL which currently is concatenating the two fields:
<asp:DropDownList ID="DropDownList10" runat="server"
DataSourceID="SqlDataSource3" DataTextField="Vendor_Name"
DataValueField="Vendor_Name"
[code]...
I've got Gridview returning a list of records in response to query... NOW, from that list of records, I need to be able to select ONE of the records, show it online in another form (some kind of data "Tool") AND also write the record to another table in an Access database...
View 23 Repliesi am using a list view to view, insert, update and delete my data for the admin page this admin page made for the news and we have categories for that so i need to use a drop down list for these categories and when the admin choose on of these categories records its value as an ID to the database.
[Code]....
I am using a Reorder list. I had a requirement that i have to drag a record from the reorder list to another control(may be list control or grid view). Is it possible like that?
View 1 RepliesI would like to know if there is a way that I can use DISTINCT on one column's values but need to show other columns where the value of the DISTINCT column is equal to another table's column
View 7 Repliesbeen trying long time now to style the width of columns of a checkbox list, trying to group text by similar lengths, something like this:
small width [] wider width here [] widest width of all here []
small wid [] wider width h [] widest width of all h []
small widt [] wider width her [] widest width of all her [] (of course the checkboxes line up in the actual form)
so smaller length texts are not too far away from their checkbox, the checkboxlist control seems to have an iron grip on those col widths