VB输出问题

[topyyii]

java中 比如这样的字符串 "现在正在插入第" + xlBook.Sheets.Count + 1 - k + "张表，一共有" + k + "张表"
在VB中 用 outtxt.Text = 该如何写

[水如烟]

"现在正在插入第" & (xlBook.Sheets.Count + 1 - k).ToString & "张表，一共有" & k.ToString & "张表"

[水如烟]

常用Format

outttxt.text = String.Format("现在正在插入第{0}张表，一共有{1}张表",xlBook.Sheets.Count + 1 - k,k)

[ejoe313]

outtxt.Text = "现在正在插入第【" & (xlBook.Sheets.Count + 1 - k).ToString & "】张表，一共有【" & k.ToString & "】张表" 

[tjficcbw]

你发的工程文件，我已经做好了，给你发过去了，你看一看有什么问题

[topyyii]

sqlString = "select personno from SBUserInfo where PERSONNO = '" & Trim(abca(1)) & "'"
If Rs.State = 1 Then Rs.Close
Rs.Open sqlString, Conn, adOpenKeyset, adLockOptimistic
If Rs.EOF Then
If Rs.State = 1 Then Rs.Close
sqlString = "insert into SBUserInfo (PERSONNO,PERSONNAME,UNITID,UNITNAME,SEX,PERSONID,BIRTHDAY,RETIREDATE,TEL,ADDR) values('" & Trim(abca(1)) & "','" & Trim(abca(2)) & "','" & Trim(abca(3)) & "','" & Trim(abca(4)) & "','" & Trim(abca(5)) & "','" & Trim(abca(6)) & "',to_date('" & abca(7) & "','YYYY-MM-DD') ,to_date('" & abca(10) & "','YYYY-MM-DD') ,'" & Trim(abca(18)) & "','" & Trim(abca(19)) & "')"
'Print sqlString
Conn.Execute sqlString
End If

这里 如果判断有重复的话 我应该吧updata的sql写在那里呢？

[水如烟]

啥意思呢