Application That Uses A Database?
May 11, 2009
I need to code a program that makes use of a database. It's gotta be for a local business, so I chose a pub lol. The database has the following columns: Beverage; Cost; Total number of sales; Income.
What the application needs to do is basically work as a cash register. Each beverage gets its own button, each click on the particular button displays the total due that the customer has to pay.
That, and the same button has to edit the database fields and update them or add to the values.
View 1 Replies
ADVERTISEMENT
Sep 22, 2009
I am having two databases for the same application , one in windows and the other is web based.Since web based one have few functionalities I can't opt for a single database.At the same time I want to share Both databases to be updated with other's data so as to work error free with my module of appointment fixing.
View 2 Replies
Jan 20, 2011
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 Replies
Jul 20, 2011
When I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
View 4 Replies
Apr 8, 2010
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
View 2 Replies
Oct 31, 2009
I have made a database application that uploads a database via FTP here is the code:
Code:
note this line:
Code:
ContactDB.mdf is the database in my application what would i have to insert for it to upload the database i have tried it as it is and its failing i could locate its full path on my machine that works but what happens when i want the application to go on someone elses pc?
View 4 Replies
Jul 21, 2006
With VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
View 3 Replies
Jun 21, 2010
i m trying to write codes for new user to fill in the form, then the new data will into my database,however, my codes doesnt work, i cant figure out what's wrong with my codes. below are my codes:
Imports System.Data.OleDb
Public Class NewUser
Inherits System.Web.UI.Page
[Code].....
there is no error encounter, however,the adding is failed and no new data can be add in.
View 4 Replies
Apr 1, 2011
so this is more of a question about application security.Say I have a application that authenticates to a database. The Users table has the following fields: UserID, UserName, Password,Salt, Active, Permissions.
The permissions field will be related to another table called "Permissions" that has a unique ID and it describs the level of access the user has to the system (reporting, add/remove users, etc).Now the question is, when the user autheticates and executes an action on the application that requires a certain level of permissions, is it better to have a class the holds an authenticated user or is it better to have the application query the database for the users permission level?
View 1 Replies
May 4, 2011
i have published my website...its a dynamic site..so i have database connectivity..now i want to make an application in VB to update my database using my application..i mean i do not want to login to the site and update my database rather update it using my application..i want to connect my application to the database of the published site and update it from anywhere i want using the application...is it possible??
How can i do it??Please point me to the right direction...its urgent.
View 3 Replies
Nov 15, 2010
My application has an access2007 db as its database. I am trying to create a backup/restore utility in my application that allows the user to take the backup or restore the database file "StudentsData.accdb" which is in the application folder. I tried the filecopy method but it gives me an error saying that the "file is not accessible, as it is being used by a process." I believe it is my application process that is using the file.
How do I stop my application accessing the database? I have database connections which i have written in code and all of them close with their respective forms.
View 6 Replies
Aug 7, 2010
I am looking to make a small application which uses 3 stages of combo boxes to filter results into subcatagories. Once the filtering is selected - I want the user to be presented with some advice, maybe even a small picture.I want the application to gather its information run from a database which will be network based via a mapped network drive on our network. There may only be 4 colums in that database. I want to be able to update the database as required.
View 3 Replies
Jan 23, 2010
I am not sure what I am doing wrong I can connect to my database on my personal computer yet I am unable to have someone else use it without getting an error. system.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, This works on my PC so I am not sure what I am not including in the project when I compile or what?
View 4 Replies
May 13, 2010
i have 1 database in sql server and i want to encrypt database. and i can connect to this database by my application
View 2 Replies
Jan 13, 2009
I am trying to create an application that needs to have a database. I would like to know which one you recommend using. I have programmed in php using mysql but I do not think that is feasible for a windows application. I want something that does not have to install something else with my application.
View 32 Replies
Jun 5, 2011
i have a problem with using vb.net application, i want to take backup of my database from my vb.net application so that user clicks the button and backup can be copied in a drive .
View 1 Replies
Sep 8, 2009
I have VB 2008 and SQL 2008. I need tutorials to teach me how to create and connect, update, delete alter etc a Front End VB app to a SQL2008 DB.
View 6 Replies
Jan 21, 2012
Ive spent AGES trying to get my application to connect to a SQL database finaly it works but now i have no idea to view specific records or add records ANY help would be brilliant
[Code]...
View 5 Replies
Jun 7, 2011
I have connected my vb .net forms to the MYSQL database but when i comes to publishing, i do not get the database on the published application.
View 4 Replies
May 5, 2011
I integrated my database in my web application. Previously I was just referring it to SQL server 2008 by defining a connection. Everything worked fine data was being fetched, calculations are done. Now when i integrated my database in the web application, problems arose.
Dim cost3 As Double
cost3 = Dataset.Tables(0).Rows.Item(0)(0).ToString
The problem is with this the error says: Cannot Convert type String "" to double. Before no such problem showed.
View 2 Replies
May 3, 2011
Please how do I link my database to the application?
View 3 Replies
Nov 3, 2009
I want to Make DATA Base Application ! Who Save DATA in XML?
View 6 Replies
Nov 19, 2011
i want to have a built in database for my project this is what i did so far, i placed the mdb file inside the project
[Code]...
View 1 Replies
Dec 12, 2009
I have an mdf file in the vb.net 3.5 project I am working on. I wanted to write an stored procedure that will create a back up of the db in a selected location. How can I take a back up of the database from my application? I want the user to take a back up of the database manually.
View 4 Replies
Apr 23, 2010
I've created a project in VB .NET. when i build it and run the .exe everything works fine but when i install it the database becomes read only. I've used the VB 'setup and deployment' project to make and installer and i also tried InstallShield but the occurs in both cases. i looked on google but can't find anything that makes sense atleast. i think the application can not create _log.LDF file. Anyone come across this problem before?
error: System.Data.SqlClient.SqlException: Failed to update database "C:........." because the database is read-only.
View 1 Replies
Nov 28, 2009
I'm asking is for someone to provide me some tutorials or something that can get me on the right track to help me connect an access database to a VB 2008 application. I need to be able to add, edit and delete this database through the Visual Basic application.
View 2 Replies
May 16, 2012
I am looking to make a database call based on user input. The line I am using is:general_read.CommandText = "SELECT * FROM general WHERE Business_Name = '" & business_name & "';"
business_name is dynamically loaded from:Protected Sub btnLoad_Click(sender As Object, e As System.EventArgs) Handles btnLoad.Click business_name = txtName.Text
[Code]...
The error that is being shown is: Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.I'm assuming it has something to do with the variable not being set before the database call is made, but I'm not entirely sure.
View 1 Replies
Mar 17, 2009
what would be the best way to manage a connection to a database in asp.net.My application is built using an N-Tier architecture.The DAL consists of static classes with methods such as
Public Shared Sub Delete( _
ByVal connection As MyConnectionClass, _
ByVal contact_id As Integer, _
ByVal contact_timestamp As Date _
[code]....
The point to note here, is that I pass the connection to the DAL from the BLL.Should I create the connections in the MasterPage, store it in an object, then pass it to my business objects as I create them (the thing I'm trying to avoid)Should I create a connection using a static class and calling a method like CreateConnection on it, from the constructor of my business objects (Something I'd like, but I don't want to have a connection per object, I'd like it to be shared for all instances of my objects, but since asp.net is multi-threaded, a static class doesn't make sense to store connections) the solution should also work well in a Windows Forms environment (So no connection storing in session, and retrieving it with a static method in a class, for the current context)?
View 1 Replies
Apr 26, 2012
I am working on a inventory application and I have a question, I have created a table for each of the main categories that I will be using, now if I wanted to add sub categories would I create another table for the sub directory and set the type as a child for its corresponding category or would it be easier to keep the main categories and just add another column in each table for "sub category" so it uses the same table but I can just filter it out easier?
If it is a better option for creating parent and child tables, how would I go about listing them in a hierarchical treeview to show parent and child sub-categories in them.
View 7 Replies
Jul 5, 2011
want to know how to connect database from window2008 server platform to ibm aix database is oracle 10g ..please anyone can help me here
View 2 Replies
