字串組法

     
        Dim id As String = "8"
        Dim desc As String = "aaabb"

1. cmd.CommandText ="insert into region values(" & id & ",'" & desc & "')"
2. cmd.CommandText =String.Format( "insert into region values({0},'{1}')", id, desc)
3. Parameters

cmd.CommandText = "insert into region values(@id,@desc)"

cmd.Parameters.AddWithValue("@id", id)

cmd.Parameters.AddWithValue("@desc", desc)