When i type and run the following query in ASP.net, then get a error ("Comparison of the data types ntext, text, XML and image data types can not be processed by SQL Server.") (translated from Dutch...)
var gebruikerrow = from u in db.Users
where u.login=="dsf"
select u.login;
foreach (var Result in gebruikerrow)
{
Label50.Text += Result.ToString() + " ";
}
What am i doing wrong?
the Datatype for login (in the table Users) is Text.
I have records with and without a email entered in the field called 'email'.
This one works:
Return From p In db.myTable _
Where p.Email.Length > 0 _
Select New With {.p.Name, p.Email}
but this doesn't
Return From p In db.myTable _
Where p.Email.Length = 0 _ ( nor does Where NOT p.Email.Length > 0 )
Select New With {.p.Name, p.Email}
Am I missing something?
This query does not return any record
[code]....
I'm looking to translate an SQL query into linq
INNER JOIN Usrs ON
SAQ.UserId =
Usrs.UserId AND Scan.UserId =
Users.UserId
I'm not sure how to include the "AND" in the LINQ statement.
I'm having trouble writing what should be a simple sub-query using LINQ to Entities. I have two tables: Customers and Orders that have a relation on the CustID field. Not all Customers have a record in the Orders table, while some have mutiple records. In traditional SQL, you could write the query like this: SELECT * FROM Orders where CustID IN (SELECT CustID FROM Customers) I know this could be done as a JOIN in both SQL and L2E, but my actual query is more complex (about 8-9 joins), so I am hoping to find a L2E sub-query equivalent. Something like this:
[Code]....
I know LINQ to Entities does not support the " IN " clause, so I am looking for something that will work in its place.
i'm trying to make this work for several days but it just doesn't work.
this is my code:
aspx page:
[Code]....
webservice:
[Code]....
this was downloaded from this website.
the problem is that the page loads fine but no autocomplete occurs.
I want to use "if statement" in Linq query. How can I do this situation?
For example:
if txtAge.Text=="", I will not use that in Linq Query.
else txtAge.Text!="", I will use that in Linq Query.
I've build a linq query.But i want a random selection so its not always ID : 1,2,3,4,5,6 How can i randomize this var? I like to bind it to a repeater.//TagCloud:
Random rand = new Random();
var tc1 = from i in JumpTide.cms.menu.GetMenuItems(32)
select new
[code]...
I am a new to WCF. I have written ajax to use a web service before, but on this project I am trying to use ajax to WCF.After I build the project and wcf using ajax, I receive the return successfully. But, 10 or more minutes later I don't get a return, the ajax calls the error function, and the fiddler returns nothing.
If I rebuild the project without any source modifying, I receive the return successfully again.
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 RepliesI am facing a big problem with simple linq query.. I am using EF 4.0..
I am trying to take all the records from a table using a linq query:
var result = context.tablename.select(x=>x);
This results in less rows than the normal sql query which is select * from tablename;
This table has more than 5 tables as child objects (foreign key relations: one to one and one to many etc)..
This result variable after executing that linq statement returns records with all child object values without doing a include statement.. I don't know is it a default behavior of EF 4.0 . I tried this statement in linqpad also..but there is no use... But interesting thing is if I do a join on the same table with another one table is working same is sql inner join and count is same..but I don't know why is it acting differently with that table only.. Is it doing inner joins with all child tables before returning the all records of that parent table?
I am writing a linq query to select a blogpost,
[code]....
The blogpost i am testing got 3 tags attached to it. The table structure is:
(table)BlogPost -> (table)BlogPostTags <- (table)Tags
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
I have a web app for our golf club. When I compute handicap index for each golfer, I have to select the most recent scores and then a subset of those scores depending on how many rounds of golf the golfer has played. All the scores are entered into a single SQL Express table called "Rounds". Verbally, this is what I'm trying to do:
1) select the twenty most recent golf scores (sort on date descending, "take(20)") [if less than 20 records, then select all available];
2) for this set of records, select the 10 lowest scores (or smaller number if golfer has less than 20 rounds);
3) compute the average round differential for the subset of records, etc. to calculate handicap index (this step is working ok...)
My current VB code has this LINQ query (which is flawed -- it selects the lowest handicap differential scores of ALL records for the filtered user):
[Code]....
How do I modify this query to accomplish items 1) & 2) above? It seems this should be simple, but my experience with queries is still limited.
I am trying to save an updated xml file to a url like this:
Quote:
//save the output to a file
xmlDoc.Save("http://www.example.com/HomeNewsLinks.xml");
But I get this error: URI formats are not supported.
Did some google search on this and it seems I need to use client.uploadFile method, but I am not able to find how to declare/define filenamexxx (below) and how to pass a username/password.
Quote:
WebClient Client = new WebClient();
Client.UploadFile("http://www.example.com/HomeNewsLinks.xml", Post, filenamexxx);
I used this,
<a title="Logout" onclick="javascript:document.getElementById('ctl00_ContentPlaceHolder1_LbLogout').click();" href="#" class="logout">Logout</a></li>
<asp:LinkButton ID="LbLogout" runat="server" style="display:none"
onclick="LbLogout_Click">Sign out</asp:LinkButton>
I am following though the examples in Professional ASP.Net MVC 2 and one of the examples doesn't work for me.
[HttpPost]
public ActionResult Edit (int id, FormCollection collection)
{
Dinner dinner = dinnerRepository.GetDinner(id);
if (TryUpdateModel(dinner))
{
dinnerRepository.Save();
return RedirectToAction("Details", new { id = dinner.DinnerID });
}
return View(new DinnerFormViewModel(dinner));
}
I understand that it's suppose to take the values from the FormCollection, and then update the dinner object with it, bit I don't see the collection get referenced anywhere.
I have div which it is hidden by default , when the use clicks show link the following javascript method is called:
function ChangeControlVisibility(elementID) {
var element = $("#" + elementID);
if (element.css('display') != 'block' && element.css('display') != 'table') {
element.show();
[code]....
this step works but when i call the previous method at page_load event the method doesn't work:
element.css('display') undefined.
[Code]....
And in default.aspx, the code is
[Code]....
But it is not working, the error is at alert(BiblePeopleArray(0));
I have a Gridview in UpdatePanel and a textbox in which i input a string, the row is searched from gridview onkeyup of textbox.For example when i entered "testing" one row is displayed in gridview having "Edit" command and when i clicked on "Edit" it goes to top of the row having another data is converted into edit mode but that rows is not changed into textbox.
View 8 RepliesI have such entities
Then I tried to retrieve node type from Node this way - Nodes node = Entities.Nodes.First(); string nodetype = node.NodeTypes.Name; but for some reason node.NodeTypes equalls null despite fact that there is some records in NodeTypes table.
I have a listview in which I use a pager control. When I have more than 1 item in the list view, I want the user to be able to click on the appropriate page number and go to it. Simple right?, right now the first time the user clicks on the page number, nothing changes. If they click on it again, it goes right to the page. It doesn't matter what page they click on, it ALWAYS requires a second click to display the data item.
I am using VS2010 C# as the code behind.
I know that UpdateProgress doesn't work with PostBackTrigger, but let me explain what i'm trying:
I'm generating a PDF document (Crystal Report) with ExportToHttpResponse that will be downloaded automaticaly by the browser.
So while the document is been generated, i'd like to show the UpdateProgress just while i'm waiting the doc is being generated, doing the UpdateProgress(or some label) to disappear.
I've been trying to fix something on a secure website (https) which is an Export to Excel button that generates a CSV file. It works on Firefox, Chrome , etc... but not in Internet Explorer. I have changed the headers eliminating the no-cache and also edited the IIS http header configuration setting an expiration date of 1 day. I have no idea of what can be going on and how to solve it. Do you guys have any idea of how to fix this stuff ? I've read so many posts and they're all saying the same thing... caching.
UPDATE 1 :
regarding the error I receive, I receive an IE Alert saying "Internet explorer cannot download filename.aspx from [URL]Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. As I said, it all works out of SSL (https), but the export to excel button, breaks in https.
UPDATE 2:
I'm using these headers:
Response.ClearContent();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=" + name.Trim() + ".csv");
Response.AddHeader("Cache-Control", "no-cache");
Response.AddHeader("Pragma", "public");
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.AddHeader("Content-Length", "2026");
Response.Charset = "";
//Response.ContentType = "application/vnd.ms-excel";
Response.ContentType = "text/csv";
i've log-in page in my site but log-in control doesn't work on any browser other than IE.
View 1 RepliesIam trying to use a UserControl named CheckBoxControl as value for the ExpandControlID/CollapseControlID attributes of the CollapsiblePanelExtender. It works fine when I use a normal CheckBox instead.
<uc:CheckBoxControl ID="ucHaftpflicht" runat="server" OnCheckedChanged="UpdateStatus" ControlLabel="Haftpflicht" />
<asp:Panel ID="HaftpflichtPanel" runat="server">
</asp:Panel>
<asp:CollapsiblePanelExtender ID="CollapsiblePanelExtender" runat="server" CollapseControlID="ucHaftpflicht.CheckBox" ExpandControlID="ucHaftpflicht.CheckBox" TargetControlID="HaftpflichtPanel" />
When I run the site, most ajax controls on my site disappear and I get following errors in firefox script error console:
Fehler: Sys.InvalidOperationException: Handler was not added through the Sys.UI.DomEvent.addHandler method.
Fehler: Sys.ArgumentException: Failed to find element "ucHaftpflicht.CheckBox"
Parameter name: CollapseControlID