VS 2008 General Approach To Databases?
Jan 20, 2010
I am often asked to create a very simple database front-end for friends or family, and the structure of the database (and application) is usually very similar.Right now I am always creating a class that handles all database interactions with some shared functions. For example, there's a function to run a general query and return a table, a function to save/load various items (depending on the application of course). The point is: the code is nearly always the same except for some slight variations.
View 5 Replies
ADVERTISEMENT
Sep 8, 2010
DB/Reporting :: General approach to a db project
View 2 Replies
Apr 21, 2011
I have a (pretty large, 1000 lines or so) class with a lot of properties, both regular,overridden and overloadd properties. I currently add this in front of the property to hide it from the designer:<Browsable(False), DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)>This is all great, but it adds quite some lines to my project. How can I specify, for my class or project, that it should add the above settings to all?Or even better: set the above settings for a block of code instead of a single property.
View 17 Replies
Jan 29, 2010
I am working on a signout system I have a good start but am trying to solve a small problem.Signing out equipment I fill part of a form with student data from the dataset with Fillby, fill the other half with equipment data using Fillby1 I then save this combined data to my Access 2007 Database using a OleDb.OleDbConnection.
[Code]...
View 4 Replies
Mar 26, 2011
I'm looking at implementing a piece of software I've created into a new environment. It is currently accessed via network share by users who have full administrative permissions on their user accounts. These same users will have their accounts locked down excessively. I am wanting to consider now before any changes have been made, any code changes I will need to make as my application makes use of a lot of features that admin users take for granted such as registry editing. My program is running through the .net 3.5 framework and is being accessed on XP machines.
View 5 Replies
Apr 8, 2009
I am making a program that will take your initial balance of your checking account and then you can enter your checks, deposits and withdrawls into a database. Then The option will be given to return a report of deposits, withdrawls, etc. Well, I am having the problem with creating a database I can open when the program runs, first time to get the initial balance, and after to tell current balance. Then, I need to just keep on adding the new checks, deposits, withdrawls to the database everytime the person uses it. So, say I used it and put in 5 checks and then a week later I use it and put another 5 in. I want to be able to give a report of all the checks that have been inputed (this example is 10) back out to the user. So, essentially my question is, I guess, how would I create a database in VB 2008 that I can keep adding to it everytime it gets used?
View 1 Replies
Aug 15, 2009
I'm relativity new to VB programing and was working on implementing a database into my current project. However last night I was trying to add one and the program had encountered some error while I was trying to add a database which I accidentally closed without reading, at which point i promptly restarted the program to find this error whenever I try to open/edit the database.This leads me to believe that the error had stated that it was disabling something on me, and perhaps some way to re-enable it. I cant seem to recreate the error on my other system so i have no idea what to do.
View 2 Replies
Nov 22, 2011
The error is raised after a normal user changed his password on - Windows Server 2008 Standard server joined to a workgroup
View 4 Replies
Jan 27, 2012
I want to VS 2008 connecting to databases
View 3 Replies
May 12, 2010
Not sure if I'm posting this in the right area, but here goes anyway. I've been working with sql databases for practice, but can't seem to get around one thing; after I add it as a data source, I can't go back and add tables.
I start off by going through the project, then add item, choose the service-based database, and go from there. I add the tables, then go in and add it as a data source.
After I've added it as a data source, I can go back into the .mdf form and add lines and edit properties, but it wont update in the data sources. So, I can't add it to the form.
View 2 Replies
Jul 6, 2010
I will start a new project, use the queries and dealing with databases using LINQ or SQl ,Which is better to start ???
View 4 Replies
Apr 25, 2012
I wish to incorporate general expressions in my Visual Basic work.Other than the basic inputting "Imports System.Text.RegularExpressions", I have no idea how to do put general expressions in my VB project.However, I can create the expressions (so, all is not lost).
View 1 Replies
Jul 29, 2011
I am making a maze game and I want the cursor to be a different cursor that I made but I'm not sure how to change the cursor without having it hovering over a label or button.
View 7 Replies
May 13, 2011
This is going out to the forum at large. Where can I find the most complete explanation of the use of the DataGridView control in VB.Net? Any publication, or on-line reference except MSDN, please. I can never make heads or tales of MSDN.
Likewise, a complete tutorial on the usage of XML within the .Net Framework would be appreciated. Same qualifications as above.
View 8 Replies
Aug 16, 2009
i have a question in VB6 you can make a program to start from a module but in .net i can make it only if i choise it as console application. my question is how can i make it if it is posible. i make in module sub main
Module mdlMainBegin
Public Structure FInfo
Dim InitPage As String
Dim HistoryFilPath As String
[code]....
View 5 Replies
Jun 13, 2009
i successfully deployed one application but some small small issues coming in that...Here i want clarify some common doubts in redistributable components...I created one windows application in VS 2008 with C# as language and SQLServer 2005. I created msi setup application in vs 2008 itself. My application includes 2 third party tools. One is for skin and another is for capture images from different devices like camera, web cam etc...Database i deployed is sqlexpress 2005
Generally i added the following prerequisites:
1. Dot Net Framework 3.5
2. Windows Installer 3.1
3. Crystal Report basic runtime for vs 2008 (x86, x64)
4. SQL Server 2005 Express SP2 (x86)
For all these i have no doubts except 4th one.Other than these prerequisistes my first third party tool(for skin) include Visual C++ 2005 Runtime. For this i tried Visual C++ Runtime included in the VS 2008 prerequisites but not worked. So i downloaded Visual C++ 2005 for x86 and x64 and create the custom prerequisites using "Bootstrapper Manifest Generator" and its working successfully For the second third party ocx component (for live video from devices) they telling the following compenents other than ocx component.
a. MFC Libraries (gdiplus.dll, msvcrt.dll, mfc42.dll)
b. DirectX 9 runtime or better
c. Windows Media format runtime files (they gave wmfdist.exe)
I told the system OS requirement is Windows XP SP2 or Vista. Architecture 32 bit and 64 bit(with conditions)
1. I didnt include the 3 MFC Libraries (gdiplus.dll, msvcrt.dll, mfc42.dll) in my setup application Yes i not included the these dlls. But i didnt get any error up to now. I think XP SP2 included these files. Any problem raises in vista or somthing other machines if i leave these files or these files updated when i installed that Visual C++ 2005 runtime? Because when i search MFC libraries i got the result as visual c++ runtime. Please clear about this and tell the i want to include or not?
2. I didn't include DirectX 9 runtime I dont have any common doubt in this because mostly sp2 inludes directX only. But if i inluded these can you give the latest and best redistribution component download link? I dont know is this component differe 32 bit or 64bit?
3. I didnt include Windows Media format runtime files This also i dint included but not got any issues. But some customer told that grains like coming in the live screen. Is this because of unavailability of these component? For include this i didnt got the download link. But i download the sdk from the following link...
[URL]
I installed and i got the same wmfdist.exe as the third party gave. My doubt here is is this support for vista also .. Any incompatabiliy for 64 bit.? if then can anyone give the 64 bit redistribtuion component download link also.
4. SQL Express 2005 Express 64Bit As this application want to support 64 bit also...i want to include 64 bit express edition. But i think the 64 bit support is express advanced version only. Here my problem is if i download tht i cant create custom prerequisites for sql express because i am not well in this.
View 2 Replies
Oct 15, 2007
We are excited to support all your Innovate On Office support questions and inquiriesthe following guidelines before posting your inquiry to this forum.Please expect up to 24hrs for initial response from an engineer after posting an inquiry to this forumPlease expect to receive status about every three days of status on your question/inquiry to this forum
View 14 Replies
Jun 5, 2010
whipped up this code real quick which uses a ThreadPool on Form Load to iterate through my subnet and tell me if there's a device communicating at each IP address.
some questions: Why am I able to update BOTH my label at the top AND the listbox, but I'm only using an .Invoke on the Listbox?How can I know how many threads are currently being used while that is executing?
What does the SyncLock do?I'm aware some people don't like the use of Application.DoEvents(). Is it ok to be using it in this instance or is there a better practice?For those wanting to try it out, drag a Label and a Listbox to a new form. Label is called "currentIPTextbox", Listbox is default name.
[Code]...
View 14 Replies
Dec 15, 2011
OK, I have this loop I want to perform which involves the serial port. Not to get too specific I'm actually sending data to an external device within a loop The loop involves a Start number, increments by a Step and ends when it gets to Stop This repeats until I click a STOP button.
View 15 Replies
Apr 15, 2010
I have a MustInherit Parent class with two Child classes which Inherit from the Parent.How can I use (or Cast) Me in a Parent function as the the child type of that instance?EDIT: My actual goal is to be able to serialize (BinaryFormatter.Serialize(Stream, Object)) either of my child classes. However, "repeating the code" in each child "seems" wrong.
EDIT2: This is my Serialize function. Where should I implement this function? Copying and pasting to each child doesn't seem right, but casting the parent to a child doesn't seem right either.
[Code]...
View 1 Replies
Apr 14, 2012
I'm making a program to protect custom game files from being copied as best I can, however there are a couple things I need to account for. Some of them I have, others, I have not been able to find information on. When the files are not in use, I have them fully encrypted and hidden from the lay user through a bunch of other tricks (+s attribute, for example). However, I would also like to prevent copying these files while they are being used by the game - obviously I cannot have them encrypted while the game is attempting to read from them.
This opens up a hole, which I have also tried to deal with, but I know my attempts in this regard are less than thorough:
Stop several known well-known copy programs from operating during operation, that being Windows Explorer, Teracopy, and cmd
Now, the other solution I was thinking of was a filesystemwatcher object scanning the better part of the computer for any copies of these files located outside of the "OK" directory, but I'm a bit skeptical as to whether or not this would be very efficient. Any ways to make copying these files difficult without rendering them unusable to the program.
View 1 Replies
Jan 5, 2010
If you have a separately declared PUBLIC INTERFACE and then IMPLEMENT that INTERFACE.
1) My general question: Is an INTERFACE simply a means to ensure that a CLASS implements all the methods defined in an interface and to ensure that they can only be implemented once?
I have noticed that a method that IMPLEMENTS an INTERFACE method can still have overloads though. :-)
If so, when combined with INHERITANCE though I believe I can finally see the use for defining an INTERFACE!!
2) Do you have to use an interface when linking to a VB6 project ( is this via Component Object Model or COM ) and if so, do any attibutes need to be applied when doing so?
Here is a code snippet.
creating a PUBLIC INTERFACE outside of any CLASS. I guess this would not normally be done from an OOP point of view?
Public Class ExampleClass
Implements MyActions
Implements Whatever
[Code]....
View 5 Replies
Jan 12, 2010
I am using VB express 2008.How I can create a General Ledger Style Listview with alternating colourd rows.
View 4 Replies
Aug 9, 2009
I have created financial program but i need general regular expression for the formula which I will create it.
View 4 Replies
Mar 28, 2012
I plan to use iTextSharp 4.04.0 for my program for creating pdf on the fly.My find out that iTextSharp 4.04.0 is release under license GNU Lesser General Public License (LGPL).I have searched online but can't really undestand what GNU Lesser General Public License (LGPL) is.My question is does the dll which released under GNU Lesser General Public License (LGPL) is free to use? Free to use by the company?
View 1 Replies
Mar 7, 2009
url...I'm working on a simple MP3 player and are stucked on some Treview.Click and Listview.Items.Add problems which I cant seem to get past.What I'm trying to do is first with a button launch a FolderDialog to get folder path, when this is done I add the directories and subdirectories to tvFolders1 (Treview)For the whole procedure for this see classes LoadFolderTree(), LoadDir() and tvFolders1_AfterExpand.This seems to work just fine and no problems as far as I can see The we add a feature where user click on the Treeview (tvFolders1) and we are supposed to do the following: On tvFolders1_AfterSelect (when the user actually select something)I am the trying to add Items and subitems to the lvFiles control (Listview)[code]Now adding items and subbitems goes just fine if I:
1. Do not clear the ListView lvFiles in the Class tvFolders1_AfterSelect But I need that, I want the listview to be cleared before adding new items/subitems or we end up with an enormous list
2. Only add more items to the ListView without doing anything more
If I clear the ListView lvFiles in the class tvFolders1_AfterSelect the application will simply freeze and crash after clicking on any item in TreeView tvFolders1So basically somewhere in my code there is something causing this and that's were I need help, I where hoping someone could figure out what I need to do..I have pasted the whole code for that form because I suspect the problems are not in the adding/clicking on items but somewhere else, I do not know though.There is also a "bug/another big problem" in the adding of items/subitems to the lvFiles ListView and that is that the first mp3 file only gets added with file/path and not ID3.
View 3 Replies
May 14, 2009
I'm trying to make more use of namespaces and giving my project a more rigorous design, as it has been getting pretty messy.I was wondering,before I get started, is there a standard convention for the names and organization of namespaces?For instance,for a 3-tier program, should there always be a "UI", "Business",and "DataAccess" namespace (and is this what they're typically called)?Or should I just organize the project as I see fit?
View 2 Replies
Jul 28, 2009
I understand that there are several ways of Inserting, Updating and Deleting records in a database such as DataAdapters, DataSets, TableAdapters, SqlCommandBuilders, Parameterized SqlCommands, StoredProcedures, etc, etc,etc. According to David Sceppa Sprocs are the most preferred. Ok, I go with him on this one (who am I to challenge him anyway?).
My question is, apart from Sprocs, which of these options is the BEST for a large commercial database application and why, taking performance into account? What are the benefits and drawbacks of each option?
View 4 Replies
Jul 18, 2009
I am writing a program to assist Paramedic students in learning the Drugs that they have to know in order to pass their classes. I have created an Access database to hold all the information on these drugs, but not every student that will use this program will need to learn all the drugs contained within this database.
Right now I have 43 drugs in the database and still growing.
What I want to do is to present to the student the drugs and have them say "Y" or "N" as to whether its on their required list to learn. That way they only work on the ones that they need to.
View 3 Replies
May 18, 2012
I've two BGW with similar coding but different approach, My second BGW shows me "NOT RESPONDING" whenever i try move/click/focus to form while the BGW is running.
VB
RichTextBox2.AppendText("Some Text")
process2.ReportProgress(inc)
My.Computer.Network.DownloadFile(andpic, "pics/" & spliti(0) & nnum & ".png")
My.Computer.Network.UploadFile("pics/" & spliti(0) & nnum & ".png", "ftp://ftp.mywebsite.com/domains/mywebsite/public_html/Pics/" & spliti(0) & nnum & ".png", "users", "password")
WebBrowser1.Navigate("Mywebsite")
I've taken out number of things that i think is causing this error Are they the cause of "NOT RESPONDING" ?
View 4 Replies
