winfroms把ListView记录添加到数据库报错..
con = new SqlConnection("server=.\\sqlexpress;database=test;uid=sa;pwd=reyoung");
con.Open();
string str = "insert into book(uid,uname,date1) value(@u_id,@u_name,@momey)"; SqlCommand cmd;
cmd = new SqlCommand(str, con);
foreach (ListViewItem item in listView1.Items)
{
cmd.Parameters.AddWithValue("@u_id", item.Text);
cmd.Parameters.AddWithValue("@u_name", item.SubItems[1].Text);
cmd.Parameters.AddWithValue("@momey", item.SubItems[2].Text);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
报的错是未处理 System.Data.SqlClient.SqlException
Message="将截断字符串或二进制数据。\r\n语句已终止。"