Search results for query: *

I am using ReportViewer in local mode. Can I set more than one data source in the DataSetName property (in a table)?

I have a localreport (RDLC) has about 12 subreports. Within each subreports, there could be 2-5 more subreports. It is taking the ReportViewer too long to load the report because for every subreport, the SubreportProcessingEventHandler (SubreportProcessing event) is triggered to get data from...

I have a localreport (RDLC) has about 12 subreports. Within each subreports, there could be 2-5 more subreports. It is taking the ReportViewer too long to load the report because for every subreport, the SubreportProcessingEventHandler (SubreportProcessing event) is triggered to get data from...

How do you handle the ArgumentOutOfRangeException thrown from a DropDownList within a gridview? I have a editable field containing a DropDownList. The list is bind to a data source. Basically, the error is thrown because the item no longer exists in the list. When this exception occurs, I just...

I have two boolean variables called ExtractSuccess and LoadSuccess defined with package level scope. I want to be able to assign a value to the variables in the Data Flow tab. Is this possible? If so, is it also possible to retrieve the OLE DB Source and OLE DB Destination task execution result...

I have three environment: development, test, and production. I am using Subversion and I want to be able to use Ant to build the latest version of my project in source control and deploy to the test environment. Any suggestions or how I can do this would help me get started. Thanks.

What is the syntax to query a table from Oracle? I have tried Google, but had no luck. Anyways, here's some information on my database. I'm trying to write the query in MS SQL Server 2000. The Oracle database is 8i. The linked server name is LOANIMG. Database name is RPT. The schema is...

I have a lookup table that I want to update with the following query: UPDATE VARIABLE_BACKLOG SET LASTCUTOFF = Get_Last_Cutoff_Date(WORKTYPE, SYSDATE), NEXTCUTOFF = Get_Next_Cutoff_Date(WORKTYPE, SYSDATE), CAPTURETIME = SYSDATE Get_Last_Cutoff_Date and Get_Next_Cutoff_Date are custom...

Anyone know what is wrong with this code? DECLARE v_deptexclude VARCHAR2(30) := 'Direct Retail Lending%'; v_queuetype VARCHAR2(10) := 'new'; v_catgnew VARCHAR2(10) := 'NEW'; v_catgbacklog VARCHAR2(10) := 'BACKLOG'; v_stepname1 VARCHAR2(10) := 'Complete'; v_stepname2 VARCHAR2(10) :=...

I am trying to compile this procedure in Oracle 8i: CREATE OR REPLACE PROCEDURE Sp_Update_LSAPP_WORKFLOWSTATUS IS BEGIN DELETE FROM LSAPP_WORKFLOWSTATUS; -- INSERT INTO LSAPP_WORKFLOWSTATUS SELECT DEPARTMENT, DEPTINITIAL, SUM(CASE WHEN CATG = 'BACKLOG' THEN 1 ELSE 0 END) AS WOB_BACKLOG...

I'm am using VS.NET 2003 to build a web application that displays data from Oracle 8. In my data access layer project, I have a function that returns a data set: Function getDATA() As DataSet Dim objCommand As New OracleCommand(strSQL, objConnection) Dim objDataAdapter As New...

If given a unix timestamp, how do I determine which timezone to use (EST or EDT)? I'm trying to edit this function to automatically return the right time zone with the value passed. CREATE OR REPLACE FUNCTION Unixts_To_Date(unixts IN PLS_INTEGER) RETURN DATE IS /** * Converts a...

I have a web form with a datagrid. When I installed the web application to my test server, the gridline colors in the datagrid is what I wanted (red). But when I installed the same web application into my production server, the gridline colors changed to something else (silver). Here's a piece...

I want to create a report where the user can select the display format (Excel 2000 or HTML) and have the report remember what the user selected after he/she drills down to the second report. The 2 drill-down reports will be created in a procedure file. The user will make their selection and run...

I have a dynamic datagrid where at ItemDataBound event I need to change align attributes asssigned before runtime. I'm using this code and it doesn't work: e.Item.Cells(4).Attributes.Remove("align") e.Item.Cells(4).Attributes.Add("align", "right")

I know how to set the GridLines at web designer, is it possible for me to change the gridlines at run-time? I want to display the gridlines for certain rows only.

My VB code is something like this: Select Case e.Item.ItemType Case ListItemType.Header e.Item.Cells(6).Text = "Assessed Dollars MTD" When I do this, it takes away my sort functionality for that column. How can I change the datagrid header text and still make the...

How can I do a left outer join on multiple conditions?

I have two columns in a datagrid next to each other that I want to merge the headings only (much like what you would do in excels). How would I do this in my VB.NET code?

I have a VB.NET application that reads a text file to write to a database table. The text file may contain a "Return" character which my application does not recognize and causes the application to error out. I read one line from the text file into a string and parse the string using...