Colum In The Firm_ATC0.asc File?
Jun 5, 2011
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.
[Code]...
View 2 Replies
ADVERTISEMENT
Jun 14, 2009
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
View 25 Replies
Sep 27, 2009
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
View 1 Replies
Feb 12, 2011
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]......
View 3 Replies
Mar 31, 2012
How can I remove items if the listview colum 2 contains a certain word?
example
Col 1 Col 2
John Hired
Joe Fired
Bob Fired
after clicking a button it would remove the all the Fired items so both the person and the fired would be removed.
View 2 Replies
Nov 14, 2011
i have a DatagridView, with a Colum " KG".Into the Colum, i place numbers.Now i wants a total of all numbers, place into a TextBox, using a code.
View 15 Replies
Feb 1, 2012
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.
[Code]...
View 15 Replies
Dec 30, 2010
If i have two textboxes textbox1 & textbox2 and button1 in my ASP.NET and SQL Server database
Database records are:
ID Date Seats
1 15-Dec-2010 1,2
[code].....
View 3 Replies
Jan 20, 2009
Is there a way to have the data grid view show the colum names as rows and then the data would be in the colums?
I know I can do it in asp. But cant figure out how to swap the 2 around for display purposes in VB.
View 3 Replies
Oct 16, 2006
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.
[Code]....
View 6 Replies
Jan 4, 2011
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
[code].....
View 1 Replies
Apr 30, 2012
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" %>
[code]....
View 4 Replies
Feb 27, 2012
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?
View 3 Replies
Jan 8, 2011
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?
View 4 Replies
Jan 11, 2011
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.
View 3 Replies
Oct 31, 2009
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.
View 2 Replies
May 22, 2009
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:
Phase1 = True
Phase2 = True
Phase3 = False
Phase4 = False
[code]....
View 5 Replies
May 4, 2009
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?
View 8 Replies
Jan 4, 2011
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.
View 1 Replies
Feb 3, 2010
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...
My.Computer.FileSystem.RenameFile("Test Flowchart1.dwg", "Test~Flowchart1.dwg")
It's the same problem for all of my File System commands. Either file not found or invalid arguments.
The complete script I'm using is here:
Code:
Sub Main()
Dim arrArgs() As String = Command.Split(","), _
i As Integer, folderPath As String, myPart As String, _
[Code].....
View 2 Replies
May 13, 2012
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!
View 5 Replies
Jan 7, 2009
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:
View 8 Replies
Jan 22, 2009
I have a program that can save to a .txt file.The issue is I need it to be done in a tab delimited way.Basically:
TextHere<Tab>TextHere<Tab>TextHere<NextLine>
TextHere<Tab>TextHere<Tab>TextHere<NextLine>
I have this so far, but all it does is put the TextBox1.Text next to TextBox2.Text
Code:
SaveFileDialog1.Filter = "Text files (*.txt)|*.txt|All files (*.*)|*.*"
Dim FileWriter As StreamWriter
Dim results As DialogResult
[code]....
View 7 Replies
Dec 6, 2010
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
[CODE]...
View 3 Replies
Dec 23, 2010
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?
View 2 Replies
Sep 19, 2010
I want to be able to able to read the dimensions of a TIF image without loading the entire file.
PS Using Visual Basic 2008 on Vista64.
View 11 Replies
Oct 14, 2010
[URL] to create my sqlite db file. I created it as a sqlite db version 3 file. When I go to open the connection
[Code]...
View 1 Replies
Oct 17, 2010
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")
[Code].....
View 1 Replies
Sep 27, 2010
Do you have some source code how to open a file (file browser) with file extension specific using Visual basic.net.
Just need to get the path then control this using the vb.net binding
View 2 Replies
Nov 15, 2010
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.
View 7 Replies
