I'm developing an application that will take the data from a cd. This cd stores a .csv file. Can VB read this data from the disc and upload it to a database? Im not sure exactly where to start looking. Can someone point me in the right direction, as to what compnents i should be looking at.
View 9 Repliesi have an app that allows a user to upload a file to a database. then, in the background, i want to move the file to a different folder.i am trying to use a background worker to do the file move but i always run into this error: the process cannot access the file because it is being used by another process.so i'm guessing it is still doing the file read/upload to the database (it works fine for really small files)how can i do the move once the upload is complete?i tried putting the actual upload piece in a background worker but it gives me an error saying the filename can't be null even though i check it and it isn't null.
View 4 Repliesi write a program using vb 2005. This program collects data from Flight Simulator 2004 (altitude, speed, etc). These data should be uploaded periodically (every 10 secs) to a database which is installed to my website. The problem is that my hosting provider doesn't allow remote access to the database. Is there any way to put that data into the database?
ps. The strange with all the above is that i run a shareware program that can upload data collected from the flight to my database by simply adding the database name, user ir and password.
is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database ?
Update (1)
i want to write in a memo field and store it using identifiers like sessions and time stamps for example writing a memo with the session "subject" and session "dateANDtime" to be stored as "mysubject-12/12/2010-11:56pm.rtf"
how to retrieve the file. can i build hyperlink programmatically?
I'm only getting started with VB.Net, using VB Express 2008.Using the System.Data.SQLite wrapper, I need to read data off a SQLite database file, and chart data using basic bars, pies, lines, etc. Nothing fancy.
View 1 RepliesI am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the button is clicked, it does frmProcess(). The first row is header in excel. I start to read data from 2nd row.
----------------------------------
Private Sub frmProcess()
Dim app As New Application()
Dim book As Workbook
[code]....
I have data that was stored in a sql 2008 table in image format. I want read the data from sql with VB.net 2005 and put it into a character array or a byte array where I can access the data within the code. I can not use file stream to read the data because I have no ability to read files from a directory.
View 1 Repliesso i just bought a years web hosting with godaddy, and apparently i have one ms SQL 2008 database, is this compatible with VB ? and if so how can i link them together? i need the user to be able to update the database but also read data from it.
View 15 RepliesI have problem with my application I have a table with 3 columns: column1(numeric(18,0), allow null), column2(nvarchar(255), allow null), column3(datetime, allow null). I want to read data from a .csv file and insert it into database. I use 'bulk' to insert data from file .csv into database instead of inserting query. But the problem is: the .csv file have to be formatted as:
[Code]....
I like to update data from an access database every 100ms. This works fine, but it does not look good on the screen. It refresh the whole screen on my laptop and it is not looking good. Is it a good way of updating data without getting this disturbanses in the screen?
View 1 Replieswhat I am trying to do is i have a table with four records and I want to write it to a txt file. I am running sql server 2000.I am able to connect to my database and I am able to right data to a txt file my only problem is it always returns the 1st row of data.
Dim FILE_NAME As String = "C: emp est2.txt"
Dim conn As New SqlClient.SqlConnection
Dim da As New SqlClient.SqlDataAdapter
[code]....
I know how to select items from an array with LINQ, but what I can't figure out how to do is access a database using an IQueryable. I connected the database to my project, added two classes from the database to the "LINQ to SQL" .dbml file and saved it. In my programming assignment, I am not supposed to create a data source (table thing) to display the data, but update my own interface manually. In order to do it, I was told to instantiate this:
Private dogs As System.Linq.IQueryable(Of Dog)
(Dog is a class that I added to my .dbml file from the database file)Also, I am told it involves using a method
.AsEnumerable.ElementAt(index As Integer)
what the best way to do this?
View 2 RepliesOK I can upload a single specified file but need to create a loop to read and upload all files in a certain folder. Here is code for single file.
'upload a file
ftp.Upload("c: estftpupload.exe", "/pub/upload.exe")
i've download the 101 Visual Basic and C# Code Samples from downloads/details.aspx?familyid=08E3D5F8-033D-420B-A3B1-3074505C03F3&displaylang=en i was going to learn "VB.NET - Data Access - Read and Write Images from a Database" from that 101. the program is written in 2003 the conversion of the problem to 2005 and 2008 failed.
View 3 Repliesi have a form with one combobox and textbox now on other hand i have a sql database named balance with two column one as customername and and another as obbalance now i had binded all the customer name to the combobox now what i have to do is wen user selects a customername from the combobox the textbox should show the obbalance of the selected?
View 1 RepliesHow can i retrieve data from sql database and put the values in textboxes?
View 7 Repliesi try to bind database to combo box but having (Object reference not set to an instance of an object) error during the running.
Sub laad_leden()
Dim myConnection As New connectdb
Dim tabel As New DataTable[code]....
While loading the data to the program the window freezes. It shows the progressbar but the progressbar is also freezing.How can i let the progressbar marquee while loading / freezing.
I know there is a lot of forums out there regarding this, but I haven't been able to find what I need and I am somewhat new to this. I would like the simple openfiledialog code button click to attach a word document or PDF and upload it to a SQL server table to be saved. I would like to use my current datasets and controls without creating another SQL query within my project as I have seen in other forums, unless that is the only method. I know that the data needs to be saved as an image type with the file name and extension but I just need the code for this. I would then like to download the doc or pdf to view it within a form.
View 3 Repliesi am having trouble loading data into listview from access database
Try
Dim iForLoop As Integer
Dim ds As DataSet
[Code].....
Private Sub Table1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1BindingNavigatorSaveItem.Click
Dim dg As DialogResult = MessageBox.Show("Would you like to continue saving your changes?", "Save Changes?", MessageBoxButtons.YesNo)
[Code]....
I have to burn the program I made but I'm afraid about the directories I include in the program.
PictureBox1.Image = Image.FromFile("C:\Documents and Settings\Marvin\My Documents\Visual Studio 2010\Images\Edsger Wybe Dijkstra.jpg")
If I burn it to a Disc, the image will not show up.Even I put them in one folder, It will not work still.How am I suppose to burn it on a disc without having any problem?
The following code for DISC CLEANUP works on Vista and windows 7 but not on XP?
Drive = "C:"
_process = New Process()
With _process
[code]....
I have googled and google on this, and I can't get it. AT ALL. Not even the slightest bit of code. I need some way to extract an ISO image.
View 3 RepliesI have a lookup table that contains a label that describes the data to be written back to my database. For example:Label = Manufacturing Repair Issue (This is what the user see's in my front-end windows app)Data = Mfg_Repair (What I want to save to the database when the user choses the label)
View 13 RepliesI need to check if the CD drive has a disc inserted, no matter the disc is blank or full.
I tried to get the IO.DriveInfo.IsReady, but a blank disc also return False. Then I tried to get the TotalSize, if there is no disc, it returns an exception tells drive is not ready, and if the disc is blank, it returns function error. How can I determine which error is responsible to the one which no disc is inserted? I should not check the error msg because it will change on different computer of different language.
My cousin and I were discussing the difference between Java and VB.Net and I thought I would make a simple application to show him.
My form has two labels a numerical up and down component and a button.
I want to set it so when my cousin presses the button it will open and close his disk tray for the amount of time he chose using the numerical up and down.
I have tried making the program using a sample I have acquired but ti keeps throwing this error.
This is the error.
PInvokeStackImbalance was detected
Message: A call to PInvoke function 'WindowsApplication1!WindowsApplication1.Form1::mciSendString' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention
and parameters of the PInvoke signature match the target unmanaged signature.
I have a Login Form and ...
I have this code to create an account on my disc:
Try
Dim aa As String
Dim ab As String
[Code].....
But now I want creat a button to emilinate accounts, and I dunno how to do that.
I have a small problem. I must save a captcha image from: http://konto.gazeta.pl/konto/3481801,2,,,,,,3.htmlI have problem when i navigate a captcha link. I get a other captcha.Only one solution are save image from webbrowser to file and upload him to server. I wanna make a full bot for creating account's. I have a decaptcher script.
View 2 Replies