Subsonic 2.2 Paging Linked Table Collection
Dec 26, 2010
I'm creating a small forum for my CMS and I'm using subsonic 2.2 as my DAL.
I'm loading my theads like this:
DAL.ForumThread item = DAL.ForumThread.FetchByID(id);
In my database my ForumPosts table looks like this:
ForumPostID | ThreadID | Description | UserID | CreatedOn| etc
So now when I have my DAL.ForumThread item I can load the connected post collection by using:
item.ForumPosts();
This all works great, but the problem is that I'm using serverside paging and want to add some additional select parameters too like showing only active records.
Is this even possible when using SubSonic 2.2 ? The workaround I have now is just creating a new SubSonic.Query and select the posts by threadid and there I can set pageindex and pagesize without problems but I think this can be done easier?
I also would like to know if it makes any difference performance wise by just using item.ForumPosts() or starting a new query, I think the forumposts are already in the ForumThreads collection and don't require a new database call right?
View 1 Replies
Similar Messages:
Jan 25, 2010
Does anyone have a simple / working example of how to add paging to a Datalist control when the data for the Datalist control comes from an SQL database?
View 4 Replies
Mar 24, 2010
I want to transfer temporary table from one server to another linked server. I want to transfer it like how Bulk insert does. Right now I'm transferring row by row. It should do bulk transfer.
View 6 Replies
Sep 7, 2010
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
View 5 Replies
Feb 20, 2014
I am insert and update the data in Excel sheet.while iam deleting the data it gives the Error like Deleting data in a linked table is not supported by this ISAM.
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Fileloc + ";Extended Properties=Excel 12.0;Persist Security Info=False";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
String cquery1 = "Delete from [data1$] where id=" + Txtid.text;
OleDbCommand cmd = new OleDbCommand(cquery1, excelConnection);
excelConnection.Open();
cmd.ExecuteNonQuery();
excelConnection.Close();
View 1 Replies
Feb 2, 2011
I have come from MS Access and am working through a couple of textbooks on ASP.NET 4. I am using the Gridview control connected to an SQL data source control.
As an exercise I am converting my simpliest MS Access page which is simple a form to request a new stock item in our engineering stores. I have a normalised table called [stock_requests] and part of this is a field calle [failure_mode]. This field is an integer and there is another table listing the possible values for this field.
This other table is called [failure_modes] and has two field:
[id] < the primary key
[mode] < the text to be displayed
In my main table [stock_requests] in the field [failure_mode] I store the [id] from the [failure_modes] table for the applicable record in the [failure_modes] table. So for example if someone wanted to select "Catastrophic" as the failure mode the [stock_requests].[failure_mode] field would be 1; if the user selected "Gradual" as the failure mode the [stock_requests].[failure_mode] field would be 2 etc.
Now, the gridview wants to display "1" or "2" but I want to display "gradual" or "catastrophic" without using views and all the headaches that brings. I have managed to sort out editting by using a templated field where I have a drop down list in this cell and I databind to a second SQL data source (imaginatively called SqlDataSource2).
what is the best method for displaying the text 'Catastophic' or 'Gradual' etc. when in normal mode (view mode)? Is it another templated field and what is the basic approach I should use? I reckon I should be able to work it out once someone points me in the right direction.
View 6 Replies
Mar 1, 2011
I've a collection defined in .NET. The collection contains a few hundred items.
example of the object in collection:
Tag.Name = "Tag1"
Tag.ID = "2"
Tag.Location = "Home"
and so on (a few hundred items).
I've a stored procedure to insert that data into the datatable. The logic in the sp checks first if the tag name already exists in the table.
If not, then insert.
Now I can use a loop to insert the data, but is there another way to do the same more efficient ?
View 1 Replies
Jul 8, 2010
I am creating a html table from a list collection. I am able to create the table, but I am not able to group the related items and add into a single table.
[Code]....
I have 3 items in the list collection, in which Student Name is same for 2 items.
Now I am getting 3 tables. I want to group the student Name and get a single table for unique student name.
This is my list collection:
Student ID Student Name Mark1
1 John 25
2 Mac 22
3 John 24
I am getting 3 tables now, but i would like to group the student Name and then get a single table for John having his marks and another table for Mac.
View 15 Replies
Jul 12, 2010
Equivalent of recordset.Edit, Movefirst,NoMatch of vb6 in vb.Net? I want to fetch records from single table of database(Sql server 2005) and collect in collections. How can we do that by dataset and dataadapter ? We want to fetch not to display.
View 1 Replies
Aug 13, 2010
I'm new to LINQ and have a problem with my query not showing me the Table Collection. I manually created my Cart class and specified the table attributes on each property (works fine for inserting records via LINQ see below). DataContext dc = new DataContext(Conn);
var q = (from c in dc.NOTABLES?? where ((c.UserID == userID)) orderby c.CreateDateTime Based on examples I would expect to see dc.Cart But I don't, so I tried to access it via dc.GetTable<Cart>() which at least gets me data but doesn't seem to convert the rows to my Cart object since this:
foreach (var cart in q) Log.Info("UserID: " + cart.UserID + " CartID: " + cart.ID.ToString());
blows up with a "Specified Cast is Not Valid" exception.
No Problem Inserting Also, I had no problem inserting data into the database:
DataContext dc = new DataContext(Conn);
Table<Cart> Carts = dc.GetTable<Cart>();
Cart aCart = new Cart();
aCart.UserID = userId;
aCart.Description = description;
aCart.CreateDateTime = System.DateTime.Now;
aCart.UpdateDateTime = System.DateTime.Now;
Carts.InsertOnSubmit(aCart);
Carts.Context.SubmitChanges();
View 1 Replies
Dec 7, 2010
Is this possible?
using (Entities db = new Entities())
{
LoadDropDownList(ddlFirst, db.MyTable , (bool)(myMember.Id == 0), (int)myMember.RevenueRangeID);
LoadDropDownList(ddlSecond, db.OtherTable , (bool)(myMember.Id == 0), (int)myMember.OtherID);
}
I am stumbling on what the type of the second parameter should be - I am essentially trying to pass in the Entity-Framework 'table' into a generic routine that loads the DropDownList with data from the 'MyTable' table using custom logic/filtering.SInce I do the same thing about 6 times for 6 different dropdownlist/table combos I wanted to use a generic function to accomplish this.
View 2 Replies
Mar 2, 2010
I don't know why I did have the following problem with this. USE [myschema]; select acc,acc_name from ORA_sys2..oraschema.acc_table; Msg 7314, Level 16, State 1, Line 3 The OLE DB provider "OraOLEDB.Oracle" for linked server "ORA_sys2" does not contain the table ""oraschema"."acc_table"". The table either does not exist or the current user does not have permissions on that table. But within the SP, I did make use of the following way without any problem! from ORA_sys2..oraschema.tab2
View 2 Replies
Aug 3, 2010
how can i implement paging on data displayed on an asp.net table control from a List object in memory.
View 3 Replies
Jan 24, 2011
I am coding online sales a website but I've a problem on main page I have to show products I made it as 4 columns table but there is over than 100 product and i need paging for that. How can I fix it like 20 products per page.
View 2 Replies
Mar 25, 2010
i try to use subsonic 3.0 but i can not do that. i decided to use subsonic.2.0. So i try to make it i can not :(
my Web Config :
[Code]....
also look this article: what is error? [URL]
View 1 Replies
Jul 26, 2010
I have a list of objects that I want to bind to a gridview. Creating that list and binding it works fine for most of the public properties in that list.
There are some objects contained in each of those objects... for instance there is an Address object.
object.Address.Line1;
object.Address.Line2;
When I bind this to my gridview, I have no issues with stuff like object.DateRegistered, but how can I access things like object.Address.WhatEverProperty? I always get this error:
"A field or property with the name 'xxx.xxxx' was not found on the selected data source."
View 7 Replies
Feb 23, 2010
I want to clear my funda and doubt in paging.For that i ant to do paging for html table populated with datareader .My html table should be <table><tr><td>... so on .Paging should be numeric and language should be c#.I don't want to use datagrid or javascript.
View 5 Replies
Feb 3, 2011
I'm using JQuery table paging plugin for my partial view. There are two other partial views with buttons that update the result section, but only one of them works with JQuery paging. Firebug reports that '$ is not a function'. I loaded all the jquery libraries in the master page. What am I doing wrong?I tried reloading the libraries in the partial view but to no avail.
The code is something like this.
My result partial view
[Code]....
View 7 Replies
Feb 22, 2010
I have a dynamic Gridview that I build on the fly. It works great. Now, I want to put paging on it. I have put the following code as an event on Pageindexchanging. When I do, the system tells me that the BindGridControl is not declared. The other lines have no error on them. What am I doing wrong? The name of the Datagrid is MyGridview. If I comment out the BindGridControl the system does not get an error but it of course does not show the second page when I click on it.
[Code]....
I did it with DIV tags rather than trying dynamic page building
View 1 Replies
Jun 23, 2010
Is there a way to set the command timeout for everything generated by subsonic?
View 1 Replies
Jul 28, 2010
I have an MVC project setup, and I've brought the subsonic Active Record templates into my project, and they generated successfully and I can use the subsonic classes to access my database. However, how do I create a strongly typed view using the subsonic generated classes? When I select "add View" and I check the checkbox to create a strongly-typed view, none of the generated classes from subsonic for my data are available.
View 2 Replies
Mar 20, 2010
Does anyone know how I can concatenate two columns in my subsonic datasource? I want to display a first and last name in this dropdownlist but I don't want to put them in the same SQL column.
View 2 Replies
Mar 7, 2011
I'm working against a database that wasn't designed by me and in all the tables there is a CreatedBy field that is an int. Now when I generate against this db i get all kinds of errors because subsonic is expecting that field to be a varchar.I don't particularly want to go and rename the field in all of these tables so I was hoping there was a way to "alter" or change the internal convention (without getting into the source) in subsonic.Has anyone been able/done this in subsonic 3.0.4??EDIT: I'm using the active record model in subsonic 3
View 1 Replies
Mar 31, 2010
I want to know that how i use the collection class for storing some data and save it letter in the data base.
View 4 Replies
Jul 6, 2010
i wanna use to subsonic 3.0.4 but i dont know, how can i start to generate class and use to new Template of T4. example: create new solution for generating to table's class and add to my project. ??
View 2 Replies