就是比如 “你好,{0}”,张三 ,字符串就能拼成 “你好,张三”
拼insert语句,用 & 太累了,尤其字段多的时候
------解决思路----------------------
用数组看看是不是方便一些呢
Dim fArr As String() = {"name", "Age", "add"}
Dim vArr As String() = New String((fArr.Length) - 1) {}
vArr(0) = "'张三'"
vArr(1) = "20"
vArr(2) = "'北京东路1号'"
Dim sql As String = "insert into Table (" & String.Join(",", fArr) & ") values (" & String.Join(",", vArr) & ")"
------解决思路----------------------
s = string.Format("你好,{0}”,张三)
------解决思路----------------------
真的是就为了问占位符?
Dim name As String = "'张三'", age = "20"
Dim sql As String = String.Format("insert into Table (name,age) values ({0},{1})", name, age)