I need to write a webservice that returns multiple rows from a table. I am familiar with return of a single object.
I am calling a stored procedure in the webservice that populates a data table.
I guess I need to define an object collection to be returned. Should this be an array or can I return the data table itself?
I am trying to create a dynamic table that is being built based on the value of a search text box. The Table will have probably 6 columns of 20(max) rows.
My problem is I can't figure out how to return the data from the web-service to the JS function in a way that will allow me to extract the data that I need.
Here is the web-service method I have currently:
[code]....
I tried it and it only returns the first table.
View 2 RepliesI m working on one page. It has three table for select, Insert and Update.
I wrote the join query for select statement. also i wrote the three Insert and Update statement.
i have some fields on one page which fields suppose to insert in one table. How can i Insert the multiple records into one table from one page using only one save button.
how to insert records in multiple table using with foreign key with linq to sql?
View 2 RepliesI want to insert multiple records to a table in bulk and I want the whole operation to fail(rollback) if one of the inserts has an error .how do I go about this ?
View 1 Repliesi am new to this linq concept,
i have used the following code to delete multiple records in my table,
but when i hit the button insteading deleting multiple records only one record is getting deleted
below is the code
protected void Button1_Click(object sender, EventArgs e)
i have edit problem...still i giving u a code of index that showing a records or multiple table how can i edit that record?
TaskManagerDataContext _Context = new TaskManagerDataContext();
[Authorize]
public ActionResult Index()
{
var userId = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString());
TaskRepository getTask = new TaskRepository();
var taskInfo = getTask.GetByUser(userId).ToList();
return View(taskInfo);
}
// Class TaskRepositor
public List<TaskDetailModel> GetByUser(Guid userId)
{
var getTask = from taskData in _Context.Tasks
join projectData in _Context.Projects on taskData.ProjectId equals projectData.ProjectId
join typeData in _Context.TaskTypes on taskData.TaskTypeId equals typeData.TaskTypeId
join statusData in _Context.Status on taskData.StatusId equals statusData.StatusId
where taskData.UserId == userId
select TaskDetailModel.CreateModel(taskData.TaskId, projectData.ProjectName, taskData.TaskName, typeData.TaskType1, statusData.Status1);
return getTask.ToList();
}
//Class TaskDetail Model
public class TaskDetailModel
{
public static TaskDetailModel CreateModel(int id,string project, string desc, string taskType, string status)
{
return new TaskDetailModel
{
Id = id,
Description = desc,
Project = project,
Type = taskType,
Status = status,
Date = System.DateTime.Now.ToString()
};
}
public int Id { set; get; }
public string Description { set; get; }
public string Project { set; get; }
public string Type { set; get; }
public string Status { set; get; }
public string Date { set; get; }
}
I have a web service that runs a query (from C#) to get a dataset from sql server. I get the following time out error. Googling on this error says, you can set the timeout on command object. But I am not using command object to set the timeout. This is the code I am using to get the dataset.
code:
[code]....
I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.
View 3 Replies[code]....
What's wrong?
Edit: And what if I need to return {Message:'',Type:1} ?
Edit2: The answer for the last one is: I can return a Dictionary<string, string>
I have function called getdoctor () in asmx file I wannna call this webmethod from javascript and get the result into flat text i.e i wanna get the name doctor name not in neither in xml or json
View 2 Repliesi have a data library dll and first is it possible to use it in webservice forexample i call it as using DataLibrary; then in web method i will use it like
public boolean MethodName(int a)
{
if(DataLibrary.Method(a))
return true;
else
return false;
}
and also i have to tell my all data connections are in DataLibrary.dll
my second question is i will use webservice to communucate with flash i will send flash a DataSet but flash cant read DataSet so i have give it as XML right?
so how could i change my following method which returns dataset to return xml ?
[Code]....
I can fill and then return typed dataset from a web method, but applying these steps by using Typed Datatable instead of Typed Dataset I cannot return filled typed dataTable. So, is it possible to return typed dataTable from a web method? If yes, how can I do this?
I shall give a little bit information about my project. There is 3 project in my solution.
I) Presentation Layer (WinForm), II) Business Layer (Web Service) ,
III) Data Access Layer (Win form project type)... The problem is that;
I use 2 seperate methods. 1st is FillTable() which fill a datatable in my Typed Dataset in Data Access layer. The 2nd isGetTable() which should return typed datatable filled by FillTable() method. I try these methods and FillTable() methods (goes from I. layer to II. Layer and then III. layer) fills a datatable properly and after that I can return this datatable by calling GetTable() method from Typed Dataset (in III. layer) to WebService. I have tested the rows count of returning datatable and there is no problem up to WebService. But even after returning this typed datatable from WebService the table comes to Presentation Layer empty. So, there is a problem returning filled typed datatable from WebService to WebForm (from II. layer to I. layer).
On the other hand, if I try this methods by returning Typed Dataset instead of Typed Datatable, I can return properly with a filled datatable in Typed Dataset. But, I relly do not want to return a huge filled dataset which may contain 15 tables instead of one datatable. My questions;
1) Is there any logical approach mistake on my Layer Architecture?
2) What should I do in order to get a Typed Datatable from Web Service (II. Layer of my project)?
i want to return a dataset, and consume it in the asp pages
how can i do that
suppose a dataset has 100 records, then how do i consume it in other websites
I know i've seen a tutorial for this, but can't locate it anymore. I have a class Employee in c# side, I also have a webservice where I pass in an ID# and an Employee object is returned. Now I want this object returned to Javascript code, I know I've seen it done before, can someone point me to a tutorial that shows something like this being done. I'm using the MicrosoftAjax.js file.
View 3 RepliesI am building a webservice that reads some HTML source code from a website and sends it back to the client. The service however is failing to send the data because it is too large. I keep getting this error:
The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter [URL]..... The InnerException message was 'There was an error deserializing the object of type iRacingForumServiceTest.ForumService.GetForumListResponseBody. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 153, position 247.'. Please see InnerException for more details.
I have been googling this problem for ages and I cannot figure out how to apply the answers I keep finding.
The problem is simple: the default configuration doesn't allow such large strings. I just don't know how to change this. All I keep finding is things related to WCF, I'm not sure if that applies for me.
What I keep finding is that I need to change the web.config file in various ways. However I cannot figure out where I need to put the config sections. I've tried everything but without a complete web.config file example I can't get it to work
Here is my current web.config of the server:
Code:
<?xml version="1.0"?>
<configuration>
<configSections>
</configSections>
<connectionStrings/>
<system.web>
[Code] ....
I found this piece to add to it:
Code:
<system.serviceModel>
<services>
<service name="ForumService">
<endpoint address=""
binding="basicHttpBinding"
[Code] ....
I figured out where to put it without getting errors (just as a child of the <configuration> element), but it just doesn't work. I get the same error no matter what values I try here... This shouldn't be such a difficult issue, how can I solve it?
So I've created a default Visual Studio project for a webservice and I invoked the HelloWorld method. What I get is indeed a "Hello World" string, but with some additional "crap" attached:
Code:
<style>
@namespace url(http://www.w3.org/1999/xhtml); [src="http://static.addtoany.com/buttons/share_save_256_24.png"] {display: none !important;} #a2apage_dropdown {display: none !important;} #socialBotAdd, .addthis_button, .addthis_toolbox.addthis_default_style, #addthis_link, [onclick="return addthis_sendto()"] {display: none !important;} #greet_block {display: none !important;} .meebo-00 {display: none !important;} #wibiyaToolbar, #wibiyaToolbar_window_template {display: none !important;}
</style>
Where is this stuff generated? And how can I remove this.
I'm calling a web service called GetTooltip from inside Javascript. However, since the web service is called asynchronously, it doesn't wait until I get the return value from the web service, before it continues again. This is a bit of a problem for me, since the web service is in a for-loop. How do I make the Javascript wait until I hear back from the web service, before letting Javascript continue the for-loop?
[code]....
vs2010, .NET 4.0I have a webmethod which I want to return a data record (for example: name, surename, address, age, zip etc)I wonder how to accomplish this. I think the solution is about creating an object which contains all the records serialized. And then the webmethod returns this serialized object. I'm not 100% sure how to accomplish this, if some of you good provide me with some tips, tutorial or link to an article explaining it, that would be great
View 1 RepliesActually I am trying to learn jQuery Ajax calls to asp.Net webservices.
I have been trying to call the webmethod below:
[code]....
Do I need to serialize my object in some way before setting the 'data' attribute, so that I can call $.ajax() function?
I have faced the peculiar case in Sql server's Inner join. I have 2 tablesFor example:Table Name: A and B I have shown the below code.
Select
* From A
Inner
Join B
ON A.JobCode
=B.JobLookupID
This select statement return 500000 records but both table did not have that much recordsI have shown the Records in every table:A=19396 and B= 25366 records.How it will return more then 5 lakh records in above select statemenet?. Please let me know if any one faced this issue earlier?
I have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
[Code]....
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?