Type: Posts; User: aspfun
Search took 0.02 seconds.
Thank you, techgnome.
I will learn this way.
Since I already spent a few days and almost getting there, I want to learn how to create datatable to complete the project.
The project will search...
I created a datatable(dt1) form a text file.
The third column store data like
How to code to split out date from one column to three columns in another...
In order to use SQL bulk insert command, I need to convert a text file (5mb) as below to a csv file
1) change "*" to "|" as field terminator
Thank both of you.
They are all working.
I completed reading text file into listbox. The data showing below:
How to export listbox data to datatable as showing like
I modified as below (adding one more column in range)it works but first column is " ".
Dim dt As New System.Data.DataTable()
'Add the first four columns
I tested it but got an error said "can not find column 4"
I got a project to read a text file in which there are about 5000 records. Below is a sample of data file.
In a page, there are one text box (textOrderby), one button and one gridview. (gridviewOrder)
I use dataset to bind gridview dynamically. Here is the code
dim SQL as string="select * from order...
I need to read a text file and then insert into a SQL server.
The text file is not in standard format as below.
It should be format like...
One text file in which first row is column's name.
The file include about 200 columns in first row.
How to code to make a empty table based on first row?
Text file delimiter separates by "|"...
I did transaction in SQL store procedure. It works fine.
How to add transaction in vb.net code?
For example, once a button clicking all subs and functions will run:
if function() = true then...
Once I added "process.waitforexit()" the problem was solved.
Thank you for help.
I created a button to run three subs A, B, C but every time it stops after running sub A which is running batch file.
Sub B and sub C never run.
How to fix it?
Private Sub A()
Please help me to complete code.
I created a datatable. I want to use two for loops to insert row by row and column by column from datatable (dt) into SQL table (Order).
For i = 0 To...
I used code below to upload datatable (from CSV) using sqlbulkcopy but got an error said "can't conversion string to decimal ..."
There are about 2 million row in which there are 290 columns to...
I use code to remove "" in datatable (dt) as below but don't work.
How to fix it? Need to add another code to update?
For i = 0 To dt.Rows.Count - 1
For j As Integer = 0 To dt.Columns.Count...
I used sqlbulcopy to upload datatable to sql but got an error said that "string convert to decimal error".
Since table has about 300 fields and the error don't indicate where the error is.
I create a datatable from csv file and then use sqlbulcopy to insert datatable into SQL server but got an error as below.
what is colid 1? How to find out which column having length problem?
I use code below to read csv file and upload to SQL.
Need two help:
1) Where to add code to remove double quotes (" ") in each cell?
2) Since first row is column name, how to skip first row?
I have to create a project to upload big csv file (3.5G, about 300 columns) into SQL server.
This csv file FIELDTERMINATOR =',' , text qualifier="" and first row is column name.
In fact, these two text files are using vedit to translate from ebcdic file. (2G)
First, I use vedit to split two ebcdic files and then translate into two text files.
In order to insert into SQL, I...
For processing reason, I need to split big text file into two files. One is from column 1 to 200 and another is from 201 to 1500.
How to code to merge these two files into one text file, that is...
I used IO.StreamReader and IO.StreamWriter to read EBCDIC and write to text file learning from below:
It works fine....
I was assigned a project to read binary data file (2G) and select data from OrderID, OrderDate and Price three columns (there are about 50 columns) into SQL table.
Where to start? Do I need to...
I used code below to send emails everyday from my pc automatically:
Dim myMail As New SmtpClient("email.hcpipa.com")
myMail.Credentials = New System.Net.NetworkCredential("mymail",...
I used code below to add OrderID from listbox and then remove this OrderID from listbox but remove code never work.
For i As Integer = 0 To lsbData.Items.Count - 1...
Thank you. It works great!
I need to split line from one big text file.(80MB)
For example, text file look like below
I need code to update it as below...
I need to create a vb.net program to read a text file (c:\order\order.txt, about 60MB) and search any ORDERID starting ***.
For example, text file look like
My asp.net program try to use a loop to insert data into a table. There are about 5000 records need to be inserted.
But for a while, I got an error message said:
Timeout expired. The timeout...
In SQL server, the following code is works to find out maximum number in SEQUENCE column.
SEQUENCE column is int type increasing by 1
select max(SEQUENCE) as MYSEQ from Order where ordernumber...
I can open this folder: \\myserver\order\myorder\ and all folders under myorder can list on the listbox1.
But the following code got an error said:
Access to the path '\\myserver\order\myorder\'...
Thank you for help but I got an error: skip is not member of system.array
I used code
to load claim info into listbox. It works fine.
There are about 20 columns in claim.txt.
How to code to load...
I created a asp.net program as http://mycompany.com/
I want whenever user clicks any link, such as
Private functiion Myfunction() as boolean
For i As Integer = 0 To listbox.Items.Count - 1
MmberFileName = Path.GetFileName(listbox.Items(i))
I created a function to return Boolean in which there are another 3 sub-functions.
All sub-function is return Boolean as well
Private functiion Myfunction() as boolean
For i As Integer = 0...
I found the answer.
Click Here to Expand Forum to Full Width
Survey posted by VBForums.