C# - How To Access ObjectDataSource Object After Bind To GridView
Feb 4, 2010
I have a GridView, I bind it to ObjectDataSource. ObjectDataSource takes data from a database's table. Each row in table has unique ID.
I have a button in each row of GridView that should remove this row from database. My ObjectDataSource returns Object, this returned object contains ID (and some other information, like name, user etc.) however I do not show this ID on my grid.
how can I get these ID after user chooses to delete row, I need to know what I should remove.
View 2 Replies
Similar Messages:
Feb 22, 2010
I am using an ObjectDataSource control to call a MapInfo object. This object has two properties:
public IList Visits
public int TotalAvailable
The select method returns an IList but the TotalAvailable property is also populated. I have set the TypeName in the ObjectDataSource to the MapInfo object but because the Select method only returns the IList I don't have access to the TotalAvailable.
[code]....
Is there any way to access this value. I know it is being populated in the MapInfo object but all that gets returned from the Select method is the IList
View 2 Replies
Sep 2, 2010
Backgroud: I'm using NHibernate for my model layer, and I have a HTTP module taking care of instantiating the session at the beginning of each request and cleaning it up at the end of each request (i.e. Session Per Request). In this case, I have two object types:
ParentItem - an object with a bunch of properties and a collection of ChildItems. ChildItem - an object with properties including a DateTime (EffectiveDate) and an unenforced FK pointing to a completely different database. The ChildItem class contains a reference back to the parent as well (many-to-one) While the ParentItem has multiple ChildItems in its collection, I'm only generally interested in the latest ChildItem in the collection.
Desire: Want a databound control (GridView or ListView, I don't care which) that allows me to Add/Edit/Delete ParentItems from my datasource. I also want to have the ability to set a new "latest" ChildItem as part of the edit/update.
Issue: I can't seem to access the underlying DataItem from the GridView/ListView in the OnItemUpdating handler (which isn't unexpected, since the data is now in the viewstate). What I thought I could do would be to load a ParentItem from my session using the ID from the databound control, create a new ChildItem, add it to the ParentItem, and then save the ParentItem. Since NHibernate caches the data, the load should give me a copy from cache (no roundtrip to the DB) and I'd either be doing this before the ParentItem was saved back (thus no changes committed to ParentItem, just to ChildItem) or after (thus the cached version is still the same, and my new object will match the updated version). What I get when I do this (for ParentItemID=1):
a different object with the same identifier value was already associated with the session: 1, of entity:
NameSpace.ParentItem
on the line:
Session.SaveOrUpdate(parentItemInstance);
View 1 Replies
Mar 9, 2010
I am trying to update record in gridview using ObjectDataSource (with conflict detection)The following is the ObjectDataSource
[Code]....
Update Method is as follows
[Code]....
In ObjectDataSourceProducts_Updating(..) event , I am checking objects which are being sent to UpdateProduct(..) method. I found that both the objects " original_ProductDB and productDB " have the same the values. When I click "Update" in GridView after entering new value, ObjectDataSource is not picking new value
[Code]....
GridView is as follows.
[Code]....
ProductBO is as follows
[Code]....
View 3 Replies
Apr 16, 2010
Basically as the title of this thread states, I have a FormView that has a GridView inside it and my ObjectDataSource that populates this grid cannot access the Grid.
The Control Id needs to be the name of the Grid I want to access, however through the 'wizard' the Control parameter drop down cannot 'see' the grid I need, only the FormView that is in.
I have tried numerous ways to get round this and am struggling now..
I've tried the following...
ControlID="FormView.GridView1"
ControlID="FormView.FindControl("GridView1")
ControlID="<%= GetNameOfGrid %>"
and numerous other attempts that also failed that I now cant remember...
View 2 Replies
Apr 1, 2011
If I have the following ASP.NET code (it's not complete - obviously there's a lot missing, but none of it matters):
<asp:GridView>
<Columns>
<asp:TemplateField>
<ItemTemplate>
My Label: <asp:Label />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
My Text Box: <asp:TextBox />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
And if I have something like this in the CodeBehind:
Private MyListOfObjects As List(Of MyObject)
...
Public Class MyObject
Public MyTextBoxString as String
Public MyLabelString as String
End Class
How can I bind the GridView so that one row is equivalent to one item in my MyListOfObjects list, and so that the data will populate and persist across page loads or postbacks? I've never done custom databinding like this before. All the tutorials I've come across so far only talk about using GridViews directly with Database query results, and that's not what I need.
View 4 Replies
Aug 2, 2010
If I have a list of contacts List<Contact> and a Contact object has an Office object property, I want to display a grid with columns
Contact Id, First Name, Last Name, Office Name
Where the sources of the above columns are respectively:
Contact.ContactId, Contact.FirstName, Contact.LastName, Contact.Office.OfficeName
I'm fine with binding the first 3, but was wondering whether I can bind the OfficeName using either Bind or Eval or whether I need to hook into the events and set the value there.
View 3 Replies
Jun 21, 2010
I have tried to query a table with an xml column by using XQuery and I can't get the Select to work.
All my knowledge/understanding of the subject comes from this MSDN article:
[URL]
so I am probably overlooking something minor:
I tried this query Select col1, Phone.Query('element CellPhone {I am not sure about what goes here} I tried {data('Phone/cellPhone} from aTable Where Phone.Exist('/Phone/cellPhone/text()[contains.,"412-8977"]') = 1 This syntax is definitely not fun.
View 2 Replies
Jan 16, 2011
I've created a query in the table adapter for retrieving customer name based on the first letter. The query is executed fine, and the output is the customer name and ID. A Customer BLL accesses this query, and sends the results to an objectdatasource. This control is configured to use this customer-by-letter query. However for some reason, this objectdatasource does not bind the name and ID, but instead all the other fields produced by the main query in the table adapter (i.e. name, address, phone, etc....).
I'm probably not configuring something correctly, but I'm not sure what.
The BLL code:
[Code]....
The .net code:
[Code]....
View 4 Replies
Feb 12, 2011
I have a button, which when presses populates a grid with data. If I add an ObjectDataSource, and bind the grid to it, it will populate the grid when the page loads. But I need to populate the grid only if the button is pressed, because it is a lengthy operation.
View 1 Replies
Mar 9, 2011
Is it possible for me to have an ObjectDataSource and the bind a texbox to a certain field to it?
View 2 Replies
Oct 31, 2010
is it possible to bind DataTable to ObjectDataSource?
View 4 Replies
Jan 20, 2011
I got a Buisness Logic Layer where i have a function that returns a DataTable, how can I bind it to SqlDataSource or ObjectDataSource Snippet of BLL
[Code]....
[code]....
aspx.vb file
Dim dt As DataTable = Nothing
dt = ReturnCarsInStock.GetCarsInStockComplete(procBrand, procMode)
View 8 Replies
Jun 14, 2010
I am using objectdatasource to bind datagrid,i m using select method of objectdatasource and manage paging (page size 10) and command event also,i have define MaximumRowsParameterName and StartRowIndexParameterName but now problem is when i am trying to delete 11th record from second page and again bind same grid than i coudn't fine rest of 10 records and get no records found.
View 1 Replies
Dec 7, 2010
When i try to bind the data to gridview/listview from access file using oledb provider its throwing an error specifying that "The 'Microsoft.Jet.OLEDB.14.0' provider is not registered on the local machine.".
[Code]....
And by seeing some articles i changed "Enabled 32 bit applications" as True from IIS. And i have downloaded some DataContext's to work for access, but no use, its not working.
View 4 Replies
Dec 2, 2013
I have create one user control of personal details, and write the geting data from database method and Load the entities in respective field,then how to bind user control in gridview and how to accecc Id of user control in aspx page.
View 1 Replies
Sep 23, 2010
Before i talk about my situation or problem let me tell you all that i'm new to ObjectDataSource, ListView.
i've following controls
Three LinkButtonOne ObjectDataSource Control (which is binded to custom Business object) . Paging is enabledListView (This is binded with ObjectDataSource Control)
Requirements:
By default ObjectDataSource should be bounded to DataSource A, thus the user should see on page load the default data from DataSource A.When user Clicks on respective LinkButton, the ObjectDataSource should now be binded to new DataSource B, thus the user should now see data in ListView from DataSource B. The same should happen with LinkButton C respecctively
View 1 Replies
Jan 12, 2011
I successfully bind ListView DataSourceID to ObjectDataSource but it binds only initially on Page_Load event.
When I want to bind another data through a Button_Click event, the new data doesn't bind.
aspx code:
[Code]....
Codebehind:
[Code]....
On Page_Load, I get result:
A1
<hr />
T1
A2
<hr />
T2
A3
<hr />
T3
When I Button1_Click, nothing happens, no error, no any more results and _airLineData is 53 records, not 3 records (A1T1 to A3T3) I want the binding to be with DataSourceID to ObjectDataSource (not through DataSource property and control.DataBind() method)
View 6 Replies
Mar 11, 2010
I have an ObjectDataSource with a number of parameters. These parameters are binded in my FormView EditItemTemplate and the ItemTemplate. My Stored Procedure column names in my ItemTemplate are different to the Bind properties used in the EditItemTemplate. This is obviously throwing an exception when I update a record.
Instead of using Bind("Columne Name") in my EditItemTemplate how do I use a ControlParameter to reference a TextBox in the EditItemTemplate?
I may be wrong but I'm trying to use the PropertyName=Controls but i do not know how to reference the Textbox in the EditItemTemplate.
View 9 Replies
Jan 13, 2011
Is there any way to return object from Session when Select is called on ObjectDataSource? Specifically, I have Products object and saved in Session. Now on another page I have ObjectDataSource which will call same bussiness object method to get Products object. Here I want to hook up any event like Selecting and I would like to return Products object from Session to Select method of ObjectDataSource.
View 1 Replies
Nov 8, 2010
Is it possible to access an object that is used by ObjectDataSource to retrieve records? For example,
<asp:ObjectDataSource ID="MyDS" runat="server"
SelectMethod="getUsers"
TypeName="DataSources.UserDS"
SelectCountMethod = "getUserNum"/>... </asp:ObjectDataSource>
UserDS class has getUsers that returns DataTable and getUserNum that returns int, this part works as it's supposed. But I wonder if can access the instance of UserDS somehow (not underlying DataTable)?
View 1 Replies
Sep 1, 2010
I have ObjectDataSource and GridView on one of the pages of my asp.net web project.
To initialize ObjectDataSource i use Init event:
protected void ObjectDataSource1_Init(object sender, EventArgs e)
{
ObjectDataSource1.EnablePaging = true;
ObjectDataSource1.TypeName = "CustomerDataSource";
ObjectDataSource1.DataObjectTypeName = "Customer";
ObjectDataSource1.SelectMethod = "GetCustomers";
ObjectDataSource1.UpdateMethod = "Update";
ObjectDataSource1.SelectCountMethod = "GetCustomersCount";
ObjectDataSource1.MaximumRowsParameterName = "maximumRows";
ObjectDataSource1.StartRowIndexParameterName = "startRowIndex";
}
Somewhere in DAL:
public static List<Customer> GetCustomers(int maximumRows, int startRowIndex)
{
try {
... some select to database here...
}
catch (Exception ex)
{
Utils.LogError(ex);
throw ex;
}
}
Now let's imagine that GetCustomers for some reason throws an exception. How could i catch this exception and handle it? I know i can use Application_Error, but i would like to catch this exception somehow on my page and show some friendly message to the user.
View 1 Replies
Feb 22, 2010
I have a series of classes that loosely fit the following pattern:
public class CustomerInfo {
public int Id {get; set;}
public string Name {get; set;}
public class CustomerTable {
public bool Insert(CustomerInfo info) { /*...*/ }
[code]...
View 1 Replies
Dec 28, 2010
Is it possible to pass a domain object as session parameter in an ObjectDataSource. I'm doing this:
<asp:ObjectDataSource ID="ParticipantsDataSource" runat="server" OnInit="SqlDataSource_Load"
SelectMethod="LoadParticipants" TypeName="SB.Web.units.Players">
<SelectParameters>
<asp:SessionParameter Name="user" SessionField="User" Type="SB.BusinessLogic.DomainEntity.User" />
</SelectParameters>
</asp:ObjectDataSource>
But I get the error message that I can't create an object of the type System.TypeCode from the string containing SB.BusinessLogic.DomainEntity.User for the property Type.
View 1 Replies
Mar 5, 2010
I would like the ObjectDatasource insert and update data methods to return the inserted or updated object like LinqDataSource do.
View 2 Replies
