DB/Reporting :: Databases Using VB 2008?
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
ADVERTISEMENT
Jan 8, 2009
I am writing an application in VB.Net, the application stores a number of images within the database and therefore the SQL database size gets quite large. At the moment I use a single database, however what I want to do is create a new database for each project within my application. I need some advise on the best way to proceed with this and also the best way to be able to create a new database for each project. Below is the approach that I was planning to adopt:
1. When the application is installed it automatically has a common database that comes with the application and this database is attached to the SQL Server, lets call this application "AppA" and common database "AppADB" Within the AppADB there would be a table called projectsTbl and in this projectsTbl it has a 2 columns called "projectDesc" and "projectDB". projectDesc would hold the description of a project and then the projectDB would hold the SQL database name for that project.
2. The user would login to my application and in the admin side of the application have a create project form. In this form he would enter the project description and also a 3 character code for the project. When the user OK's the form it would take the project descrption from the form and put this in the "projectDesc' field in the AppADB and then take the 3 character code from the form add this as a prefix to "AppADB" and put this within the "projectDB" field within the AppADB e.g. if the 3 character code was "SIM" then the projectDB name would be "SIMAppADB"
3. What I obviously now need to do is create a new database called "SIMAppADB" now what I was thinking was I could create a SQL database backup of a database that has the standard database structure that is required and then I can restore this .bak file (which would be in my application installed directory) to this new name, using the following code:
Code:
RESTORE DATABASE SIMAppDB
FROM DISK = 'C:Program FilesAppA Installed DirectoryDB.Bak'
WITH REPLACE, MOVE SIMAppDB_Data' TO 'C:MSSQLDATASIMAppDB_Data.MDF',
MOVE 'SIMAppDB_Log' TO 'C:MSSQLDATASIMAppDB_Log.LDF'
4. Then when the user logins to my application again, on the login screen he will see a list of projects from the "projectsTbl" table in the "AppADB" database. The user can then select the project they wish to login to and from this the application and extract the database name from the "projectDB" table in the "AppADB" database. I then can store this database name in my application and when the application needs to connect to the database it modifies the connection string to connect to the respective database.
View 1 Replies
Sep 7, 2010
I am attempting to modify DBaseIV files using ADO in .NET I am able to open and read the data with no problem but everything is showing as read only and there is no way (at least that I can find) to perform Updates/Inserts/Deletes to the underlying Database table.
There seems to be almost no documentation that I have been able to find dealing with DBASE files. I have found a few references that BDE (Bordland Database Engine) needs to be installed and used for changing DBASE database files. However, it appears that BDE must be purchased. I found one reference that indicated ADO Jet 3.5 would work but 4.0 would not. Then I found another that said 4.0 had been updated to include Update/Insert/delete SQL interfaces.
Can anyone point me in the right direction for being able to modify a DBASE IV database table using ADO (or some other method within .NET) It is currently not possible to change from DBASE to another database structure this may be coming in the next year or so but will still need to perform modification to DBASE files for the forseable future.
View 1 Replies
Jul 18, 2008
My boss wants me to create local databases on the light-side of things. I was researching on what solutions are available, we discussed the possibility of using text or xml files... but we dropped the idea since we want to use SELECT, UPDATE, DELETE command sets (or the like)I proposed the idea of using Access files (mdb) but he told me that he doesn't want the user to have Access installed on their computers.What are the choices avaible, am I forced to install Access on machines that would be using my VB .NET app to access mdb files?
View 2 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
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
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
May 10, 2008
this event works ok, but the problem is that I don't know what field was clicked. Should I use objectinfo or something else? VB.net won't recognize for example e.objectinfo.
View 1 Replies
Sep 9, 2010
using Vb Net 2008 with SQL Express 2008 R2 in windows forms. that being said, I have a syntax problem in this form, form has 2 texbox an a datagridview and also the 4 components DataSet. BindingSource. TableAdapter, BindingNavigator. When I filter by LastName no problem it work fine (it's a String) but when I try to filter by CustomerID (it's alphanumeric) I get an error "Invalid character" here is part of my code: Private Sub surnameFilterTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles surnameFilterTextBox.TextChanged
[Code]...
View 5 Replies
Apr 30, 2008
I am trying to change over a program from VB 6.0 to VB 2008 and I am having trouble with the EOF statement. [code] Argument not specified for parameter 'FileNumber' of 'Public Function EOF(FileNumber As Integer) As Boolean'.I have a Dataset with a Table called Table1. How do I get VB 2008 to perform the "Do While Not Table1BindingSource.EOF statement?
View 1 Replies
Aug 21, 2008
I have vb 2008 and I have RSLinx classic, and a Allen Bradley PLC. I knwo there is a way to have vb call through linx to the PLC, I just don't know how. There are about 90 different tags in the PLC I would like to have logged into a csv/excel file. My thought on doing this was to have a very simple vb program to just collect that data and every day at midnight have it save it to a excel file. My problem comes when I try to talk to linx, I have no idea how to get them to communicate. I am just looking for some ideas on how to get that to work. I have tried link...whatever, and it seems that was for vb 6.
View 1 Replies
Mar 20, 2012
I'm trying to do a looped insert using the MySQL Connector for .NET and for the most part it's working, except for it's missing out inserts. The code below is what i'm using. An example is there are 20 items in the listview and only 8 out of the list actually insert to the mysql database. It's as if the loop runs too quickly for MySQL to keep up. My issue is that eventually this loop will be inserting many thousands of entries and I can't have it missing information out.
[Code]...
View 2 Replies
Oct 13, 2009
I am not new to vb but still an amateur, however, I am still learning linking vb apps to mysql, here is where my troubles begin. I am stuck and been trying for hours on end to get past this problem. It's starting to hurt my head! I am sure others have similar problems.I posted my imports and the module I put my public sub in. The sub is called as a form loads.The Error is:
An unhandled exception of type 'MySql.Data.Types.MySqlConversionException' occurred in MySql.Data.dll
Additional information: Unable to convert MySQL date/time value to System.DateTime
[code].....
View 5 Replies
Aug 24, 2011
We have developed a VB 2008 app that uses SQL Server 2005 Express to store data collected by this app. This app has been designed to allow multiple connections to the one centralized database.
I have ran a few tests, and confirmed that if one computer running our app is accessing a database residing on a different computer,and the network connection between two computers has been severed, it would take approximately 3.5 minutes before I would get a connection timed out exception error from within my code.
I have deliberately set the ConnectTimeout property in the SQL connection string to be 15 seconds. But some how, SQL database engine still retries until approx. 3.5 minutes later.
My thinking is that I have a subroutine that would attempt to open a database once a minute.If the open attempt is not successful, and resulted in an exception, then I would popup a message to notify the user that the connection is not available.
Doing it this way, I have confirmed that it would take about 1.5 minutes for it to re-establish the connection, once the actual network connection has been restored.
To make the long story short, I would like to find a way to shorten the detection for a broken connection, and let the user know sooner, rather than locking up the app during the 3.5 minutes period has elapsed, and at the mercy of the SQL database engine to timeout. And why would it take 3.5 minutes to timeout the connection attempt when I had explicitly use 15 seconds in my connection string?
View 2 Replies
Nov 5, 2008
I'm using VBE 2008, with .NET 3.5 SP1, and I am trying to programmatically manage a database. Here are the steps I used so far:
1. Project >> Add New >> Local Database >> Cancel Button.
2. Added a table (Files) with three fields (File Path, File Name, and File Type).
3. Went into Data Sources, did Add New Data Source and followed the wizard to add it as a dataset.
I'm not entirely sure where to go from here. I'd like to be able to use queries on this thing, but I don't want to have to use SQL to add to it and such. I've made a little headway in the code, but it's really frustrating because VBA Access was SOOOO much easier to do this kind of thing in. This is what I have for code:
[Code]...
View 3 Replies
Dec 9, 2008
In the long rung, I'm trying to setup a program to have a local database of files (It's a media player, so think of the library in WMP). I'm just trying to figure out how to do it, so this is a proof of concept thing I'm having a problem with.
Here's the code:
Code:
Dim dsDataset As New Database1DataSet
Dim drRow As Database1DataSet.FilesRow
[code].....
View 1 Replies
Jan 9, 2009
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
View 5 Replies
Jul 17, 2008
i am trying to log a user in using a login form. i have my connection to my database and there and it connects just fine but it will only read the first row. here is my code.
Code:
Dim ConnString As String = "Driver={MySQL ODBC 3.51 Driver};Server=dansoft.selfip.com;Option=131072;Stmt=;Database=elemental_battle; User=****;Password=*****;"
Dim objConn As New OdbcConnection(ConnString)
[code]....
there are two entries in the database. the first username and password are bagstoper and 1a2b3c4 the second is bagstoper2 and 1a2b3c4d. when i test it with the first username and password it works but when i try the second it doesnt work.
View 2 Replies
Mar 6, 2009
show me the connectionString of Vb.net 2008 to Microsoft Sql server 2005?
View 1 Replies
Jan 11, 2009
I have two tables in the MS Access 2003 database " SAMPLE" and they are : 1. INFO 2 INFO2Now i have created a form in VB 2008 express edition with the text boxes: Name, Age, Occupation.he tables INFO has - Name, Age as columnsAnd INFO 2 has - Name, Age, Occupation.All i want is when the user presses the ok button, it should add the name & age to INFO and also add Name, Age Occupation to the INFO 2 Table.
View 10 Replies
Nov 5, 2010
I am at a loss to figure out why this code results in 2 errors when I try to Parse it inthe SSMS.
@Collection varchar = Books,
@Title varchar = 0,
@Authors varchar = 0,
[Code].....
I think that I re wrote this query ten times todaday and continue to get errors and don't know what my problem is
There are underlines in red under the 0 in the BookLoanStatus and under all of the parameters in the SQL.
View 2 Replies
Jul 21, 2008
using VB 2008 Experess and SQL Compact Server. I find my connection string saved in my application configuration file, but when I refer to it by name I get this error message: Error 1 Reference to a non-shared member requires an object reference.
[Code]...
View 3 Replies
Sep 20, 2011
I'm considering switching office systems and now use ACCESS 2000 for my database of choice. I'm
retired and write programs in Visual Basic to keep busy.Does anyone know if a Libre database is
practical as a substitute for Access?
View 1 Replies
Nov 11, 2009
I am trying to build a report using MS reporting services (rdlc file) and having trouble figuring out syntax to take calculated data from a textbox in table1 to table2. In other words, I have totals calculated in table1 and I need to display those totals in another table (table2) and/or a text box outside of table1.
I have tried versions of =ReportItems!TextBox37.Text and =ReportItems!TextBox37.Value and =ReportItems("TextBox37").value etc. but with no luck. The last thing =ReportItems("TextBox37").value does compile but it prints #error on the report.
View 3 Replies
Jun 3, 2012
i am using webbrowser control as reporting tool ( instead of exporting the data to excel or other COM interface )i have built some HTML table structure and rows headings etc.
View 3 Replies
Mar 9, 2010
1.Establishing a connection to a database(preferably one that is inherit within the project and can travel with it)
2. Setting the correct references to the database ( I tried connecting via JET with windows 7 and I get an error that I cannot use JET)
3. Query the database (Access) with SQL, and return those results to a recordset.
4. Loop through the recordset.
5. close the database connection
6. Open recordset and write data to table.
[Code]...
View 1 Replies
Feb 16, 2012
I was hoping to save some coding by using views to access my forms in VBInstead of using a very long query I was hoping to use
Code:
Select * FROM my_view
[code].....
View 5 Replies
Nov 22, 2009
So Im working on updating our company's program from Visual FoxPro to VB and this is the first step. I can access and read data from the table
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
View 1 Replies
