.net - NHibernate Paged Results & Incorrect Row Count?
Mar 10, 2011
I have a model called 'BusinessPage' which can be associated with 1 or more 'BusinessPageCategories'. So I've got a 3rd table called 'BusinessPagesInCategories' that links these two.I am trying to get a paged recordset of BusinessPages, along with the total number of records (I may have 100 rows in total but only return 20 at a time, but I pass back an int containing that total number in addition to the 20 rows).The problem I have is that, since I implemented the Many-To-Many relationship, it was bringing back the same BusinessPage row x times (where x is the number of categories that BusinessPage is associated with). I only want a single instance of each business page to be returned. So I added the following to my NHibernate Criteria to give Distinct BusinessPage results..SetResultTransformer(CriteriaSpecification.DistinctRootEntity);
Whilst this works for me, in that I'm now correctly getting a single row per BusinessPage (and my Categories property within each BusinessPage contains the correct x categories that it's assigned to), my row count is not reflecting that 'distinct' count - instead, if I have just 1 BusinessPage record which is associated with 3 categories, the row count is 3!?!
public virtual int BusinessPageId { get; private set; }
public virtual IList<BusinessPageCategory> Categories { get; set; }
public virtual string BusinessName { get; set; }
[code]...
View 1 Replies
Similar Messages:
Jun 11, 2010
I'm using a ListView with a Paged DataSource. When the ObjectDataSource tries to fetch data from the "GetData"-method, the parameter PageSize is set to -1, even though I have set the PageSize to 8 in the DataPager.
Have I forgotten something?
<asp:ListView DataSourceID="odsProductIndex" ID="lstProductIndex" runat="server" OnItemDataBound="lstProductIndex_ItemDataBound">
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceHolder" runat="server"></asp:PlaceHolder>[code]....
View 1 Replies
Apr 5, 2010
I have the following mapping for my table in MySql:
<class name="Tag, namespace" table="tags" >
<id name="id" type="Int32" unsaved-value="0">
<generator class="native"></generator>
</id>
[Code]....
As you see the record_dates property is defined as a component field of type DateMetaDate. Both created_at and updated_at fields in 'tags' table are updated via triggers. Thus I can insert a new record like such:
var newTag = new Tag()
{
name = "some string here"
}
Int32 id = (Int32)Session.Save(tag);
Session.Flush();
ITag t = Session.Get<Tag>(id);
ViewData["xxx"] = t.name; // -----> not null
ViewData["xxx"] = t.record_dates.created_at; // -----> is null
However when querying the same record back immediately after it was inserted the record_dates field ends up null even though in the table those fields have got values.
why the Session.Get ignores getting everything back from the table? is it because it caches the newly created record for which the records_dates is null? If so how can it be told to ignore the cached version?
View 3 Replies
Mar 8, 2011
I am trying to export a Nested Listview to Excel, but I am having issues with the code recognizing the records in the ListView. When I do a FindControl, that code works fine.The Issue arises when I try to loop through the Items of the Nested Listview. The Count always comes back as 0 (zero). However, if I do a watch on the nested listview variable and navigate to the Items collection, then the count is updated with the correct content. I've tried forcing a Databind() on the 2nd Listview, but that really shouldn't be necessary as I know the records are there. As a result, I am having issues Exporting the Data to Excel since only data from the Parent ListView is returned.
[Code]....
View 11 Replies
Apr 9, 2010
I want to count the number of results results returned by my query and print the number to a literal on the page.How would I do that?
View 2 Replies
Jun 2, 2010
I have code that's working beautifully on my development machine,but when deployed to the server is throwing null reference exception.So,I can't step through the code,but I've pinned down the culprit.But now I am puzzled.Here's the code.The question is below.
Dim certs = From p In persons _
Select New Certificate( _
p.Value, _
New CertificateData.Seminar(thisEvent.Seminar.Name, _
[code]...
In the code above persons is a dictionary of custom class,and certs is of IEnumerable type.Now here's the quandary.The first line that sets the label returns False,so certs is not null.But the second line throws an null reference exception.
View 1 Replies
Apr 1, 2010
Can i customize gridview to show Reuslt summary in the footer or pager like
[Results: 1- 10 of 2000]
View 4 Replies
Apr 18, 2013
The query I used here is
SELECT top '"+lblCount.text+"' Company_Id, CompanyName, All_Countries,All_Industries,Employees,Revenue, Status FROM SN001CompanyTable where Client_Id=100 ORDER BY [Company_Id] DESC
but its not showing proper results..
In this lblCount contains the no of row to be displayed..
View 1 Replies
Mar 15, 2010
I am using ListView/DataPager.
For performance reasons I page my results at database, using ROW_NUMBER(SQl2005).
At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?
View 2 Replies
Mar 6, 2011
In ASP.NET 4.0 webforms, I'm trying to export a paged ListView control to an Excel file by un-paging the ListView's (trucks) datasource:
dsTrucks.EnablePaging = false;
For a non-paged ListView control, I can get it to work.
Here's the attempt to "un-page" and then export the ListView control:
[Code]....
There's no error but the output in the Excel file is still just one page of the ListView control instead of all rows.
View 1 Replies
Sep 15, 2010
I am working with a sql server database with about 50 stored procedures. The database and stored procedureswere not created by me. The stored procedures all begin with a number in their name.
Example: 17P_Comsetter
The problem I am having is that if I try and execute the stored procedure at the command line in Query Analyzer,the query analyzer appears not to like that the stored procedure begins with a number. For example:
If I try an run the stored procedure as follows:
EXEC 17P_Comsetter
Then I get the following error message:
Msg 102, ..... Incorrect Syntax near '17'
I am using SQL server 2005. Does anyone know why I am getting this error message?
View 1 Replies
Feb 8, 2011
Using a SubSonic (2.2) SqlQuery object, I am querying a view that contains distinct rows from another table. The results of the query, however, contain multiple rows for certain rows in the view. It appears to be because of a join on a temporary table in the query generated to achieve paging. How can I avoid this duplication of rows?
Bonus points: I have to use the view because SubSonic can't do .Paged() and .Distinct() at the same time. Why not?
View 1 Replies
Mar 29, 2010
I got a list of customers I thought I would list in a gridview or a repeater with customer html, it gone have paging. I'm gone have a checkbox for each customer in the list. Do you guys have any suggestions on how I should do to keep the checkbox value when I go to page 2-3-4 ect in the paging. I'm thinking a session to store the id of the checked customers. After I'm done setting the values they go to the database.
Do you got any other ideas then the session I'm thinking of?
View 2 Replies
Mar 21, 2011
I am trying to determine the number of pages in a custom paged control I have Built
there are 46 records and I am trying to get to the exact number of pages when there are 5, 10, 25 items per page etc...
at 5 items per page I should have 10 pages
and at 10 items per pages I should have 5 pages
but my code returns values that cannot use.
this is my code:
[Code]....
those are values I get.
When maxrowperpage is 5
pagecountConverted is = 9
pagecount is = 9
When maxrowperpage is 10
pagecountConverted is = 5
pagecount is = 5
how can I get a correct quotient?
View 1 Replies
May 27, 2010
I have a gridview that is a directory of people with about 50 pages
How would I make another gridview that had first row with 26 columns, 1 for each letter of the
alphabet and second row with the first page that has last names that start with that letter.
View 6 Replies
Jan 13, 2010
I need to make a large Ebay-style list of listings (think of the page that comes up when you search for something in Ebay, with a photo, title, one-line description, price, that's paged, and sortable). My limited experience with DataGrids in the past always resulted in what felt like a sluggish page to me, but I'm not sure if it would have been faster if I had pieced it together with a data reader instead.So I'm wondering before I even get started, what is the fastest / most efficient way to retrieve and manage this data.Is it more efficient at runtime to use a DataGrid, or to write the paging and sorting in more manually and use a DataReader, or another way?Ebay manages to get thousands of listings to display very quickly, but they've obviously got a lot of manpower to squeeze every last bit of performance they can out of the site, and good high-powered servers.
View 5 Replies
Jun 25, 2010
I have a DataGrid that has event handlers bound to SortCommand and PageIndexChanged. How can I determine if those event handlers are about to be called, say on page_load? These events will fire just fine after page_load, but I'd like to know at page_load if they are to be fired.
View 1 Replies
Jun 4, 2010
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 Replies
Dec 17, 2010
When 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]....
View 1 Replies
Oct 5, 2012
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] .....
View 1 Replies
Dec 14, 2010
I've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
View 4 Replies
Jan 26, 2011
In VS2010, when I "find in files", I often get doubled results in my find window.
View 5 Replies
Jan 5, 2011
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
View 5 Replies
Aug 27, 2010
I want to use NHibernate with Asp.net 3.5 but i don't know how to use it.I search on Google but couldn't find the complete explanation about why to use NHibernate,Advantages of using it and integration with Asp.net projects.
View 4 Replies
Aug 12, 2010
I am about to give up on this pos...unless somebody here simply gives me the right code to fix my problem. I'm tired of running in circles, and scouring the internet with no progress at all.
Problem: not updating collections with FK's.
Example:
Forum forum = new Forum("Sample");
category.AddForum(forum);
categoryRepository.Update(category); <- fails with transient object error for forum with no CategoryId.
Mapped right using References<Category> and HasMany<Forum>. Conventions are as follows.
Ref:
instance.Column(instance.Property.Name + "Id");
HasMany:
instance.Key.Column(instance.EntityType.Name + "Id");
instance.Cascade.All();
instance.Access.ReadOnlyPropertyThroughCamelCaseField(CamelCasePrefix.None);
Now, I've tried every possible setting for inverse, all the different cascades, on both sides. Nothing works. It just flat fails, telling me it can't insert NULL for Forum.CategoryId (field, not entity prop).
View 8 Replies
