Search results for query: *

Hi all, I'm practicing with the C# 3.0 Language Enhancements and get stuck with the following issue on method extensions. The goal is to write an Equals method for the datetime type which accepts an additional parameter indicating until which level the comparison must be done (Year / Month /...

Hi all, I'm currently creating an XSD to validate my xml file. I wonder wheter it is possible to force a set of attributes depending on the value of a different attribute? For example I have the following XML structure: <charColumn columnName="" maxLength="" allowDbNull="" /> <numberColumn...

Hi all, For one of my project I needed a function that returns a table based on some parameters. In SQL Server this is pretty easy but in Oracle it took me quit some time. Therefor I've posted a sample on how to do it on my blog...

Hi, I have created my database diagram with Visio. Each time I want to export a report from the database via the Report Wizard, I need to specify the fields I want to include. Is there a possibility to create a personal template to be used to export the database diagram? The version I'm using...

Hi, I have a ASP.NET 2.0 application and want to use an RDLC report in it. I only want to use the report to export to PDF and return the PDF to the user. How can I do this? The report is embedded in the application (site is in DMZ). Thanks in advance, Geert

Hi all, I have an WinForms (2.0) application that uses a tabcontrol with 3 tabpages. Each page contains a single UserControl that contains all the controls. The problem is that when I switch tabs, the rendering takes a while. The pages only contains about 22 controls (10 labels, 8 textboxes, 2...

Hi all, I have a database that is in a DMZ. To be able to access the DB easily I was planning to create a web service that does all the DB access so that it can be used via a WinForm app over the internet. My intention was to pass a SQLCommand to the WebService but apparently this is not...

Hi guys, I'm currently reading a book (APRESS - ASP.NET 2.0 Unleashed) and found a nice way to upload big files in SQL Server. It uploads the files in chunks of data in case of all at once. The problem is that the sample uses SQL Server 2005. It uses an update statement with the .WRITE...

Hi all, I need some guideline for deployment of OLAP cubes. We have 2 servers (PROD and DEV) which are both SQL 2005 servers. Is it possible to work on 1 single server simultaniously? The issue that we have now is that the changes from the first user are sometimes overwritten by the changes...

Hi, I've got 2 versions of Reporting Services installed (2000 and 2005). Both are running on their own database (2000 and 2005). When I launch reports from the 2005 version, everything works fine. When I launch reports from the 2000 version the site first requests credentials. When I provide...

Hi all, I've created 1 solution and added all my packages in different projects (like DIMENSIONS, SOURCES_SAP, ...). For each project I have a Data Source that connects to the server. The problem is that when I want to deploy a package to the server that I always need to change the Data Source...

Hi all, I have a SSIS package that reads all the files from a given directory to a SRC table and then move the file to an archive directory. I would like to have the directory with the source files to be dynamic. I've succeeded to make the archive directory dynamic (variable) but I don't find...

Hi all, I've altered a table (DIM_TIME) by adding an extra column. Apparently there are multiple views that do a SELECT * FROM DIM_TIME. The problem is that by adding the column, the views are mixed up. Is there a possibility to reprocess all the views based on a specific table ? Or is there...

Hi all, I'm having a problem with selecting the last filled cell from an excel worksheet. I've looked on the internet and found xlCellTypeLastCell. Unfortunately it doesn't work for me. I have a sheet with 10 items but it always selects only the first cell and not all the cells. Does anyone...

Dear all, I'm having a problem with debugging a webservice on a remote pc. The remote pc is a Virtual PC with windows XP on it and is set in a workgroup. The machine I'm using to debug the webservice is also a Windows XP but is in a domain. I installed the Machine Debug Manager on the remote...

Hi all, I have a webservice that creates an image. I want to show the result of that image on my website. The website and webservice are on different servers. There is a VPN line between both servers. What is the best way to sent the image to my website? - save the file on a share - sent a...

Hi, I know that I can use the SET command to change the value of an identifier. But how can I retrieve the value of an identifier without changing it. Thanks in advance, Geert Kind regards, Geert Verhoeven

Hi, I have a single datagrid which contains customer/order info. Currently I use the infragistics datagrid because I didn't know how to setup the collapse/expand functionality in the .NET datagrid. The problem is that Infragistics consumes a lot of resources. Therefor I want to recreate the...

Hi, I have an application that is used by +/- 10 people. It is an application that has a grid which contains all the info of the customers. If one of the users updates a customers, the others doesn't see this immediately. At the moment I have a timer to autorefresh each 5 minutes but I don't...

Hi all, I have a problem. I have a stored procedure (up_generate_table) that returns a table (select command). From another stored procedure I should be able to make a select statement and join on the table returned by up_generate_table. Does anybody have an idea on how to do this ? Thanks in...