How To Do Simple SQL Like Operation On Text File

Jan 20, 2010

I have a dbase.txt file with some data in it. i.e -

Institution Course StudentID
XZY ABC 2010-1111111 "the spaces between columns is one tab space"
XYZ ABC 2010-1222222
XYZ ABC 2010-1333333

I want to perform simple SQL like operation - i.e -
SELECT * FROM dbase.txt or
SELECT Institution FROM dbase.txt WHERE StudentID=2010-1111111 and an insert operation like -
INSERT dbase.txt VALUES (XYZ ABC 2010-1444444)

I have written some code which is not even closer to what I mentioned above. My program can read only the whole text file. There is a menu, but not functioning well, as well as my write function which is not working at all.

Below is my code -
Imports System.IO
Module Module1
Sub Main()
Dim intInput As Integer
Console.WriteLine("Main Menu")
[Code] .....

View 4 Replies


ADVERTISEMENT

Run A Simple Operation On Folder Of Pictures ?

Jan 23, 2011

I am looking to create a small program in visual basic 2010 to perform the following actions on some photo's.

#1) I want to select a folder, that contains say 3 to 10 pictures all of which will have random file names (including some characters like - _ ~ )

#2) I want to resize each photo by 2pixels (both width & height)For right now shrinking it by 2 pixels would be best, i do not want to crop, as it may mess the photo up after a couple of times being run.So if it was 500x500 to start with, when its done, it should be 498x498.

#3) I want to save these newly resized photo's as newly created files.We can either delete the old ones automatically & save the file with the same name. Or simply add a random 1 digit # to the old file name, for the new file name.Either way, I do not want to "save over" the old file.I have never worked with any type of image operation in VB before so I have no idea where to start.

View 2 Replies

Text File Operation Using VB?

Dec 29, 2010

I have to code in VB.Net to delete first 16 columns from given input .csv file .[code\...

View 2 Replies

VS 2008 - Simple Text -> Xml Program - Save The Contents Of The Bottom Text Window To An Xml File

Dec 23, 2009

I have this Quiz software that lets you create online multiple choice quizzes which are great for studying (I am in grad school and I'm trying to use everything I can to learn). So the Quiz software is great but it only lets you input questions by hand, one by one. I took a look at the .xml file that the quiz program spits out and came up with the idea to try and make a converter so that I can import many questions at once. I was hoping to try and solve this limitation by doing the following:

Take a .doc that say a tutor gives us with a bunch of practice questions, and then take that into Crimson Editor, and then format it so the question is on line 1, the multiple choice answers are on lines 3,4,5, and 6, (for the next question, the question would be on line 11, and the answers on lines 13, 14, 15, and 16, and so on) and then take that saved .txt file into my program, hit the generate button, and it will spit out the .xml file, and then import that into the quiz software to generate the online quiz.

Here is an attached screenshot of my program layout so far:

I figured out how to open a text file by watching simple youtube tutorials, but I don't know how to have it generate the stuff and have it show up in the bottom text box. I know how to do the coding to convert the txt to proper xml code but I don't know how to be able to save the contents of the bottom text window to an xml file.

View 1 Replies

.net - VerificationException Operation Could Destabilize The Runtime On Simple LINQ Query

Jun 11, 2009

The code below works fine on my development PC, but when I deployed the app, it crashes.

Here is the lines of code that are relvant

Private TdsTypesList As List(Of TDS_Type)
...
TdsTypesList = (From tt In db.TDS_Types Select tt).ToList

[Code].....

I have many queries that are using linq, and none of them throw any errors. The set of data is not very large either, less that 100 rows. I dont know if I have any other queries that do not have where statements in them that work.

Running .net 3.5 without sp1 on the client machine, although I am running sp1 on my development PC. looking for a solution that doesn't require sp1 to be installed.

Edit Code breaks on the second line when remote debugging.

I looked over [URL] and tried the following, with the same error.

TdsTypesList = tl.OfType(Of TDS_Type)().ToList

I finally found a dirty workaround. Instead of pulling all of columns from that table, I was able to re-write the query to omit 1 column. This returns an object of anonymous type, and I can use that object. I still would like to know what causes this though.

View 1 Replies

Display Results Of An Operation To A Text File Temporarily?

Oct 21, 2009

I am writing my own script for a simple calculator that determines if a number is prime, and its prime factors.[code]The loopcount = compare - 2 means I want the loop to be 2 less than the square root of the answer so that when do a descending calculation (loopcount = loopcount - 1) it doesn't see if 1 or 0 is a factor of the answer. for the calculations after that, I want, every time n1 = n2 (a whole number factor of the answer), I want to report those results to a text file (n2 and n3) in this format "(n2, n3)" then go to the next line. and continue to execute the loop until the loopcount is zero. Currently, when I run the code, the application closes when I click the prime button (button that runs this code) and I don't know why. This is my first semester in school, and have never coded before, so I am a definite laymen with code, but I really really want to learn it (hence why for fun im just creating algorithms for different things).

View 2 Replies

Forms :: Cross-thread Operation - Setting Up A Simple Application That Has 2 Variables?

Nov 18, 2011

I'm setting up a simple app that has 2 variables, one from a combobox and one from a textbox.Putting all my code directly in the button1_click sub works just fine, however, I wanted to add a marquee progress bar so I tried to implement a backgroundworker.

[code]...

and call it with Me.Invoke(New SetComboBoxTextDelegate(AddressOf SetComboBoxText), ComboBox1.Text)but it still throws the Cross-thread operation invalid error.

View 10 Replies

VB - Simple Text File Loading ?

Dec 25, 2010

Getting a vibe that my VB is cursed. All I want to do is load a textfile and have the text appear in TextBox1 But no. I have looked at 3 different tutorials and I have tried copying their code word to word but still!

Public Class Form1

Private Sub ImportToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ImportToolStripMenuItem.Click

[CODE]...

And it gives me the following errors:

Error1Character is not valid.C:\Users\Saurabh Sharma\AppData\Local\Temporary Projects\WindowsApplication1\Form1.vb1067WindowsApplication1
Error2'daText' is not declared. It may be inaccessible due to its protection

CODE]...

View 11 Replies

Parse An Html Code To Simple Text File?

Aug 9, 2007

I want to catch the text from an html page.. you know that when you open any html page in the browser, you will see a text but with formatting.. because it's an html code having a lot of tags...

how to get the text from an html page and ignore all formatting and html code?

[Code]...

View 7 Replies

Read/write A Simple Text File In Net 2008?

May 9, 2010

I am trying to read/write a simple text file in net 2008 but can't, as yet, get it to work. This is how I use to do it in VB6

Code:
MyStr = App.Path & "DataData.txt"
Open MtyStr For Input As #1

[code]....

View 11 Replies

Sort A Simple Text File Starting With The First Character And So On

Sep 21, 2009

I have a simple text file containing a list of names that I wish to sort. I was hoping for something simple like:

System.IO.File.ReadAllText("MyFile.txt")
System.IO.File.Sort("MyFile.txt")
System.IO.File.WriteAllText("MyFile.txt")

or something like that. Didn't want to actually write a bubblesort/quicksort routine myself.

I would imagine the routine would just rewrite the final file or would I have to make a new file and copy the contents back to the original?

View 2 Replies

Making A Simple Program That Encrypts A Text File And Then Decrypts It?

Sep 30, 2009

I am making a simple program that encrypts a text file and then decrypts it: why i get an error when i use this

Public Class Form1
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
System.IO.File.Encrypt(TextBox1.Text)

[Code].....

View 12 Replies

Reading A Simple Text File, Splitting And Sorting The Contents Using Vb

Oct 27, 2011

I have managed to access and read a specific file line by line. If I wanted to split information by a comma or space and then sort alphabetically or numerically, how would I go about this procedure? Would I create a loop within the reading loop to parse the information?

Dim file As String = "C:Users est.txt"
Dim Line As String
If System.IO.File.Exists(file) = True Then

[Code].....

View 1 Replies

VS 2008 Send A Simple Text File To A Client From The Server?

Feb 16, 2010

I am Really Interested in Learning How to Code in Vb With Client and Servers.What should I use Tcp/Ip,Winsock? any Good Tutorials or Examples. How do I send a Simple Text file to A Client from the Server?

View 1 Replies

VS 2010 Make A Simple Program That Can Create A Text File With The Content?

Aug 23, 2011

Im learning Visual Basic 2010 on my programming class and we reached the part of file handling. Here i tried to make a simple program that can create a text file with the content of what i type on the textbox, basically i create the file if it doesn't exist, and if it already exists i append the content to it. Once the file is saved i can read it using the "Open" button. Unfortunataly, whenever i try to create the file, the compiler gives me an error saying that it cannot modify a closed file, although i've followed up the execution instruction by instruction and i can't find the error.

Imports System.IO
Public Class Form1
Dim body As String

[code]....

View 6 Replies

Conversion Of A Text Data In String Or In A File Into A Simple Byte Array[ ] Format

Aug 27, 2009

I'm new to .net. I would like to know how to convert a text data in string or in a file into a simple byte array[ ] format.

View 3 Replies

Design A Program That Can Encrypt And Decrypt Messages Stored In Simple Text Files Using A Private Key Stored In A Separate File?

Jun 13, 2011

Need to design a program that can encrypt and decrypt messages stored in simple text files using a private key stored in a separate file. Software should also be able to allow the users to enter simple messages that either displays the encrypted or decrypted message. The encryption method should use a simple substitution method. It should be set out in the following format:

Example (the "@" is the separator):

@
The character The Code End of line
A @ 4gh EOL
B @ 84!9 EOL

Has to use the 256 ASCII character codes. The separator will be used to separate the character and its corresponding code.Here are the pseudocodes I have come up with:

� Read any private key file
separator = readline(file);
while not EOF(file) do
tempStr = readline(file);

[code].....

View 5 Replies

Get Numbers From A Text Box Then Use Them In A Math Operation?

Mar 13, 2010

How to get numbers from a text box then use them in a math operation.

View 4 Replies

Convert A Delphi Copy Operation To A .Net Substring Operation?

Jan 4, 2012

I'm trying to convert code from Delphi to .Net. I'm stuck on one line:

//Delphi code ss := Copy(ss, Length(ss), 1) + Copy(ss, 1,Length(ss) - 1); 'vb.net code ss = ss.Substring(0, ss.Length - 1) + ss.Substring(1, ss.Length - 1)

Delphi combines the two substrings, while .Net just concatenate them like a copy.

View 2 Replies

Correct Dim Command For Scrolling Text Operation?

May 16, 2010

I am working on a scrolling text operation within a VB.net/ASP.net application. However, I am getting an error command from the following two commands:

Me.ScrollingMarquee.InnerHtml
Return Me.ScrollingMarquee.ClientID

The error is that the InnerHtml and ClientID properties are not recognized as members of the class. Apparently I am not using the correct DIM command for "ScrollingMarquee" (e.g. "Dim ScrollingMarquee As Control" is incorrect)).

View 2 Replies

Simple Name And Address Tracker File That Can Enter Data And Save It As A File

Dec 14, 2010

I am new to using visual basic 2005. I have a tutorial book and I have followed it but it does not help me understand. I have a limited understanding of the net framework and the drag and drop features.

What I want to know is this: How do I make a simple name and address tracker file that I can enter data and save it as a file. The book does not cover this proceedure but It is what I want to do.

IE: Start VB2005 start new windows app. Name (whatever) drag 2 label's and 2 textbox's and one button for saving data entry. I want this program to enter name in textbox1 (press enter) then enter address in textbox2 (press enter) then save file (whatever name) when you click the button.

View 2 Replies

Simple Text Rewrite With Tag?

Dec 6, 2009

basically the user enters phrases into the textboxes, and i use <TAG> in the text so that every time button is clicked the selected text is rewritten including a phrase from the textbox.

View 19 Replies

Text To Speech Is Simple Enough?

Apr 29, 2011

So basically, I now how to do the whole text to speech thing with the following Button

VB
Dim SAPI
SAPI = CreateObject("SAPI.spvoice")
SAPI.Speak(TextBox1.Text)

But is there any way to get it to read other writing systems, such as Korean Is there some sort of software or some addon or something I can install? Perhaps a Korean version of Microsoft Visual Studio 2010, or something?I'm really at a loss here, and it would help me out a lot if there's a solution out there that someone can think of.

View 1 Replies

The Operation Has Timed Out On Downloading File

Nov 18, 2011

i have a datagridview and each row got link.. and i using timer and backgroundworker as downloading file.. the 1st file download, its perfect working.. but when its going to download 2nd link from datagridview, nothing happened.. even its said, "The operation has timed out"..

[Code]...

View 1 Replies

Print Simple Text In Courier New?

Mar 27, 2009

Is there a way to print simple text in Courier New? No pictures, no fancy fonts, it's all the same size, and no margins, etc. Is there a VB.NET function for this?

View 3 Replies

Simple Text Printer In 2010?

May 13, 2010

In VB6, when I wanted to print text, I would do something like this...

Dim TextToPrint as string
TextToPrint = LastName(1) & ", " & FirstName(1) & " " & G(1,1) & " " & G(1,2) & " " & G(1,3) & vbCrLf
TextToPrint = LastName(2) & ", " & FirstName(2) & " " & G(2,1) & " " & G(2,2) & " " & G(2,3)
TextToPrint = LastName(3) & ", " & FirstName(3) & " " & G(3,1) & " " & G(3,2) & " " & G(3,3) & vbCrLf
Printer.Print TextToPrint

What's the equivalent in VB 2010?

View 17 Replies

VS 2010 Simple Dynamic Text Box

Apr 28, 2012

I can't understand why this isn't working [code]I've created that text box. And I'm trying to use this event handler, to change the value of the public variable oName. But I'm getting an error saying that Text is not a member of HeroName.[code]

View 6 Replies

Entering Text In Windows Application Textbox Error: Operation Has Been Cancelled Due To Restrictions On This Computer

Nov 30, 2011

I have a windows application written in VB.Net 2008, framework 3.5. This app is running on 2 remote desktop servers. I have one user who receives error, This operation has been canceled due to restrictions in effect on this computer. when entering in a text box. When he uses the application on Server 1 he does not receive the error. It only happens to this 1 user on one server.

View 10 Replies

Communications :: Simple Send Text/files With IP

Aug 31, 2008

So ive looked everywhere but every example i find doesnt work on visual studio 05 and doesnt convert properly. I simply want to send info from one computer to another through direct connection. if anyone could point me in the right direction it would really be helpful. most stuff i find seems to be more complicated than what im looking for.

then just one other question. both computers will be going through a router. as long as i have the port im using forwarded on the hosts side, that shouldnt be a problem, right?

View 1 Replies

Implement A Simple Text Editor Within A RichTextBox?

Feb 8, 2011

What is the easiest way to implement a simple text editor w/in a RichTextBox? For example, one similar to what I'm using here to enter this text (i.e., having a bold, italic, underline, redo/undo, bullet, number, and hyperlink buttons).

View 11 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved