Search Results - VBForums

Search:

Type: Posts; User: aspfun

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    156

    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...
  2. 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.
  3. 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...
  4. 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...
  5. 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...
  6. Replies
    2
    Views
    173

    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...
  7. 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...
  8. 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?
    ...
  9. Replies
    1
    Views
    141

    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?
  10. 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:
    ...
  11. Replies
    3
    Views
    103

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

    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...
  13. Replies
    0
    Views
    103

    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....
  14. Replies
    2
    Views
    131

    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...
  15. 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",...
  16. Replies
    1
    Views
    130

    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...
  17. Replies
    3
    Views
    133

    Re: Split line from big text file

    Thank you. It works great!
  18. Replies
    3
    Views
    133

    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...
  19. Replies
    1
    Views
    116

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

    by aspfun
    Replies
    2
    Views
    124

    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...
  21. Replies
    1
    Views
    154

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

    vs2010, 4.0
  24. 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
  25. 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...
  26. Replies
    2
    Views
    209

    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
    ...
  27. 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
    ...
  28. 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...
  29. 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
  30. How to compile windows app to make exe file including all dll files?

    In my develop pc, I installed itextsharp so there are itextsharp.dll and itextsharp.xml in debug folder.
    I ran app and created a myapp.exe. Once I copied myapp.exe to another pc, an error occurred...
  31. Replies
    1
    Views
    145

    Convert word to pdf

    I used code below to convert word to pdf but if the doc file is opened by another user program will stop.

    How to fix it?...
  32. A function return a dataset do not work in for loop

    I use a function to return dataset in which passing a store procedure and MereberID.

    It works fine for calling one time but once in for loop, it only works for first loop.

    When i=0, it works...
  33. Replies
    4
    Views
    392

    Re: Convert word to pdf

    I use your code to create a project using loop to convert all doc file in a folder.
    There is an error said "xxx file is read only"/"xxx file was locked".
    It seems to me that file is not closed....
  34. Replies
    1
    Views
    145

    Close word document

    I copied code from

    http://www.vbforums.com/showthread.php?774585-Convert-word-to-pdf

    as below. First time is ok but second time got an error said that "file was locked...by user....".
    How to...
  35. Replies
    2
    Views
    185

    List files in one folder but got an error

    I use code below to list files in listbox1 but an item "~$0020419.doc" was listing there. I reboot pc but no luck. Why?

    In C:\test\, there are only 3 files: 100020419.doc, 100025818.doc and...
  36. Replies
    4
    Views
    392

    Re: Convert word to pdf

    Thank you for help. Once I install word 2010, it is working now.
    My project need to merge two pdf files, one is from Crystal report and another is from word.
    Is it possible to output to...
  37. Replies
    4
    Views
    392

    Convert word to pdf

    I use code below to convert word file to pdf file but never have luck and no error as well.
    Is there something need to update?

    Private Sub Word2PDF(ByVal wordFilePath As String, ByVal...
  38. Thread: Merge PDF files

    by aspfun
    Replies
    1
    Views
    179

    Merge PDF files

    In my vb.net project I need to merge two PDF files.

    1) One is from crystal report which export as A.PDF. This part was finished.

    2) Another is from word file. I need to code to read doc file...
  39. Code to embedding DOC's dynamically in Crystal Reports

    I was assigned a project which need to do the following jobs:

    1) Print cover letter in which display member name and address based on memberID in Member table (Done)

    2) Using the same memberID...
  40. Replies
    1
    Views
    191

    Alternate row color in blank line

    I designed to print 20 lines in detail section.


    If records are 53 lines the report will print 3 pages.


    I code in CR detail section to make Alternate Row Color


    if recordnumber mod 2 =0...
Results 1 to 40 of 376
Page 1 of 10 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.