[問題] ExecuteNonQuery()
就是我寫一個簡單的insert只令到mssql
public void connectionCommand()
{
SqlConnection conn = new
SqlConnection("server=localhost;pwd=.;user=sa;database=peopleSearch");
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Employee_name
(name,birth,hire) values (" + this.TextBox1.Text + "," + this.TextBox2.Text +
"," + this.TextBox3.Text + ")", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
那我在寫入資料庫的時候只能寫入數字?
不能寫入中文或是文字之類的嗎?
我的資料表都是設成char
用.net2005 sql2000
但是我以前用.net2003都沒這問題耶
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 125.225.102.177
推
12/01 18:46, , 1F
12/01 18:46, 1F
推
12/01 20:18, , 2F
12/01 20:18, 2F
→
12/01 21:03, , 3F
12/01 21:03, 3F
推
12/08 01:20, , 4F
12/08 01:20, 4F
C_Sharp 近期熱門文章
PTT數位生活區 即時熱門文章
