如何利用VS所生成的Insert语句插入数据?
private void dosubmit_Click(object sender, System.EventArgs e)
{
try
{
sqlInsertCommand1.Parameters["@InTime"].Value = DateTime.Now;
sqlInsertCommand1.Parameters["@period"].Value = periodbox.Text;
sqlInsertCommand1.Parameters["@dept"].Value = deptlbl.Text;
sqlInsertCommand1.Parameters["@CardType"].Value = CardType.SelectedItem.Value.ToString();
sqlInsertCommand1.Parameters["@MailTel"].Value = tel.Text;
sqlInsertCommand1.Parameters["@STel"].Value = subtel.Text;
sqlInsertCommand1.Parameters["@TotalBalance"].Value = Convert.ToDecimal(totalbox.Text);
sqlInsertCommand1.Parameters["@CallF"].Value = Convert.ToDecimal(CallF.Text);
sqlInsertCommand1.Parameters["@BeCalled"].Value = Convert.ToDecimal(BeCallF.Text);
sqlInsertCommand1.Parameters["@BusFee"].Value =Convert.ToDecimal(TFF.Text);
sqlInsertCommand1.Parameters["@Monternet"].Value = Convert.ToDecimal(MF.Text);
sqlInsertCommand1.Parameters["@VoiceFee"].Value = Convert.ToDecimal(YYF.Text);
sqlInsertCommand1.Parameters["@UsedSell"].Value = autosell.SelectedItem.Value.ToString();
sqlInsertCommand1.Parameters["@UseCallPay"].Value = CallPay.SelectedItem.Value.ToString();
sqlInsertCommand1.Parameters["@Other"].Value = OtherBox.Text;
sqlConnection1.Open();
sqlInsertCommand1.ExecuteScalar();
sqlConnection1.Close();
}
catch(Exception ex)
{
Response.Write(ex);
}
}
但按动Button后数据没有插入,也没有产生异常,请问错在哪里?
Insert语句是在VS通过托入DataAdapter自动生成的,应该没有问题。