I receive this error using the following code when the executeNonquery() line I am trying to load data from refnum to a column in the table
The variable name '@refnum' has already been declared. Variable names must be unique within a query batch or stored procedure.[code]...
what i need to do is to get some data from sqlserver and send it to a dataset(no problem there) after i get the dataset filled i need to send the columns and rows to a textfile but i have to separate the columns on the dataset with this "|"
View 2 RepliesI'm trying to write a jukebox application as part of my undergraduate coursework at university, and have hit a brick wall. Using while loops, I'm trying to display tracks/songs under particular genres, as listed in a simple text file, from which the programme reads.The issue is, although I can get the columns to be named after the appropriate genres, as stated in the text file, the songs are read, and placed in the first column, regardless. I can't seem to get them to move to the next column, when the previous genre is finished.[code]
View 15 RepliesI have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 RepliesI'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
currently i need to use 4 different texts files in order to read data and run my program, is there any way that i can just use 1 text file or 1 excel spreadshee
Dim File1 As New System.IO.StreamReader("C:Documents and SettingsUserDesktopWindDirectionLanding.txt") 'Calling out the file.
Dim File2 As New System.IO.StreamReader("C:Documents and
[code].....
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
I'm trying to figure out how to load a textfile into a listbox. On button click it would pop up a window where you'd browse to the folder and file and then select it and it would populate the listbox.[code]...
View 1 RepliesI've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
Averaging columns in a table - ignoring certain columns
View 2 RepliesI have a textfile which is in the following format.
[code]...
There are only 5 rows and two columns. each field is seperated by a space (" ") What I'm trying to do is display column 2 value 1 in textbox1, column 2 value 2 in textbox2, column 2 value 3 in textbox3,column 2 value 4 in textbox4 and column 2 value 5 in textbox5.
Imports System.ComponentModel
Imports System.Drawing
Imports System.Windows.Forms
Imports System.IO
[code]....
I want read the content of the text file and write to vb.net application. My text file name is wires.txt. The above code only read and the file appear on the application. I dont want the file to be visible to the end user.
[code] I'm trying to load a textfile with (formatted, mostly tab delimited) data, into an arrayList.To manipulate and extract certain data I was able to search through the arrayList and retrieve the needed data.This is what's not working: If I have found my needed data in certain places from the arrayList, I would like to split this to read the needed values. Trying to do this I constantly get string cannot be converted to 1-dimensional array of string errors. [code]
View 4 RepliesI have a program which reads data from a textfile line by line, but I would like to make some kind of update system and link the program to a website.
So how can I read a textfile from a website with streamreader?
I'm trying to place the contents of a text file (just a list of names) into a list box when the form loads.
My code currently looks like this:
Imports System.IO
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I can get the names into the list box, but they're all on one line. I thought about using a For...Next loop to read the contents of the text file, but I got into all sorts of trouble; do I need an array with that method? So I've got back to the code I originally had.
I am trying to make a program that can read each line of a textfile and print it into something else. So lets say i have a text file that has:
[Code]...
I have a form with 2 listboxes. I've added items in each listbox. I save all the items from each listbox to a text file. What I want to do is open the text file and I want each string inside the text file to go to the appropriate listbox. How can I make my program recognize where each string belongs?
View 16 RepliesI have my code it is able to read a text file and do checks each line if there are 7W and 5L in that particular line, if no matches it will remove that line... 1 problem i face now is that, there are duplicates in my textfile..Im not sure how am i going to remove the duplicate in the text file. I want to know if there is a way to integrate an additional function inside my code to check if that particular line is a duplicate so i can accomplish 2 tasks at 1 time... Since there are about close to 1million records in my text file.
[Code]....
I have this class:
Public Class ProxyHelper
Private Shared proxyQueue As New Queue(Of System.Net.WebProxy)()
' Just holds the number of times we've asked for a proxy.
[Code]....
This will ask for one proxy each time my webclient does something five times.
My webclient simply downloads some data and views it from a webpage over and over, and after 5 times you will get banned.
Question: How can I make the above code ask for a proxy from a textfile with one proxy on each line?
I will not have a browse function, the proxies.txt will always be in the app.dir
How would i read a textfile that is in My.Resources and put the whole document in a textbox for the user to see?
I figured i would need a IO.StreamReader and a IO.StringReader but cant figure out too much what to do with these.
I figured i could create a loop until it has read to the end of the document but there is no check called HasLineAvailable or something.
I have a txt document here that have certain word on it per line. How can I show it in different labels. I have 25 labels and have label name as followsword1,word2,word3,word4,word5 and so on up to word25. I want the word 1 label will show the first line of the text file and the second word2(label name) will show the second line of the textfile and so on up to the 25th line . Can it be done using loop?I tried but I dont know exactly how readline process works to identify certain lines you want to read and also I tried using the "i" variable to auto generate the name of my label but it did not work.
Dim timepath As String = "C:ACCOUNTSAccount" + user1 + " ime.text"
Dim times As String
Dim timeread As New System.IO.StreamReader(timepath)
[code].....
I have a Textfile "C:Holiday.txt" where the data is stored line by line.
[Code]...
I would like to read this data into a datagrid , (2 Columns), edit it, and save it again.
I have multiple textbox,I want all of them to read whats inside a text file,but I dont want multiple text files,I just want one.
Here is my code that lets you read a whole text file.
vb.net
Dim FILE_NAME As String = "Directory"
If System.IO.File.Exists(FILE_NAME) = True Then
Dim objReader As New System.IO.StreamReader(FILE_NAME)
[code]....
But I just want it to read certain lines For Example on textbox1 should only read the line <vote>texthere</vote> and so on,
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
i'm using vs2010 i'm trying to update access table from text file that problem is that the 3rd column of the table is memo which wrote in many line in the text file i tried alot but didnt figure away to make it done this is my code so far
vb
Dim message As String
Dim lineindex As Integer = 0
Dim objStreamReader As StreamReader = File.OpenText(OpenFileDialog1.FileName)
[Code].....
What I am trying to do may be better for use with SQL Server but I have seen many applications in the past that simply work on text files and I am wanting to try to imitate the same behaviour that those applications follow. I have a list of URL's in a text file. This is simple enough to open and read line by line, but how can I store additional data from the file and query the data?
E.g.
Text File:
link1 - 0
link2 - 0
link3 - 1
link4 - 0
link5 - 1
Then I will read the data with:
Private Sub ButtonX2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX2.Click
OpenFileDialog1.Filter = "*txt Text Files|*.txt"
If OpenFileDialog1.ShowDialog() = DialogResult.OK Then
Dim AllText As String = My.Computer.FileSystem.ReadAllText(OpenFileDialog1.FileName)
Dim Lines() = Split(AllText, vbCrLf)
[Code] .....
Am I going completely the wrong way about storing the data after importing from a text file?
I have a textfile I need to open and I need to put each line into the array. What is the simplest way to add the elements/each line's data into the array while increasing the array as it reads each line? This is blowing my mind right now..I thought about using a counter and then redim-ing the array (while preserving of course).
View 3 RepliesThis is my first time using a list vs an array but I'm having a bit of trouble. I am trying to read a textfile into a list of song objects. I am reading the file successfully into the list however after the loop ends the program stops executing the load event and ignores the populateListBox() procedure. Any thoughts.
[Code]...
I am trying to read a value of a sunbkey in the registry and write to txtfile. Problem is I only get the name of the key and not the value. Any ideas
Code:
how do i have my app read a line from a textfile and if that line equals "whatever" proceed with command, this case a msgbox.so much work to do and so many choices to choose from...
View 3 Replies
