Search results for query: *

Cheers John, I thought that might be the case, thanks for your response :)

I have this website that stores my template files for Word, Excel, etc and I need to be able to download them through my .Net Application. I can easily download a file if I know the name, but I want it to parse all the files in the given web directory and download them, without me having to...

how many layers would you have? I already have: Business Layer - which has all of my logic in it (well most of it) Common Layer - which houses all of my objects (classes and collections) Data Layer - which handles connecting to my database Are you saying I should have another layer (what would...

no one? :(

I use collections. I have been for about 2 years and they have worked fine for me. I decided that I should read about design patterns and UML to improve my programming. When reading these books, I found that perhaps my collects were not as they were supposed to be. My classes all have one thing...

I have seen this question asked before, but I am struggling. I have created a stored procedure which is pretty complicated. Here it is for reference: ALTER PROC ChangeoverEffeciencyReport @DateFrom DATETIME , @DateTo DATETIME AS BEGIN CREATE TABLE #Temp ( DepartmentID INT NOT NULL ...

I am assuming you mean the current year. Try: Function ReturnDateForWeekNumber(ByVal iWeek As Integer) As DateTime Return DateAdd(DateInterval.WeekOfYear, iWeek - 1, FirstDayOfYear) End Function Function FirstDayOfYear() As DateTime Return New DateTime(Year(Now)...

For a Windows application you could set up and SQL database (VS 2010 and all VS come with SQL Express, but you will have to download SQL Management Studio to manage them). What you should do is create a table called tUsers (for example) with a ID, Name, Password fields and any other bits of...

can you post your code please?

why would you want the index number of the combo box? If you have a drop down list, then surely you want the text of the username to compare with the username in the database and match the password? I hate access, so I am not going to provide a solution because I think access should be binned...

Module Module1 Sub Main() Dim test As Integer Console.Write("Please enter a number: ") If IsNumeric(Console.ReadLine) Then test = Console.ReadLine Else Console.Write("You must supply a valid number") End If End Sub End Module

no one? It can't be that effecient, surely :o

Hi all, This isnt a problem, I am just trying to make my coding better. So a quick description. I have a base data access layer that all my data access classes inherit. It has some cool features that basically removes redundant code, because it's methods can be applied to all my data classes...

I did read your blog (John McIlhinney's .NET Developer Blog: Search results for ado parameters) and it didnt really explain anything about dates. I get your point now though and I actually solved the issue. I was using the DATETIME datatype in code and in SQL and the actual error was due to my...

I see what you are saying, but I always get an issue if I keep the date format as datetime in code. The reason (I think) is to do with regional settings, because in .Net the format shows as: 2010-05-03 00:00:00.000 but in SQL I think it expects 2010-03-05 instead....

I hate the datetime datatype. I always seem to run into issues with it. Some times it works and other times I have to piss around with converting to strings and then formatting it manually into a format that my sql server will allow. Here is my issue, surely there is an easy way (in sql) to fix...

how about using a query string to store each search value and then storing the whole query string in a session. Then when a user comes back to the search page, just check to see if the Session is not nothing and apply the filter.

just try putting square bracked around the 'Description' field. [Description]

yeah I agree, but if you were to use multiple tables then you would do it like so: SELECT a.* FROM tblProperty AS a WITH (NOLOCK) INNER JOIN tblOther AS b WITH (NOLOCK) ON a.ID = b.PropertyID WHERE UPPER(a.County) LIKE 'CORK%' AND UPPER(a.County) LIKE 'KERRY%' it's also worth noting that you...

post you query and show the records it returns so we can look at it. You might also want to tell us what columns exist in both tables and which are the primary and foriegn keys (if any) so we can help you better.