以前都是用SQL语句做的,第一次用存储过程,大家帮个忙..谢啦./
我就是想调用存储过程往数据库中添加记录..代码如下,但都是提示连接数据库出错.哪里出了问题呢???

string myStr = "Data Source=服务器;Initial Catalog=数据库;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(myStr);
try
{
conn.Open();

SqlCommand myCom = new SqlCommand("InsertBuyIn",conn);
myCom.CommandType = CommandType.StoredProcedure;

myCom.Parameters.Add("@Item_code",SqlDbType.VarChar,50);
myCom.Parameters.Add("@Item_type", SqlDbType.VarChar, 50);
myCom.Parameters.Add("@Item_name", SqlDbType.VarChar, 50);
myCom.Parameters.Add("@Buy_quantity", SqlDbType.Int, 4);
myCom.Parameters.Add("@Buy_price", SqlDbType.Decimal, 9);
myCom.Parameters.Add("@Buyer", SqlDbType.VarChar, 50);
myCom.Parameters.Add("@Buy_time", SqlDbType.DateTime, 8);
myCom.Parameters.Add("@Down_limited", SqlDbType.Int, 4);
myCom.Parameters.Add("@Remark", SqlDbType.VarChar,60);

myCom.Parameters["@Item_code"].Value = textBox1.Text;
myCom.Parameters["@Item_type"].Value = textBox2.Text;
myCom.Parameters["@Item_name"].Value = textBox3.Text;
myCom.Parameters["@Buy_quantity"].Value = textBox4.Text;
myCom.Parameters["@Buy_price"].Value = textBox5.Text;
myCom.Parameters["@Buyer"].Value = textBox6.Text;
myCom.Parameters["@Buy_time"].Value = comboBox1.Text;
myCom.Parameters["@Down_limited"].Value = textBox7.Text;
myCom.Parameters["@Remark"].Value = textBox8.Text;

myCom.ExecuteNonQuery();
}
catch
{
MessageBox.Show("连接数据库出错！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.Cursor = Cursors.Default;
return;
}

conn.Close();

SqlConnection cn = new SqlConnection(ConfigurationSettings.AppSettings["ConString"]);
try
{
SqlCommand cm = new SqlCommand("yqdj_insert",cn);
cm.CommandType = CommandType.StoredProcedure;

cm.Parameters.Add("@sjdh",Textbox1.Text.ToString().Trim());

cm.Parameters.Add("@sbmc",Textbox2.Text.ToString().Trim());

cm.Parameters.Add("@dwid",Convert.ToInt32(DropDownList1.SelectedValue));

cm.Parameters.Add("@sbxh",Textbox3.Text.ToString().Trim());

cm.Parameters.Add("@sbno",Textbox4.Text.ToString().Trim());

cm.Parameters.Add("@sbcount",Convert.ToInt32(Textbox5.Text.ToString().Trim()));

cm.Parameters.Add("@djperson",Textbox7.Text.ToString().Trim());

cm.Parameters.Add("@jyjz",Convert.ToInt32(RadioButtonList1.SelectedValue));

cm.Parameters.Add("@ssks",Convert.ToInt32(DropDownList2.SelectedValue));

cm.Parameters.Add(new SqlParameter("ReturnValue",SqlDbType.Int));
cm.Parameters["ReturnValue"].Direction = ParameterDirection.ReturnValue;
cn.Open();
cm.ExecuteScalar();
int result = Convert.ToInt32(cm.Parameters["ReturnValue"].Value.ToString());
switch(result.ToString())
{
case "0":
qiao.Value="ok";


Textbox1.Text="";
Textbox2.Text="";
Textbox3.Text="";
Textbox4.Text="";
Textbox5.Text="";
Textbox7.Text="";
break;
case "1":
qiao.Value="error";break;
case "2":
qiao.Value="max";break;
case "3":
qiao.Value="haved";break;
}
}
catch(Exception ex)
{
if(cn.State == ConnectionState.Open)
cn.Close();
qiao.Value="error11";
PublicUnit.SaveError(ex,this.Context,this.Request);
}
finally
{
cn.Close();
}
你看看能不能借鉴一下