存储过程DT参数

  public static void TableValuedToDB(DataTable dt, string storedProcName, string TypeName)
        {
            using (SqlConnection connection = DBConnectionFactory.newConnection(connectionString))
            {
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }
                try
                {
                    if (dt != null && dt.Rows.Count != 0)
                    {
                        SqlCommand cmd = new SqlCommand(storedProcName, connection);
                        cmd.CommandType = CommandType.StoredProcedure;
                        SqlParameter tvpParam = cmd.Parameters.AddWithValue(TypeName, dt);
                        tvpParam.SqlDbType = SqlDbType.Structured;

                        // Execute the command.
                        cmd.ExecuteNonQuery();
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    DisposeConnection(connection);
                }

            }
        }