Data Storage Methods (access/sql Etc) Require The End User To Download Extra Files?
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).
I'm concatenating data files, but the problem is that I'm seeing some extra bytes where the files are joined. The new file has extra bytes. I had thought this was maybe a problem with encoding.Here are the methods that I've tried to use to concatenate the files. The first example I'm getting extra 0xA0 0x00 bytes.
Dim inputfiles() As String = Directory.GetFiles(sourcedir, pattern) Dim bufSize As Integer = 1024 * 64 Dim buf As Byte() = New Byte(bufSize) {}
I am quite green to VB .NET and it start occuring to me that I am doing things probably in a very ineffective way.Anyway here is the problem I have datasets, consisting of integers there is set 1 which is of format ID, ID2 - ID here is unique but different ID can refer to same ID2. Before I start reading in the data I have unknown number of these entries (ID and ID2 can be at least as high as 99999999)
Then I have a second data set of format ID2 here is the same as in the set 1 and it can contain several PID entries (all integers). In this set the ID2 is unique and again for one ID2 there can be unknown amount of these PIDs, same PID can occur more than once.
I found a way to use VB.Net to get the default audio device in Windows 7 through downloading something extra - in this case, NAudio - but I'm now having to research whether this can be done through nothing more than run-of-the-mill Visual Studio .Net stuff, with no extra downloads, externally-done system configurations, or anything else whatsoever. Is this possible? My current research suggests that it basically isn't.
I'm using interop.msxml2.dll to open XML and txt files off an Internet server. The response that is received from the server is stored in my application's variables. I've recently noticed that the application doesn't always update the information when it goes to download a file that it has already downloaded in the past. For example, if it downloaded a file off the server when it started up, then when it attempted to download the new, changed file 5 minutes later, it would still return the same value as the first one. Even after closing the application, it would still return the incorrect, older value. How to stop this "caching" of data, and only allow the program to download the latest file off the server.
For my user system, I require each user to have a unique id. The reading in and saving of the user data is all done, but now I'm focusing on adding new users. In my add user dialog, I have the information fields required to create a new user, one of which is the ID (which must be unique). For this I have created a function that I thought would always give a unique id but it does not. paste the code below:
Function getnextuserid() Dim id As String Dim unique As Boolean
I am using a MySQL Server on the net and a Windows Forms client program, which connects to this server.
I want to use SSL and have prepared everything, that this can be used. My primary question now is as follows:Where / how to store the files for the SSL certificate as best way? As embedded resource? as external file? As part of the My.Settings environment?
Then while the box pop up I click No button, the program should exit sub but actually it is not. The code looks stick somewhere else. hat I found is that PHP
If I wrote some software that used an access database to store data. If I then gave the code to a third party, who ran this sofware on his Pc. Would the code work , if his Pc did not have the access database installed.I read in some article that this would still work? If this is true, how could this work? If the above software had an form which required the client to input details of an order. When the order details were being processed by the code where would it store them if no access database was installed on that pc.
how I can deploy my .NET applicationwithout the user having to install the program.i.e. In VB6, I could just create a executable file which did not require the user to install anything, they would simple run the program.
My application (vb.net) sometimes throws an "access denied" exception when attempting to delete files in the AppData folder and I'm not sure why.I confirm that the file exists before attempting to delete it and have not done anything to make it readonly, etcThe interesting thing is that it seems to go okay when I'm logged in with Admin rights
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.
I made a little program for Hobby-use, and I like it to be installed by an installer. There's an installer program (Windows Installer 3.1?) deliverd with Visual Studio 2008 but that does not do the job completely. I want a coupling to be made between a program and a the users startup directory.If Windows Installer 3.1 can do that after all, can somebody explain how? If not, is there a free or low cost, simple to use (no scripting) installer program what will do the job? At last: Is there a version of .NET Framework 3.5 that does not require downloading during the user's setup procedure?
I am looking for some API or OCX or any other method to copy the existing file from Hard disk to the USB storage device.for that i would have to perform the following checks :
1> Check for the plugged in USB devices.
2> Find out for the available space(2GB) on each.
3> Prompting a message to user on which drive he would like to write that movie file.(As At a time i want to give only 1 disk write only.
4> after selecting the Drive, and pressing OK, i just want to copy the selected file from HDD to that Device.
Now For achieving this , i just need a reference of any Available API or OCX or any other method available in VB.net?
how to read files from an USB mass storage device. I have found plenty of posts regarding drive letter detecting and reading the files. It's OK, but what about a device, where no drive letter is assigned - e.g. my mobile phone is visible under "My Computer" as "Mobile Device". The same situation it with my MP3 player. It's visible under "My Computer" as "Sansa device". Please, could anybody help me? I need to enumerate USB devices, identify, which ones have a file system and finally, I need to read/write a file to the file system.
I have a little problem with finding a file I stored in an isolated storage on my pc harddisk.The application stores a Hashtable ( Called example ) in an isolated storage like this:[code]
how could we download a pdf file and import the tabular data into access 2007 database, i have tried and got successful in downloading the pdf file from an URL, but not able to import the table data into access 2007 database/or may be an excel file through a VB6 program.
I have a system that detects USB mass storage devices. I have a "list of items" listbox (ListBox3) and a list of USB's (Listbox4) When Button4 is pressed it will transfer all files in listbox3 onto the mass storage device selected in listbox4
I'm looking into adding some unit tests for some classes in my data access layer and I'm looking at an update routine that has no return value.It simply updates a row based on the id you provide at whichever column name you provide.Inside of this method, we collect the parameters and pass them to a helper routine which calls the stored procedure to update the table.Is there a recommended approach for how to do unit testing in such a scenario?
I have an ASP.NET site in a web server and the images are stored in NAS (some kind of lacie external storage), I tried UNC and other things but no success.how can I access images from external storage in ASP.NET
Update: The images are reachable from the server but when I try to access in ASP.NET throws me error.
So my program works off a few templates in a folder called "Templates".So far, i have been deploying my program as though it would run from a CD. Deleting the autorun file, inserting the Templates folder myself, and then using a self extracting ZIP to make it easy for the user to install.While this works, i would like to make it easier on myself by just including the Templates folder and the two template files (both .xls files) in the program every time i deploy.I've tried dragging and dropping the folder + files into my solution explorer bin folder but it doesn't work.I'm using Visual Basic 2010 Express.
I've been developing in .NET (VB, C++, C#) for a number of years, but I am finally creating my first service application (in VB). I need to read/write to a file contained within a user's documents. As a service is not associated with a particular user, would a service have access to a user's documents? ...regardless if that user is signed on or not?
I have a client who wants his custom-written CRM to be able to access his sales people's emails so that, effectively, a history of email conversations between customer and salesperson is stored inside the CRM's database.
The CRM is written in VB 2008 and the database is SQL Server 2008. The only email these people use, in the shop and on the road, is GMAIL. Each sales person has their own GMAIL address. Thats how they operate.
If they're on the road and respond to a customer's email inquiry about a product, they would like that email conversation to be stored in a table in the database. I think thats the part I cant wrap my head around. How to get access to the email data (knowing the user id and password) and doing so from VB 2008
Update: A free or close to free solution would be preferred.
I created a simple BMI calculator through the guide.I have built it and published it on my laptop running Vista Home Premium with .net 3.5 SP1 installed.I can run the setup and subsequent exe file fine on my machine but when I try it on my girlfriends netbook (one of those fiddly little things) it wont install saying that some of the files are missing. It is running XP and also has .net 3.5 SP1 on it.There are only 2 extra files in addidtion to the setup.exe that vb 2008 creates and they are the application manifest and the program icon, both of which are located with the setup.exe but it still won't install. It is an offline installation but won't run.I copied the bin folder from the project to the setup folder and tried that, still no joy, yet if I try and run the actual program directly it works?
When my program is installed, I need to place a folder in the directory path of "C:\" in order my program to work. How do I include the folder in my project, and then durning the install Place the folder where it needs to be? Could someone be so kind as to point me in right direction to read up on something like this?
