I'm trying to upload to a folder files, however, this files can already be there, so the user could replace or maintain all the files. So if the user choose to maintain the file, I must rename the new file, like: file(1) --> or something like that.
View 14 RepliesMy files are being inserted but the byte array is showing as a 0x0000... etc for every file after the first inserted file. The first inserted image is correct. The database is set up as an Image type. The problem exists in the code here\
Dim uploads As HttpFileCollection
uploads = HttpContext.Current.Request.Files
For i As Integer = 0 To (uploads.Count - 1)
[code].....
I have a directory full of .txt comma delimited files arranged as shown below. What I want to do is to import each of these into a SQL or SQLite database, appending each one below the last. (1 table)... I am open to C# or VB scripting and just not sure how to accomplish this. I want to only extract and import the data starting BELOW the 'Feat. Type,Feat. Name, etc' line.
These are stored in a mynetworkdirectorystats folder on my network drive. Ideally I will be able to add functionality that will make the software/script know not to re-add the file to the database once it has already done so as well.
[Code]...
I have tried with filestream but it also changed the strings that is in position
Dim fs As FileStream = File.Open("C: est.blah", FileMode.Open, FileAccess.ReadWrite)
Dim testdata As String = "a"
fs.Write(Enc.GetBytes(testdata), 0, testdata.Length)
[Code]...
I would like to insert several PDF files into oracle. I have been looking for some examples but i didn't find it.
View 1 RepliesWhat tools/methods are available to build pcl stream from PDFs.We have a bunch of generated PDF files that get tied up into one big pdf.I need to generate a print job to print this with the ability to insert pcl escape sequences (to control paper feed and output bin stacking) per page. As of now we use the VB.Net printing classes, convert the PDF into a rasterized image using a third party tool to print. This does not allow us to insert PCL sequences into the print job.
So, basically, we need to process a bunch of PDFs, append them to the pcl and insert PCL commands as we go along. Is there a way to achieve this. Our application is written in VB.Net.
I am using VS2008(VB.NET) and SQL Server2000. I want to make an application which reads files and Insert Data into SQL. If first file has some error. Write into log and Move Next file for Proceed. How can I do that.
View 3 RepliesImports ATSMS
Imports Scripting
Imports System.IO[code]....
this is my code n it works well but wen i want to insert multiple textbox value then it gets an error.
what i'm trying to do is to select some csv files and insert them into datagrid view but the problem now i can't manage to perform a find and replace ,and here's the code
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
For RowsCount = 0 To DataGridView1.Rows.Count - 2
For Each dgvr As DataGridViewRow In DataGridView1.Rows
[code]....
but isn't working it gives me " null reference exception was unhandled "
I have many text files in a folder. What I can do now is to read through one text at a time and insert it into the database. My little app reads a text file when I debug it. So, I need to run it several times to read all those text files and import them into the database.
My question is how to read multiple text files inside a folder at a time. Here's my code which works fine but it reads only one text files at a time.
Private Sub btnRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRead.Click
Dim filelocation As String filelocation = "F: xtfilesch25.txt" Dim chid As Integer chid = 25 'read from file Dim MyStream As New StreamReader(Path.Combine(Application.StartupPath,
[code].....
Obviously, I need a way to loop through a folder and check if there's text file. But I cant get it right.
im trying to write to an sql database. im inserting an image, as well as some other information. I am using the following code which works fine, as long as i do not add an extra column/variable "LOCATION" in to the mix and leave "
'Cmd.Parameters.Add("@LOCATION", OleDb.OleDbType., 3).Value = "testing"
commented out. *this is undesireable as im trying to add extra criteria to be saved like LOCATION.
Try
Dim st As New FileStream("\serverfolder1storage" & "pdftemplate.jpg", FileMode.Open, FileAccess.Read)
Dim mbr As BinaryReader = New BinaryReader(st)
Dim buffer(st.Length) As Byte
[code]....
i am trying to store the location e.g "c:file1.jpg" in the sql db. Can anyone reccomend a solution to this using OLEDB? ideally i need to add approx 4 more variables. e,g
firstname
surname
dob
location
Im getting an error with my insert statment "Syntax Error in INSERT INTO statement". I do not understand why. Im using global variables from form 1 and using them in form2 and trying to insert them from form2 into the database.
[Code]...
could someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
[Code]...
Visual Studio 2008VB.NETFramework 3.5Windows Application
I have a SQL database names TestSQLVB
In it a table called tblTest2, with a three fieldstest2id , int, pk, increment by 1field1, varchar(50)field2, varchar(50)
I have a dataset named Dataset2.xsd
A tableadapter named tblTest2TableAdapter
A insert query names InsertTest2 with fields @f1, @f2 and ExecuteMode = Scalar
When I run the following code per MSDN [URL] the database does not get updated.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim testds As New DataSet2TableAdapters.tbltest2TableAdaptertestds.InsertTest2("One", "Dog")
End Sub
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
I have a csv file that I need to import into a sql table, this portion is working correctly. The code grabs the data, displays it in a datagridview and then imports it into the sql table. What I need to do is add an additional field that will automatically number itself by the amount of rows inserted at that perticaular moment. Let me explain a little clearer. The data I grab from the csv file is a day snapshot broken down to the hour. So lets use todays date 6/28/2010 will be broken down in the csv file like this:
Date
Time
Num#1
Num#2
[code]....
I am developing vb.net windows application. I am trying to insert data with insert command.I am getting the insert data as long as the application is running. But when i close the application and reopen again the inserted data was not in the access database and i am getting no result. what is the problem, is it in code? i am using like
strsql=" Insert into table(col1,col2) values(val1,val2)"
selectCommand as new oledb.command(strsql,strConn)
selectCommand.ExecuteNonQuery()
Not inserting in the database but showing in application. how?
why my insert doesn't insert into mysql database
[Code]...
here is my code so far:
Public Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim i As Integer
[Code].....
when i click the button, i get a error message saying "Syntax error in INSERT INTO statement". as far as i can tell, i have everything i need to insert a new row into the database, and i dont see why this problem is occuring.
item(0) is an autonumber key field, so that should make a new record by itself, and i have declared the input textboxes as the data() array
which are the control used to display word files and excel sheets inside vb.net forms ? (i have already added reference lib.)
Platform: Vb.net (framework : 3.5)
language : visual basic
I'm currently working on an application that allows users to select picture files and then categorize them into folders. Now I'm having two issues that are probably simple to fix but I only have a year of experience with vb so I just don't know how to fix them. The first and biggest issue is that once the user has selected and categorized a file, I want the program to select the next file in the folder that the first file was moved from. This way the number of clicks required is minimized. However I have no clue what I would need to do in order to accomplish this. Also, my other problem is that I want to be able to find the indexof a quotation mark but whenever I put it in the parameter it just reads it as a quote.
View 4 RepliesI am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
I have VB project and I tried to use PUBLISH feature.It seems to create nicely some kind of setup program, but the setup program does not ask where to copy files (it does not seem to copy filesto target machine "PROGRAM FILES".)Is this setup program somehow different from usual installers?
NOTE: I want that app files are installed to Hard disk( from USB stick source)Is the signing recommended or necessary? My App is pretty simple, its just using access DB + printer api, should I still sign?
I know this is out there and probably illogical but I was wondering if it was possible to take multiple picture files and compact them into one file.... and then retrieve them from the program later? Way to combine any amount of image files into one file
Module Module1
Sub combine()
Dim img1 As New Bitmap("i1.jpg")
[CODE]...
I wrote windows app to upload files to different FTP sites by picking the files from different folders.A log is displayed by appending text to the textbox at every step.Textbox is ReadOnly.
Issue:When app is loading a bf file to FTP and if user tries to scroll the textbox,the form is hanging and going to Not Responding.?
i have an old VB6 system that generates plain text files. When this old system writes "A" into the file, it writes (hex) "41". For an "ä" (a-umlaut, special gernam character), it writes (hex) "E4".
Now i have to process files like this in VB.Net. when i open such a file in the IDE, it displays correctly "ä" (But not always!). To see what i mean, please open a notepad and create a new file "ae.txt" with content: äöü. Now your file contains exactly 3 bytes: (hex) E4 F6 FC.
But when i write code like
Dim strTest As String
strTest = File.ReadAllText("ae.txt")
Debug.Print(InStr(strTest, "ä"))
i get 0 - so i cannot find back the "ä" - what do i need to do, to find it? And 2) for compatibility reasons, i have also to be able to create such files. How to do that? Seems the different encoding types do not work as i think.
I am trying to create a program which will read the files that exist in a directory, and then write in a text file the specific information (full file name, date created)i have found several code in the site but i cant make it work, the machine i am running the code is XP and i am using VB2008.The code i have found is the following:
Imports System.IO
Imports System.String
[code].....
How do i make a code that unzips files and then move those files into another zip file?
View 2 RepliesOk I know this question has been asked to death but I still have not seen a good answer. I have created an application in VS2010 using VB.NET. In my application I have an error log that is an XML file located in the Public gstLocalErrorLogLocation As String = Application.StartupPath & "ErrorLog"that gets written to in the event of an error so I can trouble shoot application easier. My application also downloads files from our FTP site and puts the files in Public gstLocalDownloadLocation As String = Application.StartupPath & "download"So I have files that get read and written to as well and created and deleted all in the Application.StartupPath which is either "c:Program Files(Application Directory)(Some Directory)(Some File)" or "c:Program Files (x86)(Application Directory)(Some Directory)(Some File)" depending on 32bit or 64bit Windows 7.
After creating the setup I install it on my test machine that have both Windows 7 32bit and 64bit.Everything in the application works great till I have to write to, delete or creat a file in those directories above. I know it is an access issue and the UAC. This will get installed on numerous systems so the options I have seen to change file or folder permission on the computers manually is not an option.What has to happen is after I install the application it just works like when you install it on XP. Some post have suggested that you us a user with administrator privilages or group which is all fine and dandy but the user I have used to test the application has all of that.
So what I am asking is how do you create an application with VS2010 in VB.NET that after creating a setup package and installing on Windows 7 will just work with out "Access to the path c:Program Files(Application Directory)(Some Directory)(Some File) is denied." If I have to install this on 100 Windows 7 computers it has to be a concreate no manually doing anything just install and work like when we installed on XP.