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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.