Search results for query: *

I'm not sure which forum to ask this question so here seems as good as any. Can anyone recommend a third party component that will do the following please: I'm looking for a component that can sit on our server (server A) and transfer files a second server (server B), every hour. The second...

Could someone please point me in the right direction. I have an XSD file which declares an element of type Location: <xs:element name="location"> <xs:complexType> <xs:sequence> <xs:element name="autologid" type="optionalIntType"/> <xs:element name="locationname"...

I need to write a component to automatically pull files from an SFTP (NOT FTP) server every 15 minuites. Can anyone recommend a thirdy party component for SFTP connections, preferrably one they have had experience with? TIA Smeat

Does anybody know of a good thrid party component I can use to read data from an Excel (.xls) file? Nothing fancy required, I just need to read data and insert it into a database. I've been writing a component to do this using both the Office interop components and the OleDb provider and have...

My website is using a treeview control and everything is working fine on my development machine (win xp) and the pre-production server (win 2k3) but the treeview doesn't work when deployed to the production server (win 2k3). I've been digging around and it seems the cause is that it is unable...

I have a stored procedure running on sql server A that needs to pull data from sql server B. Sql server B has been linked to sql server A. What is the syntax to query sql server B when sql server B has an instance name specified? I.e. SELECT field1, field2 FROM...

Hi All I'm having a problem with an SP im using to produce a report. In summary, I'm using a cursor which is working but when I execute the SP I get a resultset for every loop in the cursor. Any ideas how I get it to just return the results of the last SQL statement? Here's the code I use to...

We have been trying to render a progress meter using Ajax but have failed due to a conflict with Component Art controls so I now need to look at an alternative solution. What I would like to do is render an animated gif down to the client before any processing begins. The following is a sample...

Hi I would like to create an abstract base class that inherits from a generic type so that my subclasses can dictate what type to inherit from. For example: /// <summary> /// Provides common functions. /// </summary> abstract class CommonBase<T>: T { protected CommonBase() { } }...

Hi All I have a site that I want to keep open to everyone but protect certain folders. Furthermore, I want to direct the user to different login pages dependant on which folder they are attempting to access. Example: If the user attempts to access a page in the Protected directory, they are...

Hi All There doesn't appear to be a specific forum for this question so i'm posting it here as I know you guys are most likely to be able to help. I'm starting a new project where I need to import data from multiple spreadsheets into a data warehouse and (for various reasons) would like to use...

Hi All I'm completely new to MySql to don't laugh too loud if this is a really stupid question. I need to query data from a MySql database based on a date field but I notice all the date fields appear to be stored as numeric data types, see below: Ticket_ID Opened_Date Closed_Date 1...

Hi I have the following sql where I am trying to get the number of records created on each day regardless of the time it was created: SELECT CAST ( ( STR ( YEAR ( DateCreated ) ) + '/' + STR ( MONTH ( DateCreated ) ) + '/' + STR ( DAY ( DateCreated ) ) ) AS DATETIME ) AS MyAlias...

Hi All When reading data from a text file using the StreamReader class it is adding unwanted characters to the data. When I read my text file using NotePad it looks like this: "","","1-RF98G","ENU","","Jones", When I read it into a string variable using the following code...

Hi All Is there any way I can have an outer join that only joins onto a single record. I.e. I am selecting data from my customer table but also want to include data from their last order. so Select C.Title, C.FirstName, C.LastName, O.OrderDate AS LastOrderDate, O.OrderTotal AS...

Hi All Each of my .ASPX pages inherits from 1 of 2 available base pages, each of which makes up part of a chain. For example, I have 2 web pages: Page1.aspx which inherits from CustomBasePage1 and Page2.aspx which inherits from CustomBasePage1 which inherits from CustomBasePage2 In my...

Hi All Most web sites are optimized for a certain resolution such as 1024 x 768. I want to build a site that is optimized for 3 resolutions: 800 x 600 1024 x 768 1280 x 1024 How would you go about doing this? Can this be done using CSS? Regards Smeat

Hi All Is it possible to have a conditional where clause in a stored procedure? For example: CREATE PROCEDURE dbo.EnquiryList @LocationID int AS SELECT ID, EnquiryDate FROM Enquiry IF @LocationID > 0 THEN BEGIN WHERE LocationID = @LocationID END ELSE BEGIN WHERE LocationID...

Hi I have a web application that contains a web user control in a sub directory. App Root --> Administration --> Toolbars -->AdminToolbar.ascx I want to pass this control as a paramter from within a standard .aspx page located in the root...

Hi All In a .NET 2005 web application I am using themes to control my UI. App_Themes ---Ford ---Images ---rvname-logo.gif ---Styles ---Default.css In the themes stylesheet I have the following...