Re: [.NET] 按下button刪除資料列

[fumizuki (矇面加菲獅)]

cmdstr = "DELETE FROM member WHERE ID = '" & SqlStr(TextBox1.Text) & "'"
cmd1.CommandText = cmdstr


---

Function SqlStr(ByVal value As String) As String

    Return Replace(value, "'", "''")

End Function

--
                                ▃▅▇▆▄                         ▆▂▃  `  
逝去感情如何能留住，半點癡情遺留殊不易，██▅▇▄▃                ▇▃▂"  .
                                    █████████▃i              ▁▄▇ 
              更多悽悽慘慘的遭遇…………██▆▃                █▅▆▃ˍ▄* 
                                                 ◢           ▂█▄▇▅▂▌. 
我不知道，王～八～蛋～～！           ▂▆███    █▄▃  。fumizuki。Check。

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 123.194.224.174
推 siaujan:恩..所以還是得寫個function  謝謝了<0>