CREATE  PROCEDURE sheji_tongyininsert
(
@hao varchar(20),
@hao2 varchar(20)
)
 AS
insert sheji_tongyin(序号,单号,货号,刀模名称,长度,宽度,寸长,寸宽,出数,用料,说明,状态,日期) select 序号,单号,货号,刀模名称,长度,宽度,寸长,寸宽,出数,用料,说明,

状态,日期 from sheji_tong where 货号=@hao and 单号=@hao2
GO


可以在查询分析器可以,窗体上就是插入不了,如果单个参数又可以,两个参数就是不行.我的代码如下:

conn.Close();
string directory1 = Directory.GetCurrentDirectory() + "\\aa.ini";
IniFile db1 = new IniFile(directory);
SqlConnection conn1 = db1.GetDBConn();
conn1.Open();

SqlCommand mycmd1 = new SqlCommand("sheji_tongyininsert", conn);
= CommandType.StoredProcedure;

mycmd1.Parameters.Add("@hao", SqlDbType.VarChar);
mycmd1.Parameters["@hao"].Value = toolStripTextBox1.Text.Trim();
cm.Parameters.Add("@hao2", SqlDbType.VarChar);
cm.Parameters["@hao2"].Value = toolStripTextBox3.Text.Trim();
mycmd1.Connection.Open();
mycmd1.ExecuteNonQuery();
mycmd1.Connection.Close();

conn.Close();
string directory1 = Directory.GetCurrentDirectory() + "\\aa.ini";
IniFile db1 = new IniFile(directory);
SqlConnection conn1 = db1.GetDBConn();
conn1.Open();

SqlCommand mycmd1 = new SqlCommand("sheji_tongyininsert", conn);
= CommandType.StoredProcedure;

mycmd1.Parameters.Add("@hao", SqlDbType.VarChar);
mycmd1.Parameters["@hao"].Value = toolStripTextBox1.Text.Trim();
mycmd1.Parameters.Add("@hao2", SqlDbType.VarChar);
mycmd1.Parameters["@hao2"].Value = toolStripTextBox3.Text.Trim();
mycmd1.Connection.Open();
mycmd1.ExecuteNonQuery();
mycmd1.Connection.Close();

感觉应没什么问题呀...