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 RepliesWith 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
i am doing project of Order Accepting system for five star hotels.Scenario is Waiter will accept order using Window Mobile which is Connected to WiFi present in hotel.I want to communicate to database(Sql Server) present on My Machine (Computer present in kitchen) through WiFi and Add order into table present inside database. This should notify my application present on Compter and should print order. After completion of Order Application from kitchen will notify to waiter about completion. My problem is How to Communicate with database present on Remote computer using WiFi from windows Mobile.
View 2 RepliesI have done alot of work over the years designing MS Access DB's, but its getting to be problematic with end users needing to have access installed to use them. also if the MDB files have OLE's the file can get very large. I tryed using FoxPro years back and it sort of worked as long as we didnt use OLE's but I'm behind the times with that also. I'm currently not sure where to start, I have decided on a beginner style Dtabase project but need to know some things and then will need some help. Heres my requirements.A single Form, with multiple textboxes, about 6. i will list the names and such in a moment, it would be nice to have search, and images, some buttons too. I basically want to use the layout I use right now in Access but I want to code it from scratch.
Now I need to know what is the better way of going about this, Do I use a MDB Access file and go ahead and setup a table with all my fields, or Do I need to use SQL? Just a note I have never used SQL. Now I need to be able to save my SQL/MDB file for backup purposes.One of the problems with this DB is that while a user is keying in parts, if they run into a new manufacturer, they have to close the Data Entry form, open the manufacturer table and add them manuall then return to the data entry form. its slow and can cause issues . When I messed with VB DB's before I never could get the crystal reports thing to work at all. now I would like to add a textbox/field for picture, it will only host the image location eg. c:DBimages image01. jpg..You Know Your Addicted To Computers When - Your main computer is a 7 terabyte, Core2Quad 3 Ghz +, with 4 or more gigs ram, over 200 programs installed, and you would rather sit with it programming than go to the movies!I've got 13 PC's in the House and 7 are in my bedroom and my main one exceeds this set of stats.
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.
I've been trying to connect a MS database to a V.B. form unsucessfully.Actually when i try to do that, i can't connect the tables information to the form or store the information i enter in the form in the MS table.I was doing an exercise here, and to store the information in the table called readers, i typed:
View 1 RepliesI 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 RepliesI am about to finish an application for a client. Now I'm having hard time deploying it since I really don't know how to do it.How do I deploy a windows form application with database?I've already downloaded the prerequisites redistributables. I also want those to be included in the installer.
View 1 RepliesI'm Using Visual Studio 2005 and Mysql Database to create a windows application. The datagrid displays all the records. Since I don't know how to directly update from datagrid, thats why I have used textboxes for the respective datagrid fields. A load button is provided which on clicking puts the data on the respective textboxes. The data can be edited in the textbox. Problem is that I can't save this edited or modified data back into dattabase.
[Code]...
I want to use windows authentication in my vb.net application rather than validating against Database. Is there any possiblitiies or APIs that allows me to use Windows authentication? I have user id and passoword text boxes. Once user entered the userid and password, it should validate again Windows authentication.
View 1 RepliesWindows form application Access database Is it best practice to restrict user entry via keypress event
then validate all info entered & show error control message
or use dataset partial class columnchange as cannot restrict user entry here Could an experienced programmer suggest best way i actually prefer restricting keypress then loop through and validate all entrys
but want to be right
i have written this code to inser data in my database table "member "through the form but it is not working if i start debugging the code it gives no error but when i open my database table to see the inserted data it is not working.
Imports System.Data.SqlClient
Public Class Form3
Dim con As New SqlConnection("Data
[code].....
Do users of windows applications have to have the database application installed if your program uses databases to store information? For example, when making VB2008 programs, if I use the visual studio express database (.sdf), or maybe a MSAccess database, to store information within my visual basic program...when I deploy the application to the users, can they run the program okay even if they don't have MSAccess installed on their computer?Also, do I need to have MSAccess installed in order to write programs that use MSAccess databases?
View 1 RepliesThe problem has been simplified for the purpose of clarity. I want to make a windows form application that uses an access database. The application will store the list of person's basic details such as name, age and country. The database contains two related tables ie person(id, name, age, country_id) and country(id, country_name) My windows form contains TextBox, DateTimePicker, ComboBox for Name, Age and Country respectively. Now I want to make CRUD operation Programmatically (Not using Visual tools) in the same form with some navigation buttons.
View 1 RepliesI 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.
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 RepliesI am a SQL Server Developer and DBA. I have some experience in VB.Net (Windows Application) programming. I used to use .config to setup database user and password. I have a windows application running on my computer. I would like to check which username and password is used to connect to SQL Server Database.
[Code]...
how to open password protected MS Access database using vb.net windows application?
View 2 RepliesThe application sits on a virtual environment and when I remote in and run the application, it connects to the remote database. However, when I remote in with a service account and double click the same .exe, it tries to connect to the local host database and ignores the app.config. The code is the same, only the login name I use is different. The login I use is part of the local admin group. Any ideas?
View 2 RepliesI have created an windows application which stores it data in a database. What I would like to know is how do I access the tables in the dataqbase and transfer the data in them into textboxes on the forms in my application. I can connect to the database and view the tables, but I have'nt got any idea how to get the data from the fields in the tables into the appropriate textboes on the application forms.
View 2 Replieshow to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 RepliesIam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
Is it possible to use microsoft access database for Windows mobile application and save this mdb file locally in the pocket pc?because im trying to make an application to connect to mdb database but this imports seems to be not working.
HTML
Imports System.Data.oledb
oledb is not a member of system.data. why?
I'm trying to get my application to restore the default values of my application settings but every time I click the Synchronize button it says:
No user.config files were found in any of the following locations.
I have never before tried to synchronize this application and am working with Visual Studio 2010. [URL].
I sometimes come across patterns or common practices that I do not agree with. I have a clear opinon of what is considered "good design", which is mainly based on my understanding of abstraction and creating layers.IMO, the core of an application is it's object model. It's a hierarchic model where one object references other objects or lists of them. That's a memory-internal model. For example, a house object references a list of rooms referencing lists of furniture.An object is identified by it's reference. There are no IDs or PKs in that layer.Saving/Loading data is an additional feature. Sure, no application will do without, but it's based on top of the core of the application. I could write an application that works very well without loading/saving, and for version 2 I will think about whether to save data to a database or an XML file. Merely this fact proves that a database layer is not the lowest. I've never agreed with that three-tier model - even if you call me unteachable.
In addition to all application objects, there are Datasets - and that's my problem now. They can be considered as a copy of what is already present in the application's object model. Its from a different, table-oriented view. As both structures exist in parallel, there's the need to synchronize the DataSet with the (rest of the) application's objects.That's the task that I am always struggling with, and I ask how you handle it. I know this is a major design question but, fortunatelly, I could quite get around this problem so far.The only solution I can imagine is maintaining additional relation lists. For example, whenever the property of a room object changes, that change must be reflected in the associated DataRow in the DataSet. For this purpose, I need a look-up table that tells me the PK of the given room in the database. It requires a lot of additional efforst to do all the synchronization.Again, the house or room object itself does not have a PK and it won't get one because on that layer, it doesn't even know that a database exists.
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 RepliesWhen 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]
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]....
I've got an XML file which is a pain to manually update. So I was thinking of creating a small app which synchronizes this data for me based on data from an Excel Sheet or something.
The XML schema looks like this:
<Data>
<Level1 value="Canada">
</Level1>
<Level1 value="Chile">
[code]....
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?