User Data - SQLCE Files - One Database With Multiple User On PC
Mar 3, 2010
I'm designing a PC-based app that has a little local database. I'm using VB.NET with SQL Server Compact Edition. The user will only ever have access to one database file, because it's all about storing a user specific data. However I'm thinking of the situation where there could be multiple users that access the PC, each with their own Windows account. So ideally I'd need separate database files for each User.
I'm not sure how to implement this. I was hoping to deploy the 'empty' database as a ClickOnce deployment, but I can't see how I can have a database per user doing this. Also I'm not sure where to store the database files anyway. perhaps in MyDocuments for each user? Or perhaps I need to stick to just one database, but add a 'User' column into every table, so it can hold data for every user. I didn't want to do this though - because I wanted to keep the nice separation between the data offered by physically separate files.
View 3 Replies
ADVERTISEMENT
Jun 3, 2011
Here is my current code, and it works fine to choose one image and copy it, however, I cannot figure out how to allow multiple file selections then copy them to a new folder.
Imports System.IO
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strFileName As String
[code].....
View 3 Replies
May 26, 2012
I am needing to allow the user to choose a directory to save in. They can create a new directory if they want/need, and once they choose the directory, my program will save a few pre-coded files into that directory.
View 1 Replies
Aug 24, 2009
I am a beginner so please be patient. I am trying to solve problems with existing code. We have a tree view where user may check off multiple files (tif,pdf, doc etc) for printing.When the print buttton is clicked each document should be printed. Each document must be printed in full before the next one starts. The docs are not printing in full or in order. I have attached the code for review.
Private Sub RecurseNodes(ByVal col As TreeNodeCollection)
For Each tn As TreeNode In col
If tn.Tag = "FILE" And tn.Checked Then
[code].....
View 3 Replies
Sep 14, 2009
I have used Access databases before so thought I'd try something different. My problem is that when I try to add a new record to one of the tables in the databasethe code runs through fine, but the data is not added into the table :S have probably missed something simple, but it's been a while since I did any projects using a database.Here's my code:
Imports System.Data.SqlServerCe
Public Class Form1
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:UsersMattDocumentsVisual
[code].....
View 15 Replies
Jun 13, 2010
How can I do it so every time the user loads my application it will automatically (without prompt, or user selecting) upload all the files in a folder i select beforehand and add them into ListBox1
View 16 Replies
May 8, 2009
Not sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.
View 1 Replies
Apr 6, 2009
I'm about to pull my hair out on this guys I do not know where I'm going wrong but basically I receive a web request response formatted in XML and I need to insert that data into an SQLCE database. I have tried using LINQ queries but there are no matching ID fields to Join or Group.
View 3 Replies
Sep 25, 2009
writing user info such as user, computer name, date, and time to an acces database using a button click event. Then use a query to check if the user has accepted the aggreement. If the user has accepted the aggreement then call a vb.exe that display the aggrement. I have a login script that runs the vb.exe and uses a button click that records the user info to a csv file, but if the user has already agreed to the policies I do not want it run again.
View 4 Replies
Feb 28, 2009
On a word document I would like to populate same data captured via User Form on multiple locations of a document... i.e. LastName I would like to appear on salutation paragraph and also in the body of the letter... I used REF LastName on the document when using VBA but it seems the same document when it is being populated via a VB application this skim does not work and instead "Error! Reference source not found." appears where ever the REF LastName has been used..
View 3 Replies
Aug 26, 2009
I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").
I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?
I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?
View 6 Replies
Mar 11, 2010
I need something tje user can type in data to such a parts QTY cost etc. There are no predefined parts list so the user can enter any part name/Number and there is no limit to amount of parts that can be entered.
Does anyone have any idea what might be useful. It was thinks of a listview bu i can't see that you can type into that. I cant use comboboxs because there are no predefined list and i know there is some way to generate text at runtime (i think) but i don't know how to do it and i would prefer a clearer approach.
View 3 Replies
Mar 3, 2012
I'm just getting started with Visual Studio (2005), and my aim is to write a fairly simple application in Visual Basic that will need to store some data to disk.What I really want is to be able to send the application to the end users (xp, vista, win7) and have them just be able to use it without having down download all kinds of extras. For example I'm guessing that if I use an SQL database in my application they will need to download SQl server express or some other sql downloadable?
If so is there a similar downloadable for MS Access?I'm just in the 'seeing how things work' stage at the moment and I don't want to waste time going down the SQL track just to find it won't actually work unless my users all download SQL to their machines (which they won't want to do).
View 4 Replies
Jun 30, 2010
I am trying to write codes for new user to fill in the form, then the new data will add into my database.
Below are my codes:
Imports System.Data.OleDb
Public Class NewUser
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
[Code] .....
There is no error encountered, however, the adding is failed and no new data can be add in.
View 3 Replies
Mar 12, 2010
I want to do a user interface for capturing data into a budget database but ran into a problem. Budget items are captured one line at a time. For example, say a Company wants to prepare budget for 2010, the entry may look like this;
[Code]...
View 5 Replies
Oct 23, 2010
How can I catch error if the data that user select not in database?
This is my code.[code...]
View 5 Replies
Apr 17, 2011
I have a form with 5 fields(inputs). When I entered data in the form and click submit, the data is entered into an Access 2007 Database(Table). All the set up (connection) is working because the data table is getting populated with the user info. However, I also need to search the database by entering a name in the name text box and clicking a button.
This is suppose to populated all the fields with information from the data base if the user exist. The search part is not working. I have no more hair to pull. :) Here is the code:
[Code]...
View 1 Replies
Apr 19, 2012
I'm displaying data from a database in a datagridview, but the player also needs to be able to add new rows, which isn't allowed because the datagridview is data-bound. What is the simplest workaround to this problem?
View 10 Replies
May 5, 2011
I am trying to essentially allow the user to merge data from a database onto a document and print it. I am new to working with the PrintDocument, but I believe this would be the way to accomplish this. I know how to print the text onto the PrintDocument at a certain position, but what I am trying to figure out is how to deal with the coordinates of the text I am drawing on the PrintDocument. Ideally, I would love to click on the PrintDocument in a PrintPreviewControl and capture the coordinates of the PrintDocument.
View 9 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 10 Replies
Jan 28, 2010
I'm developing a standslone system for my school project. I'm developing an audio management system which allow user to add audio files itself into database together with the audio information such as artist name and album year. I just started it few days ago and face some problems.. my song in the playlist wont continue to play after 1 finished and i need some idea on how to store the audio files into database ... in blob types may be?
Heres the screenshot and codes
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_add.Click
[CODE]............................
View 2 Replies
Dec 15, 2011
My application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data
my vb.net code is as follow:
Imports System.Data
Imports System.Data.SqlClient
Public Class XtraForm1
[CODE]............
I m also pasting the demo picture.
View 2 Replies
Sep 15, 2009
I am trying to add a new record to a table, well first it checks if there is already a duplicate record in the table, and if not it makes one. If there is a duplicate, it tells the user.[code]
View 2 Replies
Nov 20, 2010
I have a SQL CE database (SDF) that I tried to edit with Database.net v3, but it is now not opening in Visual Basic Express 2010.[code]I've installed SQL Server Compact 4.0 ENU CTP1, but it is still not working.Is there any way to revert the version back? Or anything else I can do to fix this error?
View 4 Replies
Apr 5, 2011
I created a program that allows my users to upload files to an FTP server and make folders. I have one problem. they cant delete the files yet. [url] you want to see the Upload page just enter random credentials). I was wondering if someone can help me make another form that displays files and folders and subfolders, maybe a listbox and when a user highlights something and clicks the delete button it will delete it or the rename button.
View 12 Replies
Dec 19, 2009
I've got an application in VB 2008 with, 1 richtextbox, 1 toolstrip and 1 menustrip. My toolstrip has many buttons, 5 of these being a: bold button, italic button, underline button, strikeout button and a regular button. However it is only possible to have ONE fontstyle at a time. If you want Bold AND Italic, it is impossible.
[Code]
Make it so that the user can have more than one fontstyle at a time. Make it so that the user can click the button again to remove that fontstyle instead of clicking the "regular button".
View 4 Replies
Jun 22, 2010
i am developing a small windows application in vb.net using visual studio 2005.i want to design a form where user can enter multiple records.like we want to design a "bill" form where user can create the bill for any no of items.there are 4 colmns in it : item no , item name , quantity , price.
my requirement is that if user user a particular item from the list of item in first column then the column "item name" get filled automatically from the database. then user can enter qty , price for that item.on clicking a save button all the data entred by user should get saved in a table in SQL database.
now user can create bill for 1,2 or more items. so no of rows are variable.
HOW could i achieve this using vb.net and SQL server 2005 as databse.
View 2 Replies
Jan 5, 2012
I'm working on a client using instant messages. I don't want the same user popping up multiple forms (IM's).Need 1 user in it's own form, and a new user to popup a seperate form.
Public Function createIMWindow(ByVal strUser As String, ByVal strMsg As String)
If frm_IM.txtWho.Text = strUser Then
Dim myFont As New Font("Arial", 10, FontStyle.Regular, GraphicsUnit.Point)
frm_IM.Text = strUser & " - Instant Message"
frm_IM.RichTextBox1.SelectionStart = Len(frm_IM.RichTextBox1.Text)
[Code]...
View 3 Replies
Oct 15, 2011
I need to rename/move a file to a different folder after downloading. When I log into the customer's FTP site via the url, user, password it put in into a particular folder. I can download these files using the URI but I cannot Rename (Move) into a different folder (i.e. DONE). I get a The remote server returned an error: (550) File unavailable (e.g., file not found, no access using the FTP Class and FTPClient. [url]...
View 1 Replies
