Search results

  1. V

    Question Most efficient way to save boolean value with history

    I'm making a tool to help some team members process some things more efficiently. Originally it was just for one person, but now several people are using it, and I'm trying to coordinate their efforts so they don't end up working on the same things. With that in mind all I really need to do is...
  2. V

    Question Insert from Select Statement

    Okay, I'm extremely frustrated with this, especially since I know I'm probably just doing something really stupid. Basically I've got two tables with nearly identical structures (simplified here for clarity...I hope)CREATE TABLE MyTable1 ( ID NUMBER, STATUS_CODE NUMBER...
  3. V

    Question Scraping web page: Protocol Violation

    I've got some equipment that I can connect to via my web browser to get some diagnostic info. A friend wrote a Bash script on his Linux machine to scrape some of that data, and I'm trying to mimic that functionality in .Net. The problem is I'm getting a Protocol Violation that neither my...
  4. V

    Question Default value at declaration or in constructor?

    One would think I'd already know this, but I never really gave it much thought before now. When declaring a member variable for a class, is it better to set the default value at the declarationPrivate m_strMyVariable As String = ""Or is it better to do it in the constructorPrivate...
  5. V

    Question Making Oracle SPs act like Sql Server SPs?

    I had been under the impression that Stored Procedures were essentially queries stored in the database for easier consumption and alteration without having to change consumer code. Clearly I was mistaken, since Oracle apparently doesn't use SPs in that way at all. In particular, coming from Sql...
  6. V

    Question OO Design: Use Getters/Setters Interally?

    This is probably a stupid question, but when accessing an attribute from within a class is it generally better to access the private variable directly, or access it using the getter/setter? Of course the whole point of encapsulating attributes is to allow changes to the underlying code without...
  7. V

    Question Weighted Average for Log In Percentage?

    As part of some performance stats that I've been maintaining for employees where I work I've had to calculate the total percentage of time that they spend logged into their computers. Getting the necessary values is a nightmare, but ultimately the final calculation is quite simple...
  8. V

    Question Observer Pattern for Logging?

    About a year ago I threw together a quick and dirty logging system for my class library (it's a dll) using the Observer pattern. Essentially the entire library shares an Observable class through which all messages are sent. Any code using this library can create an observer and subscribe to that...
  9. V

    Question Attaching a file that doesn't exist

    I've got a logging system that emails me log files whenever certain conditions are met. Unfortunately I find myself in a situation where I am not allowed to write files to the disk that my program is running on. For the time being I'm just saving the logs internally as a big a-- String instead...
  10. V

    Question <Attribute>: ParamArray in Constructor

    A former co-worker wrote a class in C# that was to be used as an attribute. I'm having to convert his work to VB (yeah, it's pointless and way more work than necessary, but management thinks it's a good idea). Unfortunately I'm having an issue because one of the main properties of the class is...
  11. V

    Question Dump Query Results Into Text File

    I've got a whole bunch of data that is stored in various Access databases that I need to transfer over to an Oracle database. Right now I'm just creating an Odbc connection to the Access file, reading the data, creating an Odbc connection to the Oracle database, then looping through the data...
  12. V

    Question Sybase: DateTime Column Named Timestamp

    I'm trying to get data from a Sybase database for a DAL in VB.net via a DataSet object (.xsd file). This in and of itself isn't a problem, except that the tables that I am trying to access have a column named Timestamp, which is a DateTime type column. This means that when I attempt to select...
  13. V

    Question AddParameter Method results in "ORA-00936: missing expression"

    As usual I'm copying other people's code and modifying it for my own purposes. Also as usual it's not going so smoothly. Essentially someone wrote some helper methods for a DAL using Sql Server, and I'm trying to convert it so that it can access Oracle instead. Here are the methods as I've...
  14. V

    Question Base Class Collection with Sub Class objects

    I've got some code that I copied from someone else and I'm having trouble making it work that way that I want. In essence I've got a collection (i.e. it inherits CollectionBase) for a class that acts as a base class for other classes and I can't seem to validate it properly. The problem is in...
  15. V

    Question Style: Data Only Class?

    I've got a number of classes that I'm building based on existing databases. What I'm thinking of doing is creating some other classes that essentially do nothing but mirror the data columns. Basically no behavior, but lots of attributes. In effect I'd have something like this:' Represents raw...
  16. V

    Question Global Variable in ASP.net

    What is the simplest way to have a global variable on an ASP.net site that is shared by everyone on the site (i.e. not a session variable)? The reason I want this is because I have a notification system that emails me in case of an error. If it's an error that affects everyone on the site I...
  17. V

    Question VS2010 on both main and laptop?

    I have been using VS2005 for the last few years and I had it installed on both my main computer and my laptop. I'm thinking of getting VS2010, and I wanted to make sure that I could install it on both computers without having to pay for it twice. Is that possible? Or will they try and make me...
  18. V

    Question Column Named Timestamp

    I'm trying to create a DataSet in VB.net which accesses a table in a Sybase database. One of the columns is named Timestamp, and trying to select this column is causing problems due to it's being a reserved word...plus the fact that the datatype is a datetime and not a timestamp. Here's the base...
  19. V

    Question DataSet Variable Length Parameter List

    Is it possible to include a variable length parameter list in a DataSet? For example, I know that I can have a query with a single parameter that takes an ID for an employee and gets the data based on that. But what if I want to get info on 10, or even 15 specific employees? Is it possible to...
  20. V

    Question Changing Sql Server Database reference at run time

    I'm new to using datasets and I'm not sure if I can actually accomplish what I'm trying to do, so I want to verify before I mess something up. Basically, if I create a dataset called MyDataSet in my data access layer at build time pointing to a table called MyData, and I have two different...
Top Bottom