Search Results - VBForums

Search:

Type: Posts; User: aspfun

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    135

    Looking for the best way to retrieve data

    There is a table (tblQuestion) which stored QuestionID and answers like below. (About 300 questions)

    QuestionID---Answer

    00001--------AAA

    00002--------BCC

    .....................
  2. Replies
    5
    Views
    296

    PDF converter and merge

    I need to create a project to convert word files to PDF files and merge a few pdf file to one PDF file using VS2010. (vb.net and asp.net)

    Which product (SDK/Component) should I purchase? (not...
  3. Help to complete multiple order ID selection. Does it need loop?

    I used code below to export Crystal Report to pdf file. (displays on the screen).

    It works fine for one OrderID like SQL statement below.

    Dim sSQL As String = "select * from order where...
  4. Replies
    9
    Views
    195

    Re: Read a text file and grab OrderID

    File is something like below. OrderID are located anywhere in the file.
    ...
  5. Replies
    9
    Views
    195

    Re: Read a text file and grab OrderID

    Thank you for help.
    The problem is that there are a few characters like "~", "-" after OrderID.
    How to code to read only 16 characters after "ADR*XYZ*" and insert them into array one by one?
  6. Replies
    9
    Views
    195

    Read a text file and grab OrderID

    There a lot of OrderID within a big text file.
    The OrderID format is like below:(OrderID is 16 characters after ADR*XYZ*)

    ADR*XYZ*2015123456BH0001
    ADR*XYZ*2015113955AB0002

    How to code to grab...
  7. Replies
    3
    Views
    236

    Re: Multiple steps questions

    Thank you for help.
    I am really intresting in learning transaction in app code. (not in SQL store procedure)
    Is there any source to learn from sample code?
  8. Replies
    3
    Views
    236

    Multiple steps questions

    Multiple steps questions
    a few seconds ago|LINK

    In my member registration page, I want to create steps like below:

    1) if (member's info inserted into SQL server successfully) then

    2) if...
  9. Replies
    1
    Views
    211

    How to find out real error?

    What is the best way to track error? I used code below, but user always receive "Fail to submit".

    How to find out real error?

    Try

    If EmailOut(strEmail, strPassword) Then // this is a...
  10. 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...
  11. 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...
  12. Replies
    2
    Views
    330

    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)...
  13. Replies
    3
    Views
    273

    Re: Listbox data into datatable

    Thank both of you.
    They are all working.
  14. Replies
    3
    Views
    273

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

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

    Re: Read parcial text file into SQL table

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

    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,...
  18. 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...
  19. Replies
    2
    Views
    234

    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...
  20. Replies
    2
    Views
    355

    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 "|"...
  21. Replies
    3
    Views
    351

    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...
  22. 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.
  23. 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...
  24. 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...
  25. 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...
  26. Replies
    2
    Views
    279

    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...
  27. 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...
  28. 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?
    ...
  29. Replies
    1
    Views
    271

    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?
  30. 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:
    ...
  31. Replies
    3
    Views
    221

    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...
  32. Replies
    3
    Views
    221

    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...
  33. Replies
    0
    Views
    215

    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....
  34. Replies
    2
    Views
    242

    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...
  35. 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",...
  36. Replies
    1
    Views
    270

    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...
  37. Replies
    3
    Views
    251

    Re: Split line from big text file

    Thank you. It works great!
  38. Replies
    3
    Views
    251

    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...
  39. Replies
    1
    Views
    249

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

    by aspfun
    Replies
    2
    Views
    255

    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...
Results 1 to 40 of 396
Page 1 of 10 1 2 3 4



Featured


Click Here to Expand Forum to Full Width