ADO.NET :: Linq And Webservices / Create A Webservice Method Using LINQ Technology And To Populate A Dropdown In a Form?
Oct 6, 2010
I am struggling to create a webservice method using LINQ technology and to populate a dropdown in a form. Here is the Webservice code.
[WebMethod]
public
string[] GetAllCountries()
{
LinqClassesDataContext db =
new
LinqClassesDataContext();
var q =
from c
in db.ListContinents()select
c;
return q.ToList() ;
}
And here is the form code behind
protectedvoid
Page_Load(object sender,
EventArgs e)
{
WSClass WS =
new
WSClass();//bool
ds = WS.GetAllCountries();
var v = WS.GetAllCountries();
ddlContinent.DataSource = v;
ddlContinent.DataBind();
}
View 5 Replies
Similar Messages:
Dec 1, 2010
i am trying to use LINQ to populate a drop-down. This code works fine on my local machine, but I get an error when I try to run it on the live site.
The error occurs on this line: ddTicketMasterRoles.DataBind()
The error message is:
.Read_VB$AnonymousType_0`2(System.Data.Linq.SqlClient.Implementation.ObjectMaterializer`1<System.Data.SqlClient.SqlDataReader>)
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.MethodAccessException:
[code]....
View 1 Replies
Mar 16, 2011
Here is my Controller:
public class MatchManagerController : Controller
{
//
// GET: /MatchManager/
public ActionResult Index()
{
return View();
}
public ActionResult CreateMatch()
{
return View();
}
}
Here is my View:
@model MatchGaming.Models.MatchModel
@{
ViewBag.Title = "CreateMatch";
}
CreateMatch
@using (Html.BeginForm()) {
@Html.ValidationSummary(true).....
I want my MatchTypeId to be a drop down that populates from my table MatchTypes.
View 1 Replies
Sep 23, 2010
I am wondering into the unknown field of OOA and was looking for a way to separate my business logic from my UI. A small example is as followed:
Two DropDowns where the second one is depended on the selection in the first DropDown. You have Cars, planes, etc. inm the first DropDown and Toyota, Chrysler, etc in the second (depending on the value in the first DD.I have som Lin syntax. The file is situated in the App_Code folder and NOT as code behind. [Code]....
I would like to know how i can make populate my second Dropdown list with results. At this point it's just putting in the complete ProductSubCategory.
View 2 Replies
Apr 13, 2010
I am creating an Asp.net web site which will support dynamic data. When I am creating a dynamic web site from Scratch (from template in VS) all is working fine. But when I am trying to add dynamic entity (.edmx) file and running the application I am getting following error
"The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'. "
View 2 Replies
Dec 20, 2010
I have a simple page that looks up contacts using a webservice with a single method written in Linq. On the page, I have both a gridview and a listview with a DataPager to compare the two. I can get paging working just fine with the gridview, but the Linq code has to return all of the data on each call and let the web page pick out only a page's worth... not the best solution. I have been told that a ListView will solve this problem, but all the examples I have been able to find have the Linq code on the web page instead of in a separate layer (e.g. a webservice). Ideally, I should be able to tell the web service to bring back a specific page worth of data (starting record number and number of rows), but how do I get the ListView (or the DataPager) to fire an event that asks for this data?
Here is the ASPX code:
<asp:ListView ID="listPersons" runat="server"> <LayoutTemplate>
<table> <thread> <tr> <th> Site ID </th> <th> PersonID </th>
<th> Person Name </th> </thead> <tbody>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" /> </tbody> </table>
<asp:DataPager ID="Pager1" runat="server" PagedControlID="listPersons" PageSize="5" > <Fields>
<asp:NextPreviousPagerField ShowFirstPageButton="true" ShowPreviousPageButton="true" ShowNextPageButton="false" ShowLastPageButton="false" /> <asp:NumericPagerField />
<asp:NextPreviousPagerField ShowFirstPageButton="false" ShowPreviousPageButton="false" ShowNextPageButton="true" ShowLastPageButton="true" />
</Fields> </asp:DataPager> </LayoutTemplate> <ItemTemplate><tr> <td> <%# Eval("SiteID") %>
</td> <td> <%# Eval("PersonID") %> </td> <td> <%# Eval("PersonName") %> </td>
</tr> </ItemTemplate> <EmptyDataTemplate> No data found... </EmptyDataTemplate> </asp:ListView>
Here's the code behind:
private void DoList(string Match) {
ContactsService cs = new ContactsService();
listPersons.DataSource = cs.Find(Match, 100 ); listPersons.DataBind(); }
and the web serivice:
[WebMethod]
public List<Person>Find(string Match, int Count) { if (Count < 5) Count = 5;
using (DataLayer.ContactsDataContext context = new ContactsDataContext()) {
var Persons = from p in context.Persons where p.PersonName.Contains(Match)
orderby p.LastName, p.FirstName select new Person() {
SiteID = p.SiteID, PersonID = p.PersonID, PersonName = p.PersonName, };
return Persons.Take(Count).ToList(); } }
View 1 Replies
Jun 1, 2010
Now I know there is a reason to this odering but my tiny little brain can't get my head around it.I am using a webservice to pull through data to a webp[age and have the following that is so far pulling data through from UUF1:
public string[] GetBuyer(string Memberkey)
{
try
[code]...
View 2 Replies
Nov 6, 2010
I am trying to populate an autocomplete with a LINQ query. The method I am calling returns data, but for some reason the autocomplete that appears on screen is empty. Here is my code.
[Code]....
View 4 Replies
Oct 4, 2013
How to use linq in asp.net like insert, update, delete and search the records,
Bind Gridview using linq
Bind Dropdown using linq
View 1 Replies
Nov 29, 2010
Here's my C# cobe behind:
[Code]....
[Code]....
No data is loaded when the button (btnSearchWrd) is clicked. Instead, in the Firefox Error console, it listed these two errors:Error: item is undefinedError: ys.WebForms.PageRequestManagerServerErrorException: Could not determine a MetaTable. A MetaTable could not be determined for the data source '' and one could not be inferred from the request URL. Make sure that the table is mapped to the dats source or that the data source is configured with a valid context type and table name, or that the request is part of a registered DynamicDataRoute.
View 2 Replies
Apr 5, 2010
I have a partial class extending my Entity Model. I'd like to write a method that returns a collection of types from my entity framework model. For example, I'd like to get all the states to populate a drop down list. So I've written a method called getallstates(), similar to the example below:
[Code]....
I tried returning a list of Objects, and a list of states to my calling method to be used to bind to a drop down list. However I get an error that:
Server Error in Application. Unable to cast object of type 'System.Data.Objects.ObjectQuery to type 'System.Collections.Generic.List`1[System.Object]'.
What should my return type be for this function?
View 2 Replies
Aug 25, 2010
I'm trying out EF4 as part of a .Net 4.0 WCF service. The aim of the service is to return document data as an array of entity objects to any of our ASP.Net apps. The apps are still in .Net 2.0. Due to the nature of the solution I've disabled LazyLoading at context level. I started with this:
[Code]....
Everything works ok, I receive the correct number of populated objects. However when I add an Include into my query to allow us to pickup fields from a related table that has a defined navigation only the first record is returned fully populated to a calling application:
[Code]....
The array is the correct size but all elements after the first are blank, default placeholders. Its like using the Include has reverted to LazyLoading and I can't seem to kick it into line.
View 3 Replies
Mar 6, 2011
I am tring to learn linq to sql (and programing in general). I have created my CRUD stored procedures and dragged and dropped them from my db to dbml. Now how do I use the methods that were created?
View 3 Replies
Feb 4, 2010
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]....
View 1 Replies
Mar 26, 2010
I am use the new ASP.NET MVC 2 and Entity Framework, but when I try to create a new view with strongly-typed option selected, the entity objects is not appears at dropdown and I cannot use the view creation wizard. I recompile the solution, but still not appears yet. Have any workaround that I forgot to do to enable the entities to be displayed at dropdownlist ?
View 5 Replies
Jul 19, 2010
i want to validate dropdownlist which is bound to objectdatasource. i am using following code but the listitem <asp:ListItem Value="-1">Select</asp:ListItem> doesnot appear. it shows only items that are stored in database. please help me how can i validate this dropdownlist.
<asp:DropDownList id="drpdwnFID" CausesValidation="true" runat="server" DataSourceID="objDtsrcForums" DataTextField="Title" DataValueField="ForumID" >
<asp:ListItem Value="-1">Select</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="rqrValidDropDwn" InitialValue="-1" ErrorMessage="Select Forum" runat="server" ValidationGroup="submit" ControlToValidate="drpdwnFID" Display="None"></asp:RequiredFieldValidator>
View 2 Replies
Mar 8, 2011
I am building a web application in asp.Net 4.0 and entity framework. I am trying to retrieve a list of products based on a collection of id's. I first gather all the id's in a collection and then pass it to the linq query. I am trying to get a functionality similar to the IN clause in SQL. The problem seems to be with the Contains() method in the Linq to entities query. Here is my Linq code:
[Code]....
I got the above Linq to entities method from here: [URL]
View 2 Replies
Mar 4, 2011
have following method which returns "List"
public List<DistributionGroup> GetDistributionGroupsByUserId(Guid userId)
{
return (from dgu in db.DistributionGroup_Users where dgu.UserId == userId select
[code]...
View 3 Replies
Mar 9, 2011
I'm really new to ASP.Net and for a school project we have to create a login form. Now I have managed to create a login with LINQ doing the following:
[Code]....
And in my html page:
protected void Test_Click(object sender, EventArgs e)
{
if (Class1.Controle(Convert.ToInt32(txt1.Text), txt2.Text))
[Code]....
I was thinking something amongst those lines, but I can't call p.GebruikerWachtwoord. So I'm guessing this is completely wrong.I hope somebody can help me figure this out, and I apologise for the poor explanation, English isn't my native language.
View 3 Replies
Mar 11, 2011
I am using LINQ and sending a linq object to the view and trying to show it in a textbox like this
<%=Html.TextBox("petname",Model.PetName) %>
But I am getting error, how can I show (PetRecord.PetName) which is my linq entity
View 1 Replies
Apr 2, 2011
I have a small issue binding the values into a dropdown using LINQ in ASP.NET code-behind.
var clientquer = from i in Entity.New_Bank select i;
//var q = (from s in names
// select s).Distinct();
// var getlendername = (from db in mortgageentity.New_Lender group db by db.Bank_Name into t select t.Key).ToList();
if (clientquer.Count() > 0)
{
ddlbankname.DataSource = clientquer.ToList();
ddlbankname.DataValueField = "Bank_ID2";
ddlbankname.DataTextField = "Bank_Name";
ddlbankname.DataBind();
}
It is binding with duplicate values, but I don't want bind duplicate values. I'm trying to solve this by using a group by clause, but it is not working.
View 2 Replies
Jan 24, 2010
I have a test web service called: MySimpleService.svc with a method called:GetUserNamesByInitials. below is the Linq to SQL code:
[OperationContract]
public static string GetUserNamesByInitials(string initials)
{
string result = ""; [code]...
what I do is to type the user id in one textbox (TextBox3) and when I press the Tab key the result is shown in another textbox(TextBox4).
The jQuery call works well with other methods that do not call the database, for example using this other web service method it works:
[OperationContract] public string ParameterizedConnectionTest(string word)
{
return string.Format("You entered the word: {0}", word);
}
However with the Linq method it just does not work.
View 1 Replies
Jan 14, 2010
I've been scratching my head for what seems like ages. I'm sure its really simple to fix but I can't see it.
I have a class in App_Code that uses a bit of Linq.
var siteMap = SiteMapWrapper.BuildSiteMap(true);
var currentTopLevelParent = siteMap.Single(s => s.IsActive);
if (currentTopLevelParent != null)
I've developed this locally and all works fine. When I transfer to IIS hosting the same class fails to compile. I receive:
does not contain a definition for 'Single' and no extension method 'Single' accepting a first argument of type 'SiteMapWrapper' could be found (are you missing a using directive or an assembly reference?)
I confirmed that the virtual dir is running .NET 2.0 as it should. I also confirmed that the correct assemblies are being loaded in the web.config.
<compilation debug="true">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
</assemblies>
</compilation>
View 3 Replies
Sep 7, 2010
I want to access the data from datatable object. When i trying to get the fieldslist usng "Field" method. But I could not find the method with my table object. Eventhoguh i forcibly write a method and trying to access the fields, It is giving the below error for the first join in query. Rest of the lines are fine.
What is the reason behind it.
The errro: "Error 2 'LINQ2DB.SP_VS_OP' does not contain a definition for 'Field' and the best extension method overload 'System.Data.DataRowExtensions.Field<T>(System.Data.DataRow, string)' has some invalid arguments"
What is the meaningof the error. Shall i do any other changes in the query line?
var QueryChnl = from oSPOP in SPOP.AsEnumerable()
join oDiscChannel in DiscChannel.AsEnumerable() on oSPOP.Field<int>("spid") equals oDiscChannel.Field<int>("SPID")
join oChannel in Channel.AsEnumerable() on oDiscChannel.Field<int>("channel") equals oChannel.Field<int>("channelID")
where oSPOP.Mappingkey == 3200004
select new { oSPOP.Mappingkey, oChannel.channel, oDiscChannel.STATUS };
View 1 Replies
Aug 26, 2010
I have an application that has JS calling ASMX files to do asyncronous requests, using ASP.NET AJAX.
The problem is that I use always the same "onError" function, and now I don't know how to identify the method that rised the error, and it is giving me a lot of problems to debug errors. The parameter "data" of the onError method does not give enough information, for
example:
en System.ComponentModel.BaseNumberConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
en System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeInternal(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)
en System.Web.Script.Serialization.ObjectConverter.ConvertObjectToTypeMain(Object o, Type type, JavaScriptSerializer serializer, Boolean throwOnError, Object& convertedObject)
en System.Web.Script.Serialization.ObjectConverter.ConvertObjectToType(Object o, Type type, JavaScriptSerializer serializer)
en System.Web.Script.Services.WebServiceMethodData.StrongTypeParameters(IDictionary`2 rawParams)
en System.Web.Script.Services.WebServiceMethodData.CallMethodFromRawParams(Object target, IDictionary`2 parameters)
en System.Web.Script.Services.RestHandler.InvokeMethod(HttpContext context, WebServiceMethodData methodData, IDictionary`2 rawParams)
en System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)
Is there any way to know the webmethod that raised the error?
View 1 Replies