基于上次代码,另外加了一个Textbox控件,分别在1\2\3初添加了代码:
// 1
string PartID = TextBox1.text;
string sql = string.Format("insert into 曲柄轴({0}) values({1})", string.Join(",", Alps), string.Join(",", Alps.Select(item=>"@"+item)));
//2
string sql2 = "insert into 曲柄轴(零件ID)values('" + PartID + "')";
using (SqlConnection con = new SqlConnection(@"server=.\sql2019;database=testdb;integrated security=true;"))
{
// 3
SqlCommand cmd = new SqlCommand(PartID+sql, con);
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.commandText = PartID;
for (int i = 0; i < nums.Length; i++)
{
cmd.Parameters.AddWithValue("@" + Alps[i], nums[i]);
}
con.Open();
int result = cmd.ExecuteNonQuery();
}
但是零件ID 和后面的数值不在同一列,如图: