我有一個從 Web 表單傳遞的字串：
ABC_12345;DEF_78901
如何獲取每個值的前綴，然后將它們組合起來并傳遞給 SQL 'ABC'，'DEF'
uj5u.com熱心網友回復：
首先將字串拆分為陣列
Dim DBSplit1() As String
DBSplit1 = YourString.Split(";")
'Then get the the Prefix of you string
Dim Result As New List(Of String)
For Each item As String In DBSplit1
Dim rs As String = item.Substring(0, 3)
Result.Add(rs)
Next
'Then join the list of string with comma
Dim StringResult As String = String.Join(", ", Result.ToArray())
uj5u.com熱心網友回復：
我建議看看這個。要組合它們，您可以將它們包含在查詢中，同時像這樣插入它們：
Dim Query As String
Query = "INSERT INTO `schema`.`table` (column_name) values ('" & first & last &"');"
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/503745.html
標籤：VB.net
下一篇：將孩子移出面板