Recent content by timmoser

Thanks that's what I was looking for. If we're going to do it wrong we might as well do it wrong the right way.

Is its safe to create static level methods to handle database access? DataAccessor.GetDataSet("spName",params); Or should these be instance methods? DataAccessor da = new DataAccessor(); da.GetDataSet("spName",params); I created a class to remove some of the complexities of the data access...

I have a SP that contains a cursor with an inner cursor. The SP works mostly but in the inner cursor I get an error after it updates the first record. Below is the info: Error: "Error: Number (560) Severity (16) State (1) Procedure (_test) The UPDATE/DELETE WHERE CURRENT OF failed for the...

I don't know much about ActiveX components, so I apologize if I'm way off here. ActiveX components allowed you to do things with a browser on a client machine that would normally not be permitted, like access the drives or printer. My question is what does .NET offer to replace ActiveX...

I have to build a site where a user can pass a file of zip codes and gets a result set of the closest office to each zip. The problem I have is performance. No matter what server side language I use, I will have to fire off a query for each zip code in the file. So if I receive a file of 100 zip...

Very cool, thanks!

Wow, with all the interfaces MS provides with .Net I thought they were pushing us to them. I have no problem avoiding them, I couldn't see the value of an interface if the can't contain code. Thanks for you help.

I know what to do now. Thanks to everyone for your help!

I'm having a hard time proving the value in creating and using interfaces. I thought maybe if my derived classes all had the same base class or interface in this case, I could cast between them like so... class TestInterface{ [STAThread] static void Main(string[] args){ Queen queen =...

I'm an idiot; I never set permission on the SP for the application to exec!!! Thanks

I'm an idiot; I never set permission on the SP for the application to exec!!! Thanks

I posted the in SQL2000 but it could be someone in C# can give me a clue. I am inserting a C# generated XML file into SQL2000. http://www.tek-tips.com/viewthread.cfm?SQID=783531&SPID=183&page=1" Thamks for your help!

Works for me... DECLARE @X DECIMAL(18,2) SELECT @X = CONVERT(DECIMAL(18,2),(100/11) ) SELECT @X = 100/11 SELECT @X Looks like you have an extra "(" around "SUM" try... CONVERT(DECIMAL(18,2),( SUM(count1)/Sum(count2) ))

I have a C# program that sends and XML file to an SP that updates/inserts the data into the appropriate table. Has been working fine since I put it together a few months ago. Now I want to add another update/insert into the process but im getting an error. All of the code is the same; the data...

Thanks, so they will have to download the framework and MDAC to I guess. There is no way to just pull what the app needs? We have a simple little app that would fit on a floppy disk! Seems like a waste to burn or download the entire MDAC and framework. Thanks for your help.