大家帮我看看有什么问题!

[qlxiandao]

SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;User Instance=True";
conn.Open();
String commstr = "insert into rksheet([spname],[dj],[zj],[rktime],[bz],[rksl]) values(@sp,@dj,@zje,@rktime,@bz,@rksl)";
SqlTransaction tran =conn.BeginTransaction();
SqlCommand comm = new SqlCommand(commstr,conn);
try
{
comm.Parameters.Add("@sp",SqlDbType.NVarChar).Value = textBox1.Text;
comm.Parameters.Add("@dj", SqlDbType.Int).Value = textBox2.Text;
comm.Parameters.Add("@rksl",SqlDbType.Int).Value = textBox3.Text;
comm.Parameters.Add("@bz",SqlDbType.NVarChar).Value = textBox4.Text;
int zj = new int();
int dj = Convert.ToInt16(textBox2.Text);
int rksl =Convert.ToUInt16(textBox3.Text);
zj = dj * rksl;
comm.Parameters.Add("@zje",SqlDbType.Int).Value = zj;
comm.Parameters.Add("@rktime",SqlDbType.DateTime).Value = DateTime.Now;
comm.ExecuteNonQuery();
tran.Commit();
MessageBox.Show("数据添加成功！");

}
catch
{
tran.Rollback();
MessageBox.Show("数据添加失败！");
}
finally
{
conn.Close();
conn.Dispose();
tran.Dispose();
comm.Dispose();
}

[trainli]

不明白你出了什么bug
comm.Parameters.Add("@bz",SqlDbType.NVarChar).Value = textBox4.Text;
改（补上大小）：
comm.Parameters.Add("@bz",SqlDbType.NVarChar，200).Value = textBox4.Text;

[qlxiandao]

BUG就是添加数据显示"添加数据成功"!但是数据库中却没有添加的数据!很郁闷!请高手解决!

[yseet]

comm.Parameters.Add("@dj", SqlDbType.Int).Value = Convert.ToInt16(textBox2.Text);
comm.Parameters.Add("@rksl",SqlDbType.Int).Value = Convert.ToInt16(textBox3.Text);


试试吧...