DataSource Controls :: Access Property Of Object As Session Variable As Declarative Datasource Parameter Value
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
Similar Messages:
May 20, 2010
I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
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
Mar 25, 2010
I've done some SSIS package work in the past, but am by no means an expert.
I want to use an SSIS package to do the following:
1. Get the file name of the newest file in a windows folder (using a filename template like his: filename_ *.txt where the * part is always a date in the format of yyyy-mm-dd.
2. Use that file name in later portions of the SSIS package by reading the file and transferring data from it to a SQL table using a Data Flow task.
and use the result (which should be the name of the newest file) to open that file and pull data out of it and into a 2nd SQL table. I admit, I'm not sure how to use the dynamic result of this SELECT query as the file name in a flat file connection manager.
View 6 Replies
Sep 3, 2010
I create a variable in code behind to save today's date.
[Code]....
And I want to save it as a parameter for an accessDataSource but I'm not finding anywhere that tells me how to do this properly. My attempts thus far have been
[Code]....
View 4 Replies
Jan 7, 2010
I need to use a global variable as a parameter for the SqlDataSource element. I capture the user Name when he/she logs in:
Public UserName As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
UserName = Page.User.Identity.Name
End Sub
Then, I need to use the UserName to search the SQL DB and show only logged user personal information.
SelectCommand="SELECT * FROM [Member] where [UserID]= UserName"
What is the sintaxe to use a global variable into the SQL Select Command?
View 10 Replies
May 19, 2010
how can i set the parameter source of an SqlDataSource to a variable from visual studio?
View 2 Replies
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
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
Jun 23, 2010
I get a casting error on line #8 below which reads "db.UserID = Session("UserID")". What would be the correct way to cast this? The datatype of the DB field is GUID.
[Code]....
View 4 Replies
May 26, 2010
I am new to all this, and ignorant beyond compare. I believe I have the same problem as this :
[URL]. However, the solution proposed for him doesn't seem to work for me. I have a session variable that 'march_cpi_session' that I wish to include in an sql select statement to multiply the values I get from a datatable before they're used to populate a gridview control. The session variable works fine elsewhere in my application, but causes a variety (depending upon how I fiddle about with the syntax) of sql errors. This is the currrent code:
[code]....
View 3 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
Jun 30, 2010
I have a gridview inside a user control bind to an object datasource. Now I want to bind the object datasource with a parameter from parent page.
For this purpose I defined a public property in user control but how do I pass it with object datasource ?
I am calling from parent page like
myusercontrol.parameter=querystring["id"];
How to bind object datasource with my parameter ?
View 4 Replies
Dec 23, 2010
How to Fetch Rows based on Values in a Session Variable
View 4 Replies
Aug 12, 2011
Can I set up an ASP.Net datasource in the ASPX code as opposed to the code behind) where the datasource is a DataTable that's stored in a Session variable?
View 1 Replies
Feb 28, 2010
I had to format my hard disk and reinstall the Visual Studio 2005 Enterprise and SQL 2005 Standardprograms.
While my program worked perfectly before and still works ok on my second computer, I get the following error message on the formated computer:
Parser Error Message: Type 'System.Web.UI.WebControls.Parameter' does not have a public property named 'DbType'.
Source Error:
Line 82: <asp:Parameter Name="Olho" Type="String" />
Line 83: <asp:Parameter Name="image" Type="String" />
Line 84: <asp:Parameter DbType="Date" Name="inicio" />
Line 85: <asp:Parameter DbType="Date" Name="termino" />
Line 86: <asp:Parameter Name="pageId" Type="Int32" />
Source File: /0_oserigrafico/Default.aspx Line: 84
In this case I use a datasource control for a datalist and the parameter list is being built ba the system.
The DBType is created for the smalldatetime feild
how do I add the property named 'DbType'.
View 3 Replies
May 15, 2010
i am currently working on an asp.net mvc 2 web app using LinqToSQL. I would like to handle a scenario where a user comes form a country and for this i have set the users - countries db relationship and in my user model i have a CountryId property.
I would like to display the country name on my users display view, so i tried fetching the country name like this: User.Country.Name, but an exception occurs that i cannot access a disposed object. I understand that this is caused by the way i handle my users repository and service.
This the repository users code:
[Code]....
This is the service users code (the repository is not class level property, but a local one that gets dipsosed immediately after calling it):
[Code]....
So, how could i handle such a scenario, where i would like the Country model to be also fetched in order to use it later? Should i convert the repository model a class level proprty in order not to get disposed?
View 3 Replies
Mar 25, 2010
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"
View 3 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 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
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
Jun 26, 2010
I am working with a repeater control for a reporting purpose.
I have 2 repeaters one inside another , i hvae to bind the second repeater with the help of function which is having two parameters to pass in it
<asp:Repeater
ID="Rptgsaaccount"
runat ="server"
DataSource ='<%#bindcourse(Eval("Session_Id"),2nd parameter)%>'>
the first parameter is i am easily getting from outer repeater, but the second parameter value is exist on the server side and in a session variable
i have to pass this server side session variable value in above mentioned function as a second parameter .
View 2 Replies
Apr 3, 2010
I wondered what the difference between
'dbo.Property' and 'Property'
would be in an sql query
View 2 Replies
