i wanted to retrieve things from the data base and perform mathmatical operations on it then post it to the user, so i was told to use the bullited list and bind it to the object dataSource
how to perform such thing??
View Complete Post
my query is
SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.COFROM V_HIERARCHY1 a
my data is
HR Rec Records Leave Leave Records HRL.0001 Policy
and Process for leave record. 27.06.2010 30.06.2010 WIP
EdlinkHR HR Rec Records Leave Leave Records
HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned
EdlinkHR HR DB Database SAL Salary DDS.0001
Calculation of Monthly salary 08.08.2010 09.08.2010 WIP
EdlinkHR HR Rec Records Ind Induction Records
HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010
I have a dropdownlist that I am trying to populated from a data source using an Oracle db. I can't get any data with the code I have. Can this be down in Sharepoint? Here is the code I am using:
<asp:DropDownList runat="server" id="DropDownList2" AutoPostBack="true" DataValueField="POPULATION_LIST_ID" DataSourceID="sdsLastName" DataTextField="Last_Name" Visible="True" Height
I have a simple test application following the directions from
http://msdn.microsoft.com/en-us/library/dd465159.aspx . When I attempt to drag the data source onto the design surface I get the following error:
Cannot add the control to the design surface or bind to the control because the type TestApp.AdventureWorksEntities cannot be resolved. Please try to build the project or add necessary assembly references.
The project as been built and the data source is in the same namespace. I did a search for this error and the only hit I found was here, and mentioned Tools->Options->Extension Manager, 'Load per use extensions...'. This option is checked.
I've tried unchecking and restarted with the same behavior.
How to load data through list object (in.net)(Through list object the data is populating dynamically) using ssis....?
Can any one help me....ASAP...?
I have four Lists with identical columns :
I had to merge them, hence i created a data source ( Linked Source ) and merged these lists in SPD. I have used a data view webpart to display some columns from the merged lists data source and everything was working fine.
But now i have a new List : List 5 which also has the same columns like the other four lists and i need to update the data soure such that it is merged list of 5 lists not 4.
i updated the datasource property of the linked source to merge this new list as well. However the contents of List 5 dont appear in the data view webpart.
Am i missing something here ?
I dont want recreate the data view web part from scratch eachtime , because in future there might be List 6 , List 7 as well ...
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
I am trying to use the SSIS XML Source object to insert data from an XML file into a relational database. Within the file and database there are several one to many relationships. For example, the Person table has a one to many relationship with
the Phone table - one person can have multiple phone numbers.
In my XML file, the PersonID is declared only once and that is with the person data. I need the PersonID as a foreign key for the phone data. The XML Source object displays multiple outputs for the XML file, including one each for Person and
Phone. However the Phone output does not include the PersonID which is required to insert the data into the Phone table.
How can I get the PersonID to appear with the Phone data? Is it a matter of modifying the XSD file, or is there method within SSIS where I can combine XML elements from different levels?
I am working on SQL Server Express Edition with Advance Services 2008 R2. I am using Report Builder 3.0 to build report.
In Report Builder, there is data source type called
Microsoft SharePoint List .
Can anybody please confirm whether this option will work with SSRS in Express Edition? I did not get information from above link.
When I try to copy and modify a data source, I get a server error that the operation is prohibited because it exceeds the list view threshold, but I only have 10 items in my list, well below the default threshold. I get the same error if I try to create
a new page from master. Anybody run across this one?
Confirmed the threshold with my administrator and even upped it to 10,000 but that did not help.
How do i set a data source of a drop down list which is inside a grid view, snap shot of asp code given below , the Asp file name is DataEntry.aspx and there is method in the DataEntry.aspx.cs called DTB.BindData("Department"). i want to set the datasource to point to this method
<asp:GridView ID="GridViewEmply" DataKeyNames="EmployeeID" runat="server" AutoGenerateEditButton="True" ShowFooter="True" OnRowEditing = "GridViewEmply_RowEdit" OnRowCancelingEdit = "GridViewEmply_RowCancelingEdit"OnRowUpdating = "GridViewEmply_RowUpdating" OnRowCommand = "GridViewEmply_RowCommand"OnPageIndexChanging="GridViewEmply_PageIndexChanging" AllowSorting="True" AutoGenerateColumns="False" AllowPaging="True" Visible="false"><Columns><asp:TemplateField HeaderText="DepartmentName"><ItemTemplate><asp:Label ID="LabelEmplyDeptName" Text='<%# Eval("DepartmentName") %>' runat="server"></asp:Label></ItemTemplate><FooterTemplate><asp:DropDownList ID="ddlDept" runat="server" ></asp:DropDo
please to try to help me what could be the problem ?. when i try to excute my stored proc in my sqlserver management studio it excuting fine when i trying to Excute using Asp.net application it giving Error. iam working on Sql Server, mt linked server is Oracle. my proc is like :
select ID,Name from OPENQUERY(TEST, ''SELECT ID , Name from Details)
Error:Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST".OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" returned message "ORA-01017: invalid username/password; logon denied". 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.
Please try to guide me i unable run using asp.net App
I have a class that inherited from object type and has some string properties, also I have a report(.rdcl) that use the fields of that class.
I add a webpage in my project, then I drag a reportviewer component into it. then I set the report to my existing report mentioned before using choose report (small arrow). in my page load code behind, I create an instance of that class and now, I don't have any idea how to bind that data. can anyone help me out please?
This is the WPF Window Class:
public partial class MainWindow : Window
public Bitmap image;
public CaptureModel cm = CaptureModel.Instance;
image = cm.Image;
DataContext = this.image;
CaptureModel.Instance.PropertyChanged += new PropertyChangedEventHandler(Instance_PropertyChanged);
void Instance_PropertyChanged(object sender, PropertyChangedEventArgs e)
if (e.PropertyName == "ImageChanged")
this.image = cm.Image;
And this is the .xaml for it:
I have a BDC xml file which specifies a finder and a specific finder method. These both work fine.
What I want to do is configure the application so that when connected to a list column the object picker uses my finder method rather than the specific finder method which it defaults to. Is this possible?
For further explination if you look at the following image
If I want to find the department using the objet picker I have to type the full identifier.
If I click the browse (address book icon) to popup the browse window I can then use my finder method. I want the initial object picker to use my find method and if there multiple matches be able to pick one using the popup you get when the message "No exact
match was found." is displayed.
Hope this makes some sense!
the dilema is I can use standalone report builder 3.0 to create report from sharepoint list data source. But I cannot upload any report(not just sharepoint source) from report builder 3.0(standalone) to report server
I can create report model in sql BIDS for report server and using builting report builder 1.0 to create a report, but the data provider in BIDS only shows SQLclient and Oracleclient