DataSource Controls :: Use Group By / Giving Error?
Apr 5, 2010i want to use group by
var origina = (from m in _db.MeSetgroup by m.Categoryselect m)
but it have error in. how can i use group by in mvc?
Similar Messages:
DataSource Controls :: Stored Proc Giving Error?
Feb 2, 2010This is the sproc
ALTER Procedure [dbo].[spGetGroupDetails]
(
@inUserID Varchar(15),
@inGroupID numeric=0,
@inGroupName varchar(100) = null
)
As
[Code]....
DataSource Controls :: Linq Update Via .attach() Giving Entity Exists Error?
Jan 5, 2010I have a "simple" method that takes a Linq entity containing the information I want to update. The method then creates a list of counties the information is to be updated for, and tries to update the information for each county.
So user goes in fills form out selects update All counties, and the information in the form should be updated for all the counties for the member. Here is the code.
[Code]....
The first pass through the foreach runs perfectly, the second time through I get an error: Cannot attach an entity that already exists.
What is best way to work around this?
I have though about putting the foreach loop in my business_logic layer, and have it pass both the newRecord and OldRecord, but figured I would ask, before making the code change.
DataSource Controls :: Edit The Sqlprovider File In DotnetNuke - Giving An Error Like In Screenshot?
Feb 23, 2010I have edited the sqlprovider file in DotnetNuke as below. But it is giving an error like in my screenshot.
ALTER PROCEDURE [{objectQualifier}ICG_Auth_SaveSettings]
(
@PortalId INT[code]......
DataSource Controls :: Error 18 Cannot Convert Method Group 'ToList' To Non-delegate Type
Feb 17, 2010I am getting an error on the return saying
Error 18 Cannot convert method group 'ToList' to non-delegate type System.Collections.Generic.List<string>'. Did you intend to invoke the method?
DataSource Controls :: Adding Stored Procedure To Dataset1.xsd Giving Errors "An Unexpected Error Has Occurred"
Jul 31, 2010i am using paging technique from this tutorial [URL] and it is working fine, i used asp.net 2.0 with sql server 2005 then i upgraded to visual studio 2008, and converted the asp.net 2.0 application to 3.0 and now using sql server 2008 all the existingpages and .xsd files are working, fine, i can see data in .xsd files when i preview it but i cannot add new stored procedures it gives me an error "An unexpected error has occured" Error message:unexpected error i dont know what it is, already configured dataset (.xsd) works fine, it is just that iam unable to add stored procedures to new datasets my connection string
<add name="jobcon" connectionString="Server=HOME-46CTBUROCXSQLEXPRESS; Database=jobdhundo; User ID=; Password=;Timeout=200; Trusted_Connection=True" providerName="System.Data.SqlClient"/>
it is fine with the entire application there is no coding involved
Forms Data Controls :: Detailsview Giving Error
Oct 25, 2010Split off from [URL]
New error message:
Front page code:
[Code]....
Error List, front page (default.aspx) reads as follows:
Warning 1 The class or CssClass value is not defined. 11 59 Warning 2 The class or CssClass value is not defined. 43 32 Error 3 Name 'MetaModel' is not declared. 9 57
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30456: 'DetailsView1_ItemCommand' is not a member of 'ASP.default_aspx'.Source Error:
[Code]....
Source File: d:hostingcforedDefault.aspx
Line: 20
C# - Trying To Access Telerik RadEditor Controls In Master Page's Code Behind As Follows... Giving Error
Nov 3, 2010foreach (Control control in ContentPlaceHolder1.Controls)
{
if(typeof(Control).Equals(Telerik.Web.UI.RadEditor))
{
label1.Visible = true; label1.Text = "dhchk";
// control.CssFiles.Add("~/styles/myStyle.css");
}
}
Error;-
'Telerik.Web.UI.RadEditor' is a 'type', which is not valid in the given context
Also, is this the correct way to add CSS class to radEditor controls ??
control.CssFiles.Add("~/styles/myStyle.css");
I actually wanna add 3-4 customized classes..how to do that?
also I was wondering if I can add some javascript or something in my Master page that will detect the ALL the radEditor controls and set their css classes ? don't know much of Javascript..how can that be made possible? how do I go about that? but first I want css classes to be set in code behind..what's wrong with the code?
[EDIT]
@Geek..I tried calling like this..is it correct?
Control c = new Control();
DoSomething(c);
now its giving this error in the method:-
The type or namespace name 'c' could not be found (are you missing a using directive or an assembly reference?)
[EDIT]
I do have this namespace added "using System.Web.UI.WebControls;" why this error ??
DataSource Controls :: Configuring ObjectDataSource Not Giving Option To Select Correct TableAdapter
Sep 16, 2010So, I have 3 table adapters in my dataset, and trying to configure the objectDataSource will not give me the option to select the correct table adapter.
I set up a temporary website to illustrate what I am talking about, along with pics, not much, just 4 pics.
https://sites.google.com/site/configuringobjectdatasource/
The first 2 pics are irrelevant but just in case anyone thinking I don't have it set up properly. The other table adapters are working fine, which I have gridviews being populated etc.
why it will not give me the option to select aspnet_GetRecordDatesTableAdapter?
Forms Data Controls :: When Run The The Code It Is Giving The Error As "Index Was Outside The Bounds Of The Array?
Jan 6, 2011I am developeing web application using csharp. The the code is reading the text file load on to Gridview, but when I run the the code it is giving me the error as "Index was outside the bounds of the array."Where I am going wrong. The code and records are as follows:
[Code]....
Records on Text File
6/5/2010,Bun,2010,H,20,50040
6/5/2010,BUG,2010,G,26,90000
16/5/2010,COT,2010,B,26,45040
Forms Data Controls :: Insert And Edit Templates Of Formview Are Giving Error Message?
Feb 13, 2011I am using a formview on main web page and the Item template displays my data correctly but I get and error when I try and link to the edit or insert templates.This happens on our remote tesing server only.On my local machine running the page on the local server in VS 2010 everything works fine.But then doesn't it always work on your local machine.I might also mention that I am compiling for asp.net 4.0.
Here is the stack trace :
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'MYCORPABIGWEB01$'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
[code]...
Forms Data Controls :: Gridview Update Not Working / Giving Null Object Reference Error?
Jan 14, 2010I have a gridview,when i do it is giving me null object reference error.
I am posting my code for your reference -
[Code]....
My gridview code is -
[Code]....
DataSource Controls :: Get Last Record Of Each Group?
Apr 22, 2010This is my table.
I want ms sql query to get result
ID ProcessID Processname Date
105 123
Sammying 2010-04-22 12:09:02.827
DataSource Controls :: How To Select Top X Records From Each Group
Apr 7, 2010i have two tables (Users, Roles) and each user belongs to one role. Can I make a sql query that returns 10 newest users from each role in one query?
View 5 RepliesDataSource Controls :: Grant Execute On Sp To Group
Jun 11, 2010i have create a local Group (on server2003) name: Group_Test
SQL-Server:
i want to grant execute on usp_test. i have to specify the group with hostname
i tried
[Code]....
but it doesn`t work
DataSource Controls :: Group By Month - Format Like MM YY
Feb 13, 2010i have to Count Data Month wise and Date format would be like this Feb-10 and iam using the below query but no luck .
SELECT REPLACE(CONVERT(CHAR(9), ADate, 6), ' ', '-') As 'MonthYear', COUNT(AID) AS 'Planned' FROM Employee where Status =1 and YEAR(Adate) = '2009' GROUP BY YEAR(Adate), MONTH(Adate) ORDER BY YEAR(Adate),MONTH(Adate)
DataSource Controls :: Assign Sequence No To Each Group In Sql
Feb 27, 2010I have many record in the datatable and these record is grouped by section col. How can i assign seq no to record for each group in sql
section seq
A 1
B 1
A 2
C 3
DataSource Controls :: Displaying Group By Data?
Apr 29, 2010I'm trying to display using this query:
SELECT documentcategoryname, documentname, documentid FROM documents
INNER JOIN documentcategory
ON documents.documentcat = documentcategory.documentcategoryid
WHERE documentsiteid = @siteid
GROUP BY documentcategoryname, documentname, documentid
Which gives the following results:
documentcategoryname | documentname | documentid
About Us doccy3 3
About Us doccy4 4
Map Of Medicine doccy5 5
Is there a way using vb.net I can just display the category name once, and the documents underneath it like below:
About Us
doccy3
doccy4
Map Of MEdicine
doccy5
My code so far is:
If pagesreader.Read() Then
' output documentcategoryname
mydata &= "<h2>" & reader.Item("documentcategoryname") & "</h2>"
'display document list here using while loop?
End if
C# - IIS Server / Webpage Giving Error Some XML ERROR?
May 25, 2010whenever i needed to test my web site, i used to press ctrl and f5. i recently installed installed iis service. kept an html page accessed it from host kept an fully developed default.aspx page in the www directory tried to access gave error of XML something....that means i can only use HTML pages, ? so what to do if i am using c# asp.net? current i do not have the computer with iis installed so i cannot post the exact error message it was something like can not render XML (then it said something like unknown line)
"<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"
Inherits="_Default" %>"
DataSource Controls :: How To Display A Group Of Events When The Value Is 12/19/2010
Dec 19, 2010I've written this code to display a group of events when the value is 12/19/2010. This means each day I need to change the "default value" to the current date to display the events of the day. I would like to make this such that the change occurs automatically, that is, on 12/20/2010, I'd like to see just the events for 12/20/2010.
<asp:SqlDataSource ID="testeventdate" runat="server" ConnectionString="<%$ ConnectionStrings:testdateConnectionString %>" SelectCommand="SELECT [eventDate], [eventDesc] FROM [programEvents] WHERE ([eventDate] = @eventDate)">
<SelectParameters>
<asp:querystringparameter DefaultValue="12/19/2010" Name="eventDate" QueryStringField="eventDate" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
DataSource Controls :: Use SQL GROUP BY Statement To Create Menu?
Jan 27, 2010I'm trying to create a menu structure, subpages within pages, for use with my cms. I have 3 tables in sql server, I would like to query all three tables and list those pages with a certain siteid, and subpages where the subid is the pageid. how to use the GROUP BY Statement to create the menu below? Or could I use vb.net to display it for me? Something like this:
sitename
page
page
page
page
subpage
subpage
subpage
page
page
Here is my query so far:
SELECT * FROM sites
LEFT JOIN pages ON sites.siteid=pages.siteid
LEFT JOIN subpages ON pages.pageid=subpages.pageid
WHERE sites.siteID = 1ORDER BY sites.siteid, pages.pagesub ASC
These are my tables:
sites
siteID int Unchecked PK
siteName nvarchar(MAX) Checked
siteAdmin nvarchar(MAX) Checked
siteLive bit Checked
Pages
pageID int Unchecked PK
siteID int Checked FK linked to siteid in sites table
pageLink nvarchar(MAX) Checked
pageBody ntext Checked
pageSummary ntext Checked
pageTitle ntext Checked
pageOrder int Checked
pageHome bit Checked
subpages
subID int Unchecked PK
PageID int Checked FK linked to pageid in pages table
subBody ntext Checked
subSummary ntext Checked
subTitle nvarchar(MAX) Checked
subOrder nvarchar(MAX) Checked
DataSource Controls :: Linq Group Cannot Get The Data Returned
Feb 8, 2010I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.
[Code]....
DataSource Controls :: Order By Count And Group By In LINQ?
Mar 14, 2010How do I translate the following query into LINQ to SQL?
[Code]....
DataSource Controls :: List Duplicate Records And Group By Clause?
May 27, 2010I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.
I have 2 questions regarding it:
1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?
2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.
Adding all the remaining columns to the GROUP BY clause works.
Query is as below:
[code].....
DataSource Controls :: LINQ Query To Grab The Last 5 Rows From A Group?
Jan 8, 2010i have the following objects:
Event:
- EventID (PK)
- GroupID (FK)
- StartDate
Group:
- GroupID (PK)
- GroupName
What i need to do is select the last 5 events for each group using LINQ to Objects. I tried starting with:
[Code]....
But i'm not sure how i only take the last 5 per group.
The simple way of doing this is to get the groups and then have a property on that which returns the last 5 events but if i databind this i will have to use a nested Repeater/ListView. Ideally i would like to have a row foreach event.
