Search Results - VBForums

Search:

Type: Posts; User: aspfun

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Copy data from one datatable to another datatable

    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...
  2. Copy data from one datatable to another datatable

    I created a datatable(dt1) form a text file.

    The third column store data like

    aaa,2012,693.20

    bbb,2013,55.02

    How to code to split out date from one column to three columns in another...
  3. Replies
    2
    Views
    109

    Convert text file to csv file

    In order to use SQL bulk insert command, I need to convert a text file (5mb) as below to a csv file

    35*20120527*WQ*1900.38@
    220*20131020*QQ*454@

    1) change "*" to "|" as field terminator

    2)...
  4. Replies
    3
    Views
    104

    Re: Listbox data into datatable

    Thank both of you.
    They are all working.
  5. Replies
    3
    Views
    104

    Listbox data into datatable

    I completed reading text file into listbox. The data showing below:

    AA*123*2014*156.56

    BB*999*2013*99.03

    How to export listbox data to datatable as showing like
    ...
  6. Replies
    6
    Views
    162

    Re: Read parcial text file into SQL table

    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
    ...
  7. Replies
    6
    Views
    162

    Re: Read parcial text file into SQL table

    I tested it but got an error said "can not find column 4"
  8. Replies
    6
    Views
    162

    Read parcial text file into SQL table

    I got a project to read a text file in which there are about 5000 records. Below is a sample of data file.

    @@@,35,20120527,WQ,1900.38*RRR,1K,300507861*RRR,D9,...
  9. Refresh data for gridview without reloading page

    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...
  10. Replies
    2
    Views
    118

    Convert not standard text file into SQL

    I need to read a text file and then insert into a SQL server.

    The text file is not in standard format as below.

    ABC, 12345,
    BBB,9988, PP
    ABC, 556699,
    CCC.8899,UU

    It should be format like...
  11. Replies
    2
    Views
    187

    Create a table from text file

    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 "|"...
  12. Replies
    3
    Views
    180

    Transaction in vb.net

    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...
  13. Re: After running batch file, app don't execute the rest of code

    Once I added "process.waitforexit()" the problem was solved.
    Thank you for help.
  14. After running batch file, app don't execute the rest of code

    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()
    Dim procInfo...
  15. Use two for loops to insert row by row and column by column from datatable to SQL

    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...
  16. Does sqlbulkcopy class have index to indicate where is error existing?

    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...
  17. Replies
    2
    Views
    190

    Remove "" don't work using replace

    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...
  18. How to upload datatable into SQL row by row and field by field ?

    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.

    How...
  19. Error:received an invalid column length from the bcp client for colid 1

    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?
    ...
  20. Replies
    1
    Views
    158

    CSV file to SQL questions

    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?
  21. Read CSV file and then upload into SQL server

    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.

    Questions:
    ...
  22. Replies
    3
    Views
    109

    Re: Merge two text files into one

    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...
  23. Replies
    3
    Views
    109

    Merge two text files into one

    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...
  24. Replies
    0
    Views
    118

    Add carriage return at EBCDIC file

    I used IO.StreamReader and IO.StreamWriter to read EBCDIC and write to text file learning from below:
    http://www.codeproject.com/Articles/31720/How-to-Read-an-EBCDIC-File-in-VB-NET

    It works fine....
  25. Replies
    2
    Views
    146

    Save binary data into SQL table

    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...
  26. Email error "Unable to read data from the transport connection: net_io_connectionclos

    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",...
  27. Replies
    1
    Views
    145

    Listbox remove never work in for loop

    I used code below to add OrderID from listbox and then remove this OrderID from listbox but remove code never work.

    Why?

    For i As Integer = 0 To lsbData.Items.Count - 1...
  28. Replies
    3
    Views
    148

    Re: Split line from big text file

    Thank you. It works great!
  29. Replies
    3
    Views
    148

    Split line from big text file

    I need to split line from one big text file.(80MB)

    For example, text file look like below

    ST*837*000008~BHT*0019*00*1*20140205*1020*RP~REF*87*004010X098~

    I need code to update it as below...
  30. Replies
    1
    Views
    127

    Read a text file and search for ORDERID

    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
    ...
  31. Thread: Timeout expired

    by aspfun
    Replies
    2
    Views
    133

    Timeout expired

    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...
  32. Replies
    1
    Views
    172

    Find out maximum sequence number?

    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...
  33. Access to the path '\\myserver\order\myorder\' is denied

    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\'...
  34. Re: How to code to load firs column only without column head?

    vs2010, 4.0
  35. Re: How to code to load firs column only without column head?

    Thank you for help but I got an error: skip is not member of system.array
  36. How to code to load firs column only without column head?

    I used code

    listbox1.Items.AddRange(IO.File.ReadAllLines("d:\claim.txt"))

    to load claim info into listbox. It works fine.

    There are about 20 columns in claim.txt.

    How to code to load...
  37. Replies
    2
    Views
    224

    Hide page url without url rewriting

    I created a asp.net program as http://mycompany.com/
    I want whenever user clicks any link, such as

    http://mycompany.com/order.aspx

    http://mycompany.com/bill.aspx
    ...
  38. Re: How to add a code to make "if error goto next"?

    Like below?


    Private functiion Myfunction() as boolean
    For i As Integer = 0 To listbox.Items.Count - 1
    MmberFileName = Path.GetFileName(listbox.Items(i))
    Try
    ...
  39. How to add a code to make "if error goto next"?

    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...
  40. Re: How to compile windows app to make exe file including all dll files?

    Never mind.
    I found the answer.

    http://stackoverflow.com/questions/10137937/merge-dll-into-exe
Results 1 to 40 of 387
Page 1 of 10 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.