如何实现更新多条语句？下面代码只适用于所有表的单笔记录更新操作
/// <summary>
        /// 更新表的字段值
        /// </summary>
        /// <param name="Tablename">表名</param>
        /// <param name="keyname">Key数组</param>
        /// <param name="keyvalue">Keyvalue数组</param>
        /// <param name="column">字段名数组</param>
        /// <param name="value">字段名对应值</param>
        /// <returns>成功与否</returns>
        public virtual bool      UpdateTableRow(string Tablename, string[] keyname, string[] keyvalue, string[] column, string[] value)
        {
            if(InteropHelper.HasEmsInterfaces) //如果要求跨平台数据集成
            {
                //这是一个示例，跨平台操作可能不能传递DataTable，那么需要修改接口
                return InteropHelper.UpdateTableRow(Tablename, keyname, keyvalue, column, value);
            }
            #if DEBUG
            try
            {
            #endif
                //没有传入数组或数组对应字段不等
                if (column.Length < 1 || column.Length != value.Length || keyname.Length != keyvalue.Length) return false;
                string sqlString = Tablename + " set ";
                for(int i = 0;i < column.Length; i++ )
                {
                    sqlString = sqlString + column[i] + " = '" + value[i] + "'," ;
                }
                //去掉逗号
                sqlString = sqlString.Substring(0, sqlString.Length - 1);
                if(keyname.Length > 0)
                {
                    sqlString += " where ";
                    for(int j = 0; j < keyname.Length; j++)
                    {
                        sqlString = sqlString + keyname[j] + "= '" + keyvalue[j] + "' and";
                    }
                    //去掉" and"
                    sqlString = sqlString.Substring(0, sqlString.Length - 4);
                }
                sqlConnect.Open();
                SqlCommand updateCmd = new SqlCommand("Update " + sqlString,sqlConnect);
                updateCmd.ExecuteNonQuery();
                sqlConnect.Close();
                return true;　//更新成功
            #if DEBUG
            }
            catch(Exception e)
            {
                sqlConnect.Close();
                ProcessLog("Error at UpdateTableRow:" + e);
                return false;  //更新失败
            }
            #endif
        }




要如何实现多笔记录的更新操作呢？