with vb.net05 + access 03;how can i execute a bunch of SQL statements against a connectionwhich are written in a text file (as like we do in reading from backup file in MySQL)
View 9 RepliesI was rooting around in one of our company apps which is done in VB.net. I'm not familiar with VB.net (I do stuff in C#) so I'm asking this question: Does the code after the clean up comment execute? [code]It is my understanding once you say return, you give the calling function control again.
View 6 RepliesI'm implementing an application using vb.net 2005 with oracle 10g and I came across a functionality that should Select/Insert/Update/Delete data from three different tables in oracle.So I`m wondering if there is a way to prepare all the 3 commands (SQL Statements) separately and then execute them in one shot to the oracle, so in this way I can guarantee that all of them are successfully executed or all are failed to execute, and also I could gain more performance which is critical in my case.Thus I`m looking for a syntax in vb.net that helps me execute more than one OracleCommand in one shot to the oracle.
View 1 RepliesWe have a VB6 program that uses an ADODB.Connection to establish a database connection and use its execute function to run SQL statements. The connection we have established is to a SQL Server. It has been working fine. Currently, I am trying to change the connection to a MySQL database. I changed the connection string and the connection is ok.
However, when it comes to running the execute function, it returns a runtime error 3246 - connection object cannot be explicitly closed while in a transaction.
I checked the connection.status before calling execute and found that it is open. When I use MySQL's server connections to check the status, I found that there was a connection before and after execute was called.
I encountered this same error whether I used MySQL ODBC 5.1 Driver or MySQL ODBC 3.51 Driver.
I have a piece of code in my application that is giving me a funny result. I am reading a text file and based on it's first word on the line I have a bunch of IF statements that then assign the value to a variable.
The problem is that not all the if statements are being met, well they are but that's what's weird.
[Code]...
if i have a text file that reads
gsf
hot
dmg
bp
comp
how can i pull it into an array and if the textbox = any of the lines then execute event something like this
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Me.textbox1.text = (textfile contents) then
timer1.interval = 500
[code]....
im just not sure on how to initiate the calling of the text file into an array.or if i could call lines from a richtextbox and if textbox1.text = a line in the rtb then execute. I guess what ever would be simpler.
I need to write VB program to open and read text file, store each field (separated by comma) into an array. In the first array, it's an excel file and I need to execute it, and once opened in excel, there is a macro program inside and i need also to exceute using VB.
sample content of textfile:
C:principalsinventory.xls, MacroInventoryReport, 1, 3:00AM
----------
C:principalsinventory.xls, MacroNearExpiringReport, 1, 4:00AM
Can someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
View 3 RepliesCurrently, I've used System.IO.StreamWriter to write items to a text file. However, what I have are items separated by a Writeline(). Meaning, the items are displayed in several rows, in a column. But what I want is a single row, with many columns, separated by commas for each item. Example of what I want: 16/8/2010,100,you
vb.net
Dim psBattery As PowerStatus = SystemInformation.PowerStatus
Dim perFull As Single = psBattery.BatteryLifePercent
Dim Now As DateTime = DateTime.Now
[code]....
How do I save text from 'RichTextBox1' to a text file?
View 4 RepliesI'm trying to execute a cmd file with a different user but what I have isn't working the log in returns true but the command doesn't run
vb
Dim iu As New ImpersonateUser
' Note: This user must be the user that installed ReaConverter Pro otherwise each image
' will be stampted with a ReaConverter logo. This is a limitation of the evaluation/trial version.
' impersonateValidUser(username, domain, password)
[code]....
If I remove the impersonation stuff the command executes but my images are stamped with the coversion tools logo which is a limitation of the trial version. The image conversion tool needs to be run by the user that installed and registered it. I'm confident that the impersonation works as I use this class to copy files accross the network in other areas of my applicaiton.
The command file is also okay because if I manually run the command file (ReaConvertFile.cmd) the image file is converted.I know that the licence is installed correctly because if I log into the server as the relevant user and run the conversion tool manually (through the GUI or manually execute the .cmd file) the files convert and are not stamped with the conversion tools logo.I think something is missing the correct permissions? I tried giving my user full control of ...system32cmd.exe but that didn't help?
I a very large text document, I need to read some lines and at the end of each line, insert a text from the header of each page to he preceding lines.I have the following code the reads the file and displays it on a list box.Public Class Dialogs..[code]
View 2 RepliesIn classic ASP (VBscript), I always had simple include files (broken into relevant sets) that stored all my dim statements, so I could never reuse a variable accidentally.How can I achieve this in VB.NET? I don't really want to be filling several lines per .vb file with the same set of variable declarations if I can get away with just one class file or something simlar.
View 5 RepliesI want to know, is it possible to execute any code when I click on the X of window to close it. How?
View 3 RepliesI need to execute some code after the form is loaded and shown on the screen, how can I do that?
View 2 RepliesI am trying to execute a command line EXE (busobj.exe) with required parameters through VB.Net. Because of unknown reason the report is not being generated. Here's the commandline:
Shell(txtBOExecutable.Text & _
" -user " & txtUserName.Text & _
" -pass " & txtPassword.Text & _
" -system " & txtDomain.Text & _
[code].....
How saving what is written in a text box in to a text file ??
Note: Iam using vb 2005 express edition
I am reading the strings from the text file, but I would like to get the strings that come before the comma, then input the strings in the listbox.
[Code]...
I want to write a line into a text/.cfg file. The line is = name "ishtiak". I need a sapce between name & "ishtiak". The text "ishtiak" is loading from a textbox called textbox1. I dont want in the text box my name like this "ishtiak" it will be without "" like this ishtiak
but in the text file it will add "" before & after my name.
So the question is
1. How to add space between name & "ishtiak"? like this = name "ishtiak"
2. My textbox text will be ishtiak,but it will be written like this "ishtiak"
Here is My Project Screen & Project Code
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim thefile As String = "C:append.cfg"
Dim lines() As String = System.IO.File.ReadAllLines("C:append.cfg")
lines(4) = "name" & TextBox1.Text
System.IO.File.WriteAllLines("C:append.cfg", lines)
End Sub
I need to fetch numbers one by one from text file, suppose i have a text file with different serial numbers, like;
SHG9001231 SHG9001232
SHG9001233 SHG9001234 SHG9001235
SHG9001236
[code]....
there is no sequence like tab delimited, comma delimited or CL/LF, so it need to search on every prefix series and fetch entire serial number. But i have no clue how to write code in vb.net 2005.
Such as the text file has 5000 lines and 500000 columns. Each line has the format "xxx,yyy,zzz,000,...."
View 39 RepliesI have text in a textbox that I want to write to a file. I'm trying to think of the best way to do this. Would reading the text into a buffer, then writing the buffer to a file be the best approach? I'm sure there's more than one way of doing this and I wanted to see if anyone had any input on the most efficient way.
View 6 RepliesI want to make a form, which downloads a textfile from the internet. I found this method on the Microsoft Website:
My.Computer.Network.DownloadFile _
(..Adress Here.., ..Output here..)
this works for me
[Code]...
Application.StartupPath & "Data(the name & extension of each file)" I can change the file.txt with other links. But the file have to be in the Data folder.d.
I have created a text editor that enables the user to create and open both txt files and rich text files.When it comes to opening files, the text files are opening fine, but when it comes to rich text they are opening like this
{
tf1adeflang1025ansiansicpg1252uc1adeff31507deff0stshfdbch31506stshfloch31506stshfhich31506stshfbi31507deflang2057deflangfe2057 hemelang2057 hemelangfe0 hemelangcs0{fonttbl{f0fbidi fromanfcharset0fprq2{*panose 02020603050405020304}Times New Roman;}{f34fbidi fromanfcharset1fprq2{*panose 02040503050406030204}Cambria Math;}
[code]....
I am writing an app that writes notes, inserted by the user, to a txt file. The app saves that notes to a txt file, and when opening it reads the file and shows the already inserted notes. However, I want the user to be able to delete some of those notes...but I can't seem to do it...this is what I have:
VB
Dim file As New FileStream(data_path & "notes.txt", FileMode.Open)
Dim text As String = Nothing
Dim reader As New StreamReader(file)
[Code]....
It goes fine, but the text.Replace(value, "") line doesn't seem to work. I've also tried text.Remove(0) but it doesn't removes the line...it looks like it has no effect.
' total is a list
Dim string_array() As String
string_array = DirectCast(total.ToArray(GetType(String)), String())
[code].....
trying to create some kind of function to save all the labels and buttons caption of all forms of my proyect to a txt file. tried taking one by one to this file but the fact is that they are too much and it would be a really long proccess to do it that way so im looking for some way to do it automaticallythe structure of the file would be:Name of the form - name of the control - caption
View 30 RepliesI have 2 files:
1.) fname (original file)
2.) TempHeader.txt (Header)
In my program, I'm reading each file with the StreamReader, then prepending the header onto the original file to create a 3rd file which is the combination of the two. My problem is that the original file contains the following:
[Code]...
I have a simple byte array: Dim TheBuffer() As Byte={0,1,2,3} and I want to store it to a TEXT file. Is there any simple way of doing this? I want to enter the text file and see the array 0,1,2,3. don't want binary format etc.
View 3 RepliesI have a text file pwd.txt comma delimited, I added in project resources, now i want to read,edit and insert in text file.
View 1 Replies