Type: Posts; User: aspfun
Search took 0.02 seconds.
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.
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...
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?...
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...
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....
I copied code from
as below. First time is ok but second time got an error said that "file was locked...by user....".
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...
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...
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...
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...
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...
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...
Click Here to Expand Forum to Full Width
Survey posted by VBForums.