In the following code, a selection in excel is selected. All of this information is then transfered to The DestFile. In this case the DestFile is Firm_ATC0.asc. I would like the program to put all the information from the A colum in the Firm_ATC0.asc file, and all the information in the B column in the Firm_ATC1.asc file and all the C column to go in the Firm_ATC2.asc file ect.Basically every time the column increments by 1 the Filename it is going to increments by 1.There are A to CV Columns selected in this example, and I think that is 99 columns and therfore there are Firm_ATC0.asc-Firm_ATC99.asc. Currently the information only goes into the one file.
in the keydown event of a textbox (textbox1) as text is typed in i want it to "knock off" items that dose not include the text in either colum 1 or colum 3.How can i do this ?
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles richTextBox1.TextChanged 'code goes here End Sub
I have a favourite form and it has 2 colums i want to save both colums to a text file then when the form reloads i want it to read the text file and display the info in the text file
i m using admin levels for a program it uses a Mysql database i now if u use a local db that u can use a dataset but how to do it when u have to Connect to a Mysql and check if the colum admin = 1 ?[code]......
So I still working on a program that shows this. This is the code that I use two show the SA and PLATINUM text because on the file they are not the only characters on the line, like this:
set username=sa set password=platinum code to search only those two words.
im new to vb.net 2003 but have used vb 6 for years and dabbled with 2005. A program that would usually take me a few hours to make i am on day 5, 4 and a half of which have been trying different ways to get it to update, and not one of them will post the information back to the SQL 2000 database I am actually going insaine.
The best i can get out of it is this error. "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information" I have googled it and come up with the fact the primary key isnt set right, but i still cant get that to work. Here is the peices of code that are relevant.
i have retrived this datatable from datasource and i want to add a more colum 'category'basedon the each value of each Role, like if role column has the value '90 daya client' then in the same row it should have a value 'DC' in the category column.n make a temporatry dt1 table but to add related values.
S.No First Name Last Name Role Date 1 Us er1Name User1Name 90 Day Client 11/01/2011 2 User1NameAtt1 User1NameAtt1 90 Day Client 11/01/2011
I have a gridview that contains data from a database somewhere in a sql server, so far so good, what i want to be able to do next is delete a row when i press the delete...Am new to asp.net and vbi will send the code and a printscree of the software:
ascx <%@ Control Language="VB" AutoEventWireup="false" CodeFile="Admin.ascx.vb" Inherits="Admin" %>
Reading a .txt file in VB.net. My file path is C:UsersMyLilMulePepeDocumentsVisual Studio 2008Projectscurtain_calls.txt.
This is my line of Dim LoanOptionsFile As String = "C:UsersMyLilMulePepeDocumentsVisual Studio 2008Projectscurtain_calls.txt"
I can read the file when I run the program, but how do I write the file path so that someone else can download my program and file and read the file on their system?
I do one project in visual basic 2010.In visual basic 6 project can be make Package and deployment (setup file or install file) file using Package and deployment wizard.But in visual basic 2010 express edition does not have Package and deployment wizard.how to make Package and deployment (setup file or install file) file in visual basic 2010 project?
i need to read binary file and in this file found the string and replace it with other one and save the file afterwords. I found many example to read binary, but to find and replace is for me mistery.
I'm trying to upload a file via FTP from my local computer to an FTP server, which is also on my local computer at the moment. I've got this sub I'm calling:
Public Sub UploadFTPFile(ByVal ftpservername, ByVal fullfilepath, ByVal filename, ByVal username, ByVal password)Dim clsRequest As System.Net.FtpWebRequest = _ DirectCast(System.Net.WebRequest.Create("ftp://" & ftpservername & "/" & filename), System.Net.FtpWebRequest) clsRequest.Credentials = New System.Net.NetworkCredential(username, password) clsRequest.Method = System.Net.WebRequestMethods.Ftp.UploadFile
[Code]...
I'm running an FTP Server using Golder FTP Server, which is freeware. I think it's setup correctly because connecting to the FTP Server using the exact same string as above using Windows Explorer works great.
I am trying to create a log file which I am going to use to populate some controls (DataGridView or Treeview). I am trying to figure out if should use text files or XML files to do so. Effectively the log will highlight multiple phases in a client-side app. The log will be written to at various phases when the project is running. The user will always have the options move on to the next phase or save progress and exit the project. As such, I want the log file to highlight how far the user has progressed throught the various phases AND I want the log to highlight varous information from each phase. Whenever the user starts the project, they will be given the option to load existing log files. So the project will have to read these log files and append them where necessary as the user progresses.
I am not sure what the best way to do this is and below is a rudimentary approach using text files. As you can see, the top of the file would have a summary of all the phases and whether or not the user completed each phase. Next each phase would have a data section highlighting what data was stored along the way. I have used a ":" to denote each section. Then within each section I would obviously need to use a delimeter for all my data. So if Phase1 = True, then I would load all the pertinent data from "Phase1:" into the desired control. Can anyone provide an efficient way of doing this and provide some insight as to whether I should use XML instead. The phases my change during development and I am not sure yet which controls I will be using. Does XML provide more flexibility.
In summary I am looking to create, read/write and append log files and populate controls with the data in varous sections of the log file. Example:
I need to write data to a file, preferably in binary format, but I am unaccustomed with the concept. Where's the easiest place to get the basics? I could come here with a specific need, but I'm at the point right now where I am more willing to work within the confines of keeping it simple.
Here's what I know: 1. how to open a new file 2. how to specify the record length 3. how to close the file
Some specific questions:
Does the record length have to be constant throughout the file?
Can I read the nth record without reading the whole file?
I have File Like "Sample.bak" and when I compress it to be "Sample.zip" I lose the file extension inside the zip file I meann when I open the compressed file I find "Sample" without any extension.
I use this code :
Dim name As String = Path.GetFileName(filePath).Replace(".Bak", "") Dim source() As Byte = System.IO.File.ReadAllBytes(filePath) Dim compressed() As Byte = ConvertToByteArray(source) System.IO.File.WriteAllBytes(destination & name & ".Bak" & ".zip", compressed)
Or using this code :
Public Sub cmdCompressFile(ByVal FileName As String)
'Stream object that reads file contents Dim streamObj As Stream = New StreamReader(FileName).BaseStream
[CODE]...
I need to compress the file without loosing file extension inside compressed file.
I am working on a VB Console Application that takes an Autocad drawing type DWG and converts it to a PDF using a shell command that calls a third party application. In this case, acmecadconverter.exe from www.dwgtool.com. Then the PDF that is created needs a unique watermark, so I call a second application for that called pdftk.exe from www.accesspdf.com/pdftk/.
Everything works as intended, except when I try file names that contain spaces. The file system object does not tolerate spaces in the drawing file name. For instance, the following command gives me a system.io.filenotfoundexception...
I'm currently developing an editor for an AFL management sim.I want to be able to load three or four multidimensional arrays to the program, then save them to the same file. I tried the tutorial on here but got completely muddled up. Why can't it be easy like in VB6 When it was like 10 lines of code tops!
I am writing a program to calculate Pi to several hundred billion decimal places and this will require lots of GB of memory. I wrote a test program in VB2008 that saved the first 16 digits of Pi (without the decimal point) to both a text file and a random access file, just to be sure it was outputting the numbers properly. For reference the first 16 digits of Pi are:
Our program will start with the help of a FileSystemWatcher object. How can we check or the file is total copied, for example the file is 100 Mbyte it take a time it's ready for use. Idea:
Do While True Try N = testForUse(BigFile) If N = 1 Then Exit Do
I have an app I created in Vb2010 (my 3rd VbApp) it is a file converter which works but all it does after convert is... I have a converted file but no file name plus it converts within its own directory as opposed to convert in dir where original file location.
So any clues as to how I always use file to converts name as defa and where the converted file will reside same dir as original file?
Need to know the code in which to loadfile (.rtf) into a richtextbox via user-selection when the rtf file is within the setup of the file system editor under 'Program Files'. Have used the following code and it doesn't work....
CODE:
Me.RichTextBoxDisplay.LoadFile(Application.StartupPath & "Application FolderGarman SoftwareKing James Version 1611OTGenesisChaptersGen Ch2.rtf")
Here's my code: System.IO.File.Move(Form6.OpenFileDialog1.FileName, "Temp") I'm trying to make it so that the program copies the file that you select in the OpenFileDialog and moves it into the "Temp" folder. It gives me an error saying: Cannot create file when file already exists.
