DataSource Controls :: How To Use A Property Of An Object In Asp:SessionParameter
Jul 20, 2010
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;
}
}
View 2 Replies
Similar Messages:
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
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.
View 4 Replies
Jan 11, 2010
I have FormView that has a DropDownList
this DropDownList takes its list from a sqldatasource that has SessionParameter as parameter.
after loading the page if i changed the value of the session an error get fired !!
the Error is "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
When i click on the GOOOO button the error occures
My Code is
[Code]....
My other code is
[Code]....
View 9 Replies
Oct 27, 2010
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" />
View 2 Replies
Apr 20, 2010
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?
View 3 Replies
Apr 24, 2010
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.
View 3 Replies
Apr 3, 2010
I wondered what the difference between
'dbo.Property' and 'Property'
would be in an sql query
View 2 Replies
Apr 20, 2010
im tryin to create a login form.
and am receiving the following error:
Object reference not set to an instance of an object
[Code]....
and heres my aspx page:
[Code]....
Stored procedure:
[Code]....
View 2 Replies
Feb 17, 2010
On DBML I have two entities as Parent, Child. I am trying to assign Child class properites in a Parent.
[code]....
I am getting the following Error:
Cannot access a disposed object.
Object name: 'DataContext accessed after Dispose.'.
View 2 Replies
Jul 27, 2010
[code]....
i'm having trouble because when it has no return value i get the error
Object reference not set to an instance of an object.
View 10 Replies
Jan 24, 2010
im using a sqldatasource and i want it to query a table chosen from a dropdownlist, so i wrote the following in the .cs file
[Code]....
im recieving this error msg: Object reference not set to an instance of an object (pointing to the line containing the select command)
i don't know what's the problem, i tired a hard-coded statement and it worked fine!
View 2 Replies
May 26, 2010
I am adding rows to table and setting value row/cell value, but for datetime field it is giving me error
Object reference not set to an instance of an object.
Initially I am adding a column to table as
table.Columns.Add("Upload Date",
typeof(DateTime));
Then I assigning value to row as
row["UploadDate"] = result["Execution Date"].ToString();
As I have I also null or empty value in the "Execution Date" field .
View 3 Replies
Nov 18, 2010
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:
[Code]....
How can I implement what I have outlined above?
View 1 Replies
Oct 30, 2010
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
View 3 Replies
Sep 6, 2010
I have a StoredProcedure called "usp_posts_getall" and it has 1 parameter called "@thisCategoryID"
in my "thisCategoryID", any values other than 0(zero) will return all the records in my Posts table.
Now I have a category menu items and each time I select, I set the value in my Session name called "SelectedCID".
So, How Do I ...
Create a SessionParameter Programatically in SqlDataSource?
View 1 Replies
Mar 10, 2011
i have problem white Object datasource. i have a multi-tier Application that include common layer ,DAL Layer,business logic and persantation layerwhen i add a object datasource to my page, it bring me only common layer classes . but i want use bisuiness layer classes what do i do ?
View 1 Replies
Aug 2, 2010
I am trying to sort in gridview however I got some error message in _dopostback function which shows "Microsoft JScript runtime error: Object doesn't support this property or method" at theForm.submit()
my user.aspx.cs shows as follows
[code]....
View 7 Replies
Aug 9, 2010
This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing
Object Access Class
public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options)
{
[code]...
View 2 Replies
Jan 17, 2010
I have a Public Sub listed in a class file that I am using to store Select, Update,etc...methods for an Object Datasource. When I attempt to configure the datasource, the Class appears as a business object, but the sub within the class is not available for method selection. (It does not appear in drop down list in wizard.)
The sub exists, so where is a good place for me to start looking for a fix? I have part of the class file listed below:
[Code]....
View 7 Replies
Aug 25, 2010
I'm getting the old "Object reference not set to an instance of an object" error on this code:
nonqueryCommand.Parameters.Add("@comment", SqlDbType.VarChar, 500)
nonqueryCommand.Parameters("@comment").Value = CType(FormView1.Row.FindControl("CommentsLabel"), TextBox).Text
"CommentsLabel" is a textbox, despite it's name (and I've tried the CTYPE ot Label too).
View 3 Replies
Mar 5, 2010
have an object datasource that calls a web method to retrieve a set of data. That web service resides on another remote server with Windows Authentication enforced. How do I pass in the credentials required for the authentication from my web application? My code is as follows:
[Code]....
View 7 Replies
Apr 16, 2010
I'm trying to figure out how to find whether a column exists in a dataset, and if not, remove certain controls on the page (otherwise it will error out with: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'my column')
So...
I have a gridview that has xml data loaded dynamically by drop down list selections.
The xml elements vary depending on the file.
One XML file may look like this:
[Code]....
View 7 Replies
May 26, 2010
i am trying to call a SP from SQL Server in asp.net app, but it keep crashing every time it hit
'cmd.Connection.Open();' ,,, it give me this message
"The ConnectionString property has not been initialized "
[Code]....
[Code]....
View 2 Replies
May 26, 2010
I m working in Asp.net 2.0 with C#.... I have a custom control and i have to use 'Datasource' property which is exactly like a repeater having.
View 1 Replies