DataSource Controls :: Is It Possible To Use A Property Of An Object Instance Property For Object Data Source
May 3, 2010
Traditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?
So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.
I have an insert that uses an object data source with out the direction property set and it works fine. I noticed the direction property though and wondered if I should use it.Should the direction property for the parameters of an object data source be used with a simple CRUD operations?
I'm trying to understand when to use the type property and when to use the dbtype property. I looked online but couldn't find a good article that said when and why.
I am trying to get an asp:SessionParameter of a SelectParameters, to use a property of an object in session instead of having a string in the session like Session["CustomerID"]
Something like Session["Customer"] where the property is ((Customer) Session["Customer"]).CustomerID)
My code:
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:DBConnectionString %>" xmlns:asp="#unknown"> SelectCommand="SELECT * FROM getStoreCustomers (@customerID,@week,@day)" ProviderName="System.Data.SqlClient"> <selectparameters> <asp:sessionparameter name="customerID" sessionfield="Customer" /> ?????? (what is the syntax to pass the property here?) <asp:controlparameter controlid="ddWeek" defaultvalue="-1" name="week" propertyname="SelectedValue" /> <asp:controlparameter controlid="ddDay" defaultvalue="-1" name="day" propertyname="SelectedValue" /> </selectparameters>
The class I use is like any other class (but serializable)
[Serializable] public class Customer { public int CustomerID { get; set; } }
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
can you please help me to brainstorm the possible causes of this error. I've got a paged repeater with localisation bound programitcally to an sqldatasource using a stored proc. I can post code if needs be but it's rather long. I'm looking for typical causes of this error + will make note for future reference!
erver Error in '/WebSite4' Application.
Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
Line 233:Line 234: Repeater1.DataSource = PagedResultsLine 235: Repeater1.DataBind()Line 236: doPaging()Line 237: End Sub
On Edit Click, the DropDownList in the GridView brings the previously selected value.On Update Click, the error is: "System.FormatException: Input string was not in a correct format."
ddlRegionNavn.DataTextField = "RegionNavn"; ddlRegionNavn.DataValueField = "RegionID"; // from RegionNavn to RegionID
On Edit Click, the DropDownList values in the GridView is not firing and the following error shows.Object reference not set to an instance of an object. How to implement the code when having a value of type Int ?
My problem is I get an "Object reference not set to an instance of an object." error at runtime on the line "ddl2.SelectedValue = cat1". Ironically I got this from an example on the internet and the only difference is my Cat1 varible which has the correct value at runtime.
I would like to enable/disable the field BagNo in my gridview, depending on the value of another field in the gridview called ScriptNo, when I click the edit button I get this message "Object reference not set to an instance of an object".
here is the code
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing Dim row As GridViewRow = GridView1.Rows(e.NewEditIndex) If DirectCast(row.FindControl("ScriptType"), TextBox).Text = "TTA" Then
When I am executing the below code on Visual Studio 2008, then it is executing properly with out any error. But when i am executing it on Visual Studio 2012, then it showing me following error (System.NullReferenceException: Object reference not set to an instance of an object) at line 64
Why is it so?
.vb Code is below :
Imports System.Data.SqlClient Imports System.Data Partial Class grid Inherits System.Web.UI.Page Function constr() As String Dim i As New IO.StreamReader(Server.MapPath("constr.config"))
I have a dropdownlist attached to a cell when edit is selected. I am using the following code to populate the drop down list with the value that is on the row.
dlBU.Items.FindByValue((e.Row.FindControl("lblBU") as Label).Text).Selected = true;
This works famously when I have a value in the cell. It fails when the cell has not yet been populated. Is there an if then clause that if the value of e.Row.findcontrol("lblBU") is null no default value?
I'm new to ASP so this may seem so simple but I cannot work it out.
I am trying to create a script that changes its output based on a range of values. Here is what I mean:
I have a MSSQL database with an ASP scripted website that reads it and displays the data in a table. One of the columns in the database is a percentage and I want that column in the web page to have a background colour based on the figure outputted.
So each cell may be a different colour. If the number is between 0 and 30 then red background, 31 to 70 orange etc.
At the moment I have the database output script looking like this:
i have a sortedlist who values contain a Product objects. i wish to set the Quantity property of a selected Product object ( from gridview) when the Quantity field changes?
how do i compare whether the product row Quantity field in the gridview is the same as the Product Quantity property in the sortedlist and update accordingly?
note. i have converted to a list(of product) to bind to gridview. then update the sortedlist values
