I have a trivial issue that I can't resolve. Currently our app uses Linq to retrieve data and get a basic integer value of the row count. I can't form a query that gives back a count without a 'select i'. I don't need the select, just the count(*) response. How do I do this? Below is a sample:
return (from io in db._Owners
where io.Id == Id && io.userId == userId
join i in db._Instances on io.Id equals i.Id **select i**).Count()
;
Im new for LINQ, how can i count the records in this code
[code]....
So i can say Count records and its = PValue so i can use that in a EVAL(PValue) and get the total value of the records.
I need to find the count of records between the first and last day of the current month.I am very new to linq and having doubts in getting the count, below is the code i have written.
[code]....
im trying to count the amount of users inside a chatroom, im trying to count a specific row using LINQ to SQL.
Heres the code
DataRowView dataRow = ((DataRowView)e.Item.DataItem);
string roomId = dataRow["RoomID"].ToString();
ChatRoomDataContext db = new ChatRoomDataContext();
var query = from c in db.ChatLoggedInUsers
where c.RoomID.ToString() == roomId.ToString()
select new { };
foreach (var c in query)
{
}
Where " select new { }; " is, is left blank as i am not too sure what goes there. I tried adding c.UserName.Count() but i got an error. what i need to put into that space to count the amount of records in the UserName column?
I am facing an intresting problem now with entity framework. if i did a count of the some table with linq statement its give some count and it is not matching with my normal sql query count. my sql query returning count of all the records in that table where as linq query returns some count which is less than sql count. is this a problem with my edmx or table navigation properties..i do have some 5 to 6 child tables inside this table with foreignkey relation. will it do a join on each child table and returns only those records. I am very much confused and don't know how to slove this.
View 9 RepliesI am wonder how I can generate a result table from linq to sql as below
Car sales table
Toyota small
Toyota passenger
Toyota small
Honda small
Honda small
Honda passenger
Honda small
result table
Brand small passenger total
Toyata 2 1 3
Honda 3 1 4
GridView1.DataSource = (from dtCarSales.AsEnumerable() .....
I have
Chart1["Series1"]
Chart1["Series2"] ....
It has multiple Series and each series has Several Data points.I want to find the count ( not sum but number of datapoints ) of Data points in all the series using LINQ.Currently i do
var count = from s in Chart1.Series
select new int[] { s.Points.Count };
And then for each thorough count and find the sum. Is there a better way to do this
How do I translate the following query into LINQ to SQL?
[Code]....
I am trying to figure out what are the basic assemblies required to run a basic ASP.NET 4.0 website. Say.. a website with just a label in it. I looked online and didn't find a list there. I know installing the framework 4.0 will give me all the dlls but I just need the basic ones that will make a basic site work on ASP.NET 4.0.
View 1 RepliesSay I have a table Comments with these columns: Id, Comment, Category, CreatedDate, CommenterIdI want to get the top 5 categories from the Comments table (based on the count of each category in that table). How can I do this in linq, to return either List or IQueryable?
View 2 Replies[Code]....
In above query I want to have top 10 rows as well as count of all rows.
In the GridView_RowUpdated event the e.OldValues.count <> e.NewValues.Count. 1 out of 5 columns has been converted to a template field.
View 9 RepliesWhen a user submits the query to SQL when clicking a button I need to get a count of the number of rows that are returned. Which event does the gridview.count code need to be place in?
Right now I have it in the btn_click event, but in order to get it to count the rows you have to hit the button twice since the query is not returned yet. Here is my code.
[Code]....
I HAVE A GRID VIEW IN asp.net + VB Code. There is a drop down list and the selected data is displayed in web page. I placed a label in web page and code behind i used following code.
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
Label1.Text = GridView1.Rows.Count.ToString()
Dim ONYO As Integer = 0
Dim DONE As Integer = 0
For i As Integer = 0 To GridView1.Rows.Count - 1
If GridView1.Rows(i).Cells(0).Text = "ON YO" Then
[Code] .....
How to add code to know visitors count and online visitors count ?
is there a good control or code ?
I use ASP.Net, C#.Net ad SQL Server
how can i use basic html tags(h1,h2 and <p>) in code behind.
View 4 RepliesI m looking for very basic level of asp.net web forms CMS.. not very mature one like umbraco.
View 2 RepliesFor the moment, I'm trying to learning some basic jQuery. But when I try to create a small thing with jQuery, it doesn't work. First, I thought that it was my standard browser Chrome that was not supported.
When I tried to render it in IE and Firefox, the result stays the same.
What do I wrong ?
Here u can find the code (ps I'm working with a master page, but I don't think that this has any influence)
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#orderedlist").addClass("tof");
$("#orderedlist > li").addClass("groen");
[Code]....
I am just taking a shot in the dark through this whole thing. I have an Addresses table with a StateID and CountryID field. They refer to the States and Countries table. I am using LINQ to SQL and Visual Studio 2010.In my AddressesController I have:
[Code]....
I created an AddressViewModel and it looks like this:
[Code]....
Then in my view code I have:
[Code]....
So when I try to go to Addresses/Create I get this error: ArgumentNullException was not handled by user code:Value cannot be null.Parameter name: itemsAnd it points to this line in the AddressViewModel:
[Code]....
It seems to me that any method of input I provide for a user needs some scrutiny, but I have never seen someone implement a single set of validation that all inputs must pass.
Is there some basic validation you do on every single field a user can type in to? For the sake of simplicity let's just talk about text boxes.
Do you add any code to watch for control characters?
I am following this tutorial and I am having trouble translating the following code to C# (there is no "Item" method in C#):
tempRow.Item("imgFile") = ("imgGrab.aspx?id=" & tempRow.Item("imgID"))
(tempRow is a DataRow)
I was under the impression till now that Global.asax is used for application level events and it's a common file for all users. Then what does Session_Start event does in this file. If we have to create user session varaibles then Is this the write place to create those? If someone can kindly clear my confusion on this file and it's methods.
View 5 RepliesI have set up the Profile correctly in the web.config file, however I can not use them in the Home Controller.ie: I have a property called FirstName I can not fetch that property and or set a value to it.I added System.Web.
View 7 Replieshow can i implement tagging in my asp.net website using visual basic. is there any online video tutorials? and how to show older tags or give new tags to any contents. secondly i want to know how to implement cloud tagging?
The say why of tagging this stake overflow is using right now. when we put the mouse on tags text box it suggest some older tags and also we can enter new tags.
In my asp.net MVC 3 web application, I want to implement basic authentication system in my webapp. I have been searching and reading for past two days but still not able to get a hold of it.
I was following [URL]
I created a CustomMembershipProvider class in my models
[Code]....
In my webconfig file, I do have [Code]....
Now, I created a AccountController, in that I added following code
[Code]....
After that I added view fo Logon
[Code]....
Now, the first problem which I am facing is, when I Debug the webapplication, I get HTTP404 error. Url generated
[URL]
But when I try to open
[URL]