Database - Design And Deploy A Data Driven Desktop Application?
Jun 28, 2011
I am designing a desktop application that will be driven by local data. I am trying to determine the best way to accomplish this. The database would contain about 10-12 tables if I use a database and I would imagine no more than 10000 records in any one table (but honestly 99% of users would not have more than 1000 records). I am thinking about using SQL Server Compact.
Is this a good solution? I can certainly include this in my installation, but I am just wondering if anyone knows of a better solution? If this is the best solution, how would you suggest that I create the tables upon deployment? Should I just run "queries" with create table statements in them from my vb application or include a database file or what?
View 1 Replies
ADVERTISEMENT
Sep 2, 2010
I have developed a windows application which performs a series of database operations like select, insert, update. I am connecting to Oracle database and its working fine in development system. But, when I deployed this application, I am getting error at StartConnection (which opens the DB connection). After installing OracleClient in client system, its working fine. Now, my question is that do I need to install OracleClient to every user? If so, it will be hectic to do so as its size is around 200 MB and its not possible to ask all the users to install it just for a small application. I have tried adding some OracleClient files like orannzbb11.dll, oraciei11.dll, iraops11w.dll etc. But in vain! Could anyone please suggest me a work-around or a way to accomplish this?
View 1 Replies
Jul 7, 2010
Question: I created an ASP.NET web application. Now it originally was meant for deployment on a webserver.That is working, so, so far so good.My question now is: Is it possible to deploy it as a desktop-application, too? That is to say the installer installs some kind of server, plus the web application, configures the server to run this application on a localhost URL, and then creates a link in the start menu/desktop, where it opens that url (website, the application) on localhost in a web browser?
I think it should be possible, though the server wouldn't be IIS, because this is a windows component which can't be separately installed. Is there anything like this already out there The nonplusultra would be that it only starts the server when you click on the shortcut.
View 4 Replies
Sep 17, 2009
I have developed an application using vb.net. This application will run on approximately 15 machines at the main office and also roughly 10 machines spread over 3 different locations. I am using SQL Server Express edition in the backend. I deployed the application on the network using caspol but it is extremely slow. The Company Manager's perception is that because a script will invariably have to be deployed on each client machine to configure CASPOL, that the solution is not viable.
What is the best method to develop and deploy a multi-user desktop application?
View 9 Replies
Jan 22, 2010
So. I'm making a tool for an online game called Shin Megami Tensei.In this game you can fuse Demons, depending on what family of the first demon you fuse and the second demon you fuse come from, and their levels, the outcome changes.This is unimportant though.
However, the application is driven by a database, the application consists of a Demonic Compendium (Index of the demons, including race, family, stats, levels etc.).This application is meant for usage by the community playing SMT, and here is the problem; a person without Microsoft SQL Server cannot run this application.I can't ask the community, some of which aren't very techy, to install Microsoft SQL Server 2005 Express Edition just in order to run this program.
You see my problem?Is there a way to get the program running on other computers that doesn't have MS SQL Server installed?
View 5 Replies
Jun 24, 2010
I am trying to have letter templates (word documents) that are stored in sql server VarBinary(max) to be accessed via a web application where they will be edited and saved back to sql server by directors of our company. Then various managers will be able to select an existing template (word document), make any additions, and mail merge with a list of customers to print or save the letters.
I am looking to open up word within a web page much like you would an email in outlook, edit it with spell check and the like, and then save it back in sql server. I am able to get word to open from a file but it is outside of the web application in a separate word document. I am storing the word document in sql server but am unable to open it in word without having to save it to a disk (why should you have to go to a disk for viewing or editing?). I am able to programmatically mail merge but that is in a separate word application.
I am finding bits and pieces on the web but nothing that will pull things together such as embedding word but in a windows app not a web app. Mail merge from a file not from a database, converting a byte array to word in a directory but not on a web page.
View 1 Replies
Nov 27, 2011
I want to create a very simple (to begin with) database driven application. The company I work for have very kindly said they will host any SQL database I create, they have a remote server that we all connect to for files etc.
So I want to be able to create an SQL database that they can host and have my colleagues and I install the application local on our machines.
[Code]...
View 6 Replies
Dec 14, 2010
i'm developing a linq to sql database application that i created with visual basic 2008. I intend to install the application on another computer system. The problem i'm having now is that, after i've developed,deployed it and installed it on another computer, i can't find the linq to sql database i created with the projectkelvin rolex on the installed application on the other computer,
View 3 Replies
Sep 30, 2011
I have develop a wiindows application and it's done in MS Visual Studio 2008 using the VB language and it connect to a 2005 sql database. now i want to deploy my application and want it to be directly attached to my database so that when someone installs it, it comes directly with the database attached to it.
View 1 Replies
Apr 5, 2012
how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?
View 5 Replies
Jun 26, 2011
Using: VB 2008 Express?I created an application that connects to my MySQL, and everything works fine, but...
1. On my development computer, Windows 7, 64bit, I add the MySQL.data.dll file as a reference. I publish the program, run the setup.exe, and sucess.
2. I then copy my published folder to my test computer, Windows Vista 32 bit, and upon running the setup, the program fails to work because it cannot find the Mysql reference.
3. I then transfer my entire project over to my Vista computer, publish the program, run the setup.exe, and sucess.
4. I finally found out what was happening. My Windows 7 comptuer was not including MySql.Data.dll.deploy file in the Application Files published directory; but when I compiled it on the Vista machine this MySql.Data.dll.deploy was included.
So, in the end, I cannot compile the program on Windows 7, because it fails to create the .deploy file, and use it on Vista or XP (for some reason Win7 doesn't need this .deploy file?); but I can publish it on the Vista machine and install it fine on Windows 7, Vista, or XP. My targe CPU setting is Any computer.
View 3 Replies
Apr 11, 2009
How do I publish/deploy the WinForms application including a database file via ClickOnce?
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback,
View 1 Replies
Apr 8, 2009
I am trying to deploy my first application using vb. I have tried to use the one click but here is my problem.
I have a group of data files, some *.txt and one access data base (*.dbf) that I need to have placed in a folder (that is created) located at c:monitor.
how to do it in either the one-click or in a setup project.
I would also like to have a condition that if the files exist that they are not overwritten with an updated installation.
View 2 Replies
Jan 21, 2009
What is a event driven application.
View 2 Replies
Mar 22, 2012
The main purpose of the my app that I need your help with is, to deliver an always (or close to) up to date a list of files for the user to choose from for a variety of common purposes. For instance, opening the selected file in its native client editor application so the user can make changes. Another purposes would be to print the file, and I have others.
If nothing else (meaning recommendations for a better design that still keep my desired in mind) I'd like ideas on how to update my complex DataSet (background processing options, what's the most efficeient/quickest way to update my DataSet) as the list of files changes while my app is running and my app is designed to never close due to the long amount of time it take to load it initially.
The list must be always kept up to date while my app is running because not only the intial loading of data takes a lot of time but updates (new/modified/deleted) could potentially take too long depending on not only how much data to update/add (new files) but how efficeient my code is in updating the list. To be perfectly clear: If a new file is created then it need to be somehow (automatically preferably or manually i.e. button code) add to the list. If a file is deleted then it needs to bet removed from the list. And if the file has changed, perhaps some of it metadata or thumbnail image have changes so update the file's data in the list. All of which (new/modified/deleted) need to be as real-time as possble without degrading the server too much and without the user waiting more than a handful of seconds.
Listing all the files as quick as possible whether that be with or without metadata initially is very important because most of the time the user is going to filter (or scroll the list by typing) for a partial file name. Once the user filters/scrolls to the desired file there's a very good chance that he/she isn't even interested in the metadata, most of the time the user wants my app to open the selected file in its native client editor application so he/she can view or modify the file. The initial
load time of the data doesn't concern me as much as updates because the user can possibly do other things while it initially loads all the data as long as it not too long (more than a few minutes). From there the updates will either be automatic if possible (most desirable from a users standpoint) or the user initiated (e.g. button). Plus I'm thinking the updates might need to be done with a few different background processes (multiple threads) because I think I need one for periodic updates (e.g. every
15 minutes) and one background process for page updates meaning whatever the user has either scrolled to or filtered for, more accurately all files currently display to the user will be systematically update in the background so the user can still operate my app.
I'm currently using SqlDataAdapter.Fill to fill a DataSet object variable (which is bound [BindingSource] to a DataGridview control) to first populate the DataSet from the SQL query and then prorgammatically adds records (DataRow) for local files but please make recommendations. I don't mind big changes or starting over if necessary, I just want the best app possible based on the aforementioned criteria. I'm not sure if it complicates matters but I've also added custom columns in the DataSet for some special needs (thumbnail of files, booleans for tracking custom statuses). For the local files I'm currently populating the DataSet prorammatically (iterating a path/file string collect made by System.IO.Directory.GetFiles) since the list is first (and very quickly) populated with Vault files (which is always a far larger list than the local files) so . Again, I don't have to take this direction, make recommendations.
View 11 Replies
Feb 25, 2011
i have a simple phone which supports GPS (to be more specific is HTC HD windows mobile) my main scope is to develop a desktop application which i can set up a connection between the phone and the desktop application to read some coordinates of the receiving gps data and display them to a simple textbox or msgbox. the only way to connect the phone to a pc is via USB port. can i do that? i have check on the internet but all they are referring to a non build in phone gps, but to an individual GPS devices only.
View 10 Replies
May 20, 2012
i would like to build an inventory manager application that would have two versions :1. Would run on the desktop 2. Would run on windows mobile 6 I would like to have both these versions store and read data from a database that can be stored centrally either on a webserver or somewhere on the LAN.
I would like to know can i use Access as my backend database or sql server ? will windows mobile app be able to access it and read and write to it Note : I would prefer to create only one database that will just store the details in the tables and do not need any other functionality. All functions such as save,edit,delete,search,filter etc with be done from the FRONT-END VB.NET interface ONLY If you suggestion involves the use of 2 databases such as one for desktop version and one for windows mobile then please also tell me how would i sync the data between them.
View 1 Replies
May 31, 2010
I am here to write a small database application that will be running in desktop (offline mode).I am using MSAccess 2007 as my database file and trying to write code in vb.net.I used to write the code vb6 an usually had global variables for storing database connection and executing every query from that.I am trying to upgrade myself from vb6 to vb.net.do i need to read some more simple starter books also?
View 3 Replies
May 26, 2010
I am writing a desktop database application. I want my application to use SQL database.
View 1 Replies
Dec 13, 2009
This website "[url]..." contains currency exchange rate, and it's useful to my desktop application " bill system " .the question is: How to get data from this website to my desktop application textboxes ?
View 4 Replies
Nov 24, 2010
I am developing a new application for Students Training. how the database design should be? And could you provide a sample application similar to my requirement? Following is the requirement of the Application, The objectives of the program or application are:
Get Information about the total number of students trained in all company's department
Get Information about the total number of students who were either withdrew/ apologized /rejected
Anticipate of the future needs for student's work placement opportunities (numbers of students as well as the majors)
On light of the objectives mentioned above I consider the following data for the application preparation: Company's Department Needs Department Major Number of students for each major Supervisor Mobile Number
If it is possible when entering students details the program will automatically register him/her in the Department that has vacant place and already fit the requirements of the certain department-Internship Information.
View 11 Replies
Nov 15, 2009
I'm trying to construct a database driven VB.Net app that pulls a list of registered accounts from a database and displays the usernames of throes accounts in menu, so the user can select one and a new form open (where they work with it).what I have so far is the constructor for the MDI parent window.[code]What I want to happen is when a user clicks on the context menu a new MDI child form is created and the data in user is passed, however because AddressOf doesn't like passing data this doesn't work.I've looked at delegates and landa expressions but don't think either of them do what I need, the other option is to make my own subclass of the ContextMenuStrip class, which 1) handles the clicks the way I want to and 2) sounds like a nightmare.Before I launch into what I think will be a hell of a lot of work, am I missing something? is their a simple way to do what I want to do? or if not will sub-classing ContextMenuStrip work and if not any ideas as to what will (and if it will, any ideas as to how to start learning how to do that)
View 1 Replies
May 18, 2012
i try using both detail view and form view but they are not flexible enough to place my picture where i want it
View 1 Replies
Jul 20, 2011
I can articulate my question well enough to get some clear and usable feedback here. I have reports (like paper reports) in my .NET application that have data bound to them. Typically the reports are a combination of many data elements across several busniess entites that may not all relate through an Inheritance hierarcy, etc. This makes it difficult to get all the needed data placed together to bind to the report.
So what I have done before are make 'Report' classes with data elements specific to supporting the reports they are bound to, and on the back end might be tied to specially created Stored Procedures that bring this data back (maybe several joins across many tables to get the right data needed). So if I was to make an analogy to the database world, I am essentially 'denormailizing' the data structure to get all of this data into a single class to make it easy to bind to the report.
However on the hard line OOP concepts and architecture design, one could say that a report is just another 'thing' to bind data to, and its class should not be designed just to suit the needs of data binding. In this thought process, I would actually need to make my class design be able to create the relationships needed to get all of the data together properly to still be bound, but not create any special 'Report' classes. I find this difficult to do sometimes. It is much easier to create these relationships in the back end stored procedures and then just output the resultset to be almost immediately bound to the report.
So what is the right way to solve this? If I create these specialized report classes with really no behavior, am I introducing an anti-pattern like the Anemic Domain Model?I could use some feedback, and please speak up if my question and scenarios did not make sense.
View 1 Replies
Nov 6, 2011
There exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.
View 1 Replies
Oct 21, 2009
I recently came across a problem for image file storage in network.I have developed a desktop application. It runs in network. It has central database system. Users log in from their own computer in the network and do their job.Till now the database actions are going fine no problem. Users shares data from same database server.
View 7 Replies
Aug 5, 2010
I recently came across a problem for image file storage in network.I have developed a desktop application. It runs in network. It has central database system. Users log in from their own computer in the network and do their job.Till now the database actions are going fine no problem. Users shares data from same database server.
View 3 Replies
Jul 20, 2008
Dont understand where to start on visual basic iv been leaning alot about computers over the months and i would now like to design a program and to be honest its all new and i dont no where to start or what any of these woulds mean like string, data enadled application and refactoring.
View 3 Replies
Feb 17, 2010
I am trying to build a dynamic validator for a data entry application. I want to be able to query a table for the validators relating to the current task and then be able to reference class properties based on the description of the validators returned.
ex. Validator = "person/firstname"
How do I get to _clsPerson.FirstName?
View 2 Replies
May 12, 2009
I am using VS2008 Pro. I have a simple DVD database built. I'm trying to make a data driven app to store my dvd collection.One of my tables is Actors and is structured as follows.[code]On a form in my app I have a combobox. I'm trying to make it list FirstName LastName ie. Will Smith. I know how to make a query that'll take the LastName and FirstName fields and list it as Actor. I'm having a heck of a time getting it to do that in the combobox as it'll only let me use one field for the display and won't let me use the query I've made.[code]I keep getting some error about schema don't match default query. I know I could simply change the table to only have one field that holds first and last name, but from what I understand that's not proper db practice. I've searched this site and google until I was blue in the face at looking at soulutions that don't match what I'm trying to do.
View 3 Replies
