ASP.NET使用Command对象向数据库批量插入记录（十条）

for (j = 0; j < 10; j++)
                {
                    if (dor[j] != "" && EPre[j] != "" && ECurrent[j] != "")
                    {
                        string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                        SqlConnection sqlconn = new SqlConnection(sqlconnstr);
                        //建立Command对象
                        SqlCommand sqlcommand = new SqlCommand();
                        sqlcommand.Connection = sqlconn;
                        //赋值之前先清一下参数变量里面的值 
                        sqlcommand.Parameters.Clear();

                        //把Sql语句赋给Command对象
                        sqlcommand.CommandText = "insert into ElecUse(DorNumber,BuildingName,EPrevious,ECurrent,EDate,EmID,EStandard,ESPrice)values(@DorNumber,@BuildingName,@EPrevious,@ECurrent,@EDate,@EmID,@EStandard,@ESPrice)";
                        sqlcommand.Parameters.AddWithValue("@DorNumber", dor[j]);
                        sqlcommand.Parameters.AddWithValue("@BuildingName", Building);
                        sqlcommand.Parameters.AddWithValue("@EPrevious", EPre[j]);
                        sqlcommand.Parameters.AddWithValue("@ECurrent", ECurrent[j]);
                        sqlcommand.Parameters.AddWithValue("@EDate", txtDate.Text);
                        sqlcommand.Parameters.AddWithValue("@EStandard", Standard);
                        sqlcommand.Parameters.AddWithValue("@ESPrice", Price);
                        sqlcommand.Parameters.AddWithValue("@EmID", EmID);
                        try
                        {
                            //打开连接
                            sqlconn.Open();
                            //执行SQL命令
                            sqlcommand.ExecuteNonQuery();

                            ScriptManager.RegisterStartupScript(this, this.GetType(), "u1", "alert('成功增加记录')", true);
                        }
                        catch (Exception ex)
                        {
                            Label1.Text = "错误原因：" + ex.Message;
                            ScriptManager.RegisterStartupScript(this, this.GetType(), "u1", "alert('增加记录失败')", true);
                        }
                        finally
                        {
                            sqlcommand = null;
                            sqlconn.Close();
                            sqlconn = null;
                        }
                    }
                }

界面## 标题 ##如下：

如果出现如下错误：
**变量名在查询批次或存储过程内部必须唯一
则写上这句话
//赋值之前先清一下参数变量里面的值
sqlcommand.Parameters.Clear();